当前位置:编程学习 > 网站相关 >>

How to move ASM spfile to a different disk group

Copy spfile with -u option - to update GPnP profile in RAC environment
[grid@zhongwc1 ~]$ asmcmd lsdg  
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name  
MOUNTED  EXTERN  N         512   4096  1048576      5120     4716                0            4716              0             Y  CRS/  
MOUNTED  NORMAL  N         512   4096  1048576     61440    56882                0           28441              0             N  DATADG/  
MOUNTED  NORMAL  N         512   4096  1048576     51200    48726                0           24363              0             N  FRADG/  
[grid@zhongwc1 ~]$   
[grid@zhongwc1 ~]$   
[grid@zhongwc1 ~]$ asmcmd spget  
+CRS/cluster/asmparameterfile/registry.253.805303687  
[grid@zhongwc1 ~]$   
[grid@zhongwc1 ~]$   
[grid@zhongwc1 ~]$ asmcmd spcopy -u +CRS/cluster/asmparameterfile/registry.253.805303687 +DATADG/spfileASM.ora  
[grid@zhongwc1 ~]$   
[grid@zhongwc1 ~]$ asmcmd  
ASMCMD> ls -l  
State    Type    Rebal  Name  
MOUNTED  EXTERN  N      CRS/  
MOUNTED  NORMAL  N      DATADG/  
MOUNTED  NORMAL  N      FRADG/  
ASMCMD> cd datadg  
ASMCMD> ls -l  
Type              Redund  Striped  Time             Sys  Name  
                                                    Y    ZHONGWC/  
                                                    Y    cluster/  
                                                    N    spfileASM.ora => +DATADG/cluster/ASMPARAMETERFILE/REGISTRY.253.805563565  
 
Restart the HA stack to verify that ASM starts up fine with copiedspfile
[root@zhongwc1 ~]# /u01/app/11.2.0/grid/bin/crsctl stop has  
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'zhongwc1'  
CRS-2673: Attempting to stop 'ora.crsd' on 'zhongwc1'  
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'zhongwc1'  
CRS-2673: Attempting to stop 'ora.cvu' on 'zhongwc1'  
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'zhongwc1'  
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'zhongwc1'  
CRS-2673: Attempting to stop 'ora.CRS.dg' on 'zhongwc1'  
CRS-2673: Attempting to stop 'ora.zhongwc.db' on 'zhongwc1'  
CRS-2673: Attempting to stop 'ora.oc4j' on 'zhongwc1'  
CRS-2677: Stop of 'ora.cvu' on 'zhongwc1' succeeded  
CRS-2672: Attempting to start 'ora.cvu' on 'zhongwc2'  
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'zhongwc1' succeeded  
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'zhongwc1'  
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'zhongwc1' succeeded  
CRS-2673: Attempting to stop 'ora.zhongwc1.vip' on 'zhongwc1'  
CRS-2677: Stop of 'ora.scan1.vip' on 'zhongwc1' succeeded  
CRS-2672: Attempting to start 'ora.scan1.vip' on 'zhongwc2'  
CRS-2677: Stop of 'ora.zhongwc1.vip' on 'zhongwc1' succeeded  
CRS-2672: Attempting to start 'ora.zhongwc1.vip' on 'zhongwc2'  
CRS-2676: Start of 'ora.cvu' on 'zhongwc2' succeeded  
CRS-2677: Stop of 'ora.zhongwc.db' on 'zhongwc1' succeeded  
CRS-2673: Attempting to stop 'ora.DATADG.dg' on 'zhongwc1'  
CRS-2673: Attempting to stop 'ora.FRADG.dg' on 'zhongwc1'  
CRS-2676: Start of 'ora.zhongwc1.vip' on 'zhongwc2' succeeded  
CRS-2677: Stop of 'ora.DATADG.dg' on 'zhongwc1' succeeded  
CRS-2677: Stop of 'ora.FRADG.dg' on 'zhongwc1' succeeded  
CRS-2676: Start of 'ora.scan1.vip' on 'zhongwc2' succeeded  
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'zhongwc2'  
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'zhongwc2' succeeded  
CRS-2677: Stop of 'ora.oc4j' on 'zhongwc1' succeeded  
CRS-2672: Attempting to start 'ora.oc4j' on 'zhongwc2'  
CRS-2676: Start of 'ora.oc4j' on 'zhongwc2' succeeded  
CRS-2677: Stop of 'ora.CRS.dg' on 'zhongwc1' succeeded  
CRS-2673: Attempting to stop 'ora.asm' on 'zhongwc1'  
CRS-2677: Stop of 'ora.asm' on 'zhongwc1' succeeded  
CRS-2673: Attempting to stop 'ora.ons' on 'zhongwc1'  
CRS-2677: Stop of 'ora.ons' on 'zhongwc1' succeeded  
CRS-2673: Attempting to stop 'ora.net1.network' on 'zhongwc1'  
CRS-2677: Stop of 'ora.net1.network' on 'zhongwc1' succeeded  
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'zhongwc1' has completed  
CRS-2677: Stop of 'ora.crsd' on 'zhongwc1' succeeded  
CRS-2673: Attempting to stop 'ora.mdnsd' on 'zhongwc1'  
CRS-2673: Attempting to stop 'ora.crf' on 'zhongwc1'  
CRS-2673: Attempting to stop 'ora.ctssd' on 'zhongwc1'  
CRS-2673: Attempting to stop 'ora.evmd' on 'zhongwc1'  
CRS-2673: Attempting to stop 'ora.asm' on 'zhongwc1'  
CRS-2677: Stop of 'ora.mdnsd' on 'zhongwc1' succeeded  
CRS-2677: Stop of 'ora.crf' on 'zhongwc1' succeeded  
CRS-2677: Stop of 'ora.evmd' on 'zhongwc1' succeeded  
CRS-2677: Stop of 'ora.ctssd&#
补充:综合编程 , 其他综合 ,
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,