IMPORTANT: NO DB has been created !!!
Why is rename ASM DG?
1. Test RAC RMAN duplicate for standby similar to client environment.
2. Just because.
Rename Diskgroup name by renamedg command doesn't update the OCR (Doc ID 2392499.1) Bug 8740909 [11GR2-LNX-090726]OLD DISK GROUP RESOURCE NOT DELETED AFTER RENAMEDG renamedg does not update resources, nor does renamedg update any file references within the database. Because of this, the original disk group resource is not automatically deleted. This resource can be manually deleted with Server Control Utility (SRVCTL). ============================== [oracle@ol7-19-phx2 ~]$ asmcmd -V asmcmd version 19.6.0.0.0 [oracle@ol7-19-phx2 ~]$ ============================== [oracle@ol7-19-phx1 ~]$ crsctl stat res -t -w "TYPE = ora.diskgroup.type" -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.CRS.dg(ora.asmgroup) 1 ONLINE ONLINE ol7-19-phx1 STABLE 2 ONLINE ONLINE ol7-19-phx2 STABLE 3 OFFLINE OFFLINE STABLE ora.DATA_PHX.dg(ora.asmgroup) 1 ONLINE ONLINE ol7-19-phx1 STABLE 2 ONLINE ONLINE ol7-19-phx2 STABLE 3 OFFLINE OFFLINE STABLE ora.RECO.dg(ora.asmgroup) 1 ONLINE ONLINE ol7-19-phx1 STABLE 2 ONLINE ONLINE ol7-19-phx2 STABLE 3 OFFLINE OFFLINE STABLE -------------------------------------------------------------------------------- [oracle@ol7-19-phx1 ~]$ ============================== [oracle@ol7-19-phx1 ~]$ asmcmd umount RECO [oracle@ol7-19-phx2 ~]$ asmcmd umount RECO ============================== [oracle@ol7-19-phx1 ~]$ asmcmd lsdg -g Inst_ID State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name 1 MOUNTED NORMAL N 512 512 4096 1048576 98301 47769 32767 7501 0 Y CRS/ 2 MOUNTED NORMAL N 512 512 4096 1048576 98301 47769 32767 7501 0 Y CRS/ 1 MOUNTED EXTERN N 512 512 4096 1048576 32767 32663 0 32663 0 N DATA_PHX/ 2 MOUNTED EXTERN N 512 512 4096 1048576 32767 32663 0 32663 0 N DATA_PHX/ [oracle@ol7-19-phx1 ~]$ crsctl stat res -t -w "TYPE = ora.diskgroup.type" -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.CRS.dg(ora.asmgroup) 1 ONLINE ONLINE ol7-19-phx1 STABLE 2 ONLINE ONLINE ol7-19-phx2 STABLE 3 OFFLINE OFFLINE STABLE ora.DATA_PHX.dg(ora.asmgroup) 1 ONLINE ONLINE ol7-19-phx1 STABLE 2 ONLINE ONLINE ol7-19-phx2 STABLE 3 OFFLINE OFFLINE STABLE ora.RECO.dg(ora.asmgroup) 1 OFFLINE OFFLINE STABLE 2 OFFLINE OFFLINE STABLE 3 OFFLINE OFFLINE STABLE -------------------------------------------------------------------------------- [oracle@ol7-19-phx1 ~]$ ============================== [oracle@ol7-19-phx1 ~]$ renamedg dgname=RECO newdgname=FRA_PHX verbose=true Parameters in effect: Old DG name : RECO New DG name : FRA_PHX Phases : Phase 1 Phase 2 Discovery str : (null) Clean : TRUE Raw only : TRUE renamedg operation: dgname=RECO newdgname=FRA_PHX verbose=true Executing phase 1 Discovering the group Performing discovery with string: ERROR: submiting READ on /dev/sdg failed due to kgfknm error ERROR: -20(27041 /dev/sdg)ERROR: submiting READ on /dev/sda failed due to kgfknm error ERROR: -20(27041 /dev/sda)ERROR: submiting READ on /dev/sdc failed due to kgfknm error ERROR: -20(27041 /dev/sdc)ERROR: submiting READ on /dev/sdf failed due to kgfknm error ERROR: -20(27041 /dev/sdf)ERROR: submiting READ on /dev/sde failed due to kgfknm error ERROR: -20(27041 /dev/sde)ERROR: submiting READ on /dev/sdd failed due to kgfknm error ERROR: -20(27041 /dev/sdd)ERROR: submiting READ on /dev/sdb failed due to kgfknm error ERROR: -20(27041 /dev/sdb)ERROR: submiting READ on /dev/sda1 failed due to kgfknm error ERROR: -20(27041 /dev/sda1)ERROR: submiting READ on /dev/sda2 failed due to kgfknm error ERROR: -20(27041 /dev/sda2)ERROR: submiting READ on /dev/sdb1 failed due to kgfknm error ERROR: -20(27041 /dev/sdb1)Identified disk UFS:/dev/sdg1 with disk number:0 and timestamp (33103213 1600008192) Checking for hearbeat... Re-discovering the group Performing discovery with string: ERROR: submiting READ on /dev/sdg failed due to kgfknm error ERROR: -20(27041 /dev/sdg)ERROR: submiting READ on /dev/sda failed due to kgfknm error ERROR: -20(27041 /dev/sda)ERROR: submiting READ on /dev/sdc failed due to kgfknm error ERROR: -20(27041 /dev/sdc)ERROR: submiting READ on /dev/sdf failed due to kgfknm error ERROR: -20(27041 /dev/sdf)ERROR: submiting READ on /dev/sde failed due to kgfknm error ERROR: -20(27041 /dev/sde)ERROR: submiting READ on /dev/sdd failed due to kgfknm error ERROR: -20(27041 /dev/sdd)ERROR: submiting READ on /dev/sdb failed due to kgfknm error ERROR: -20(27041 /dev/sdb)ERROR: submiting READ on /dev/sda1 failed due to kgfknm error ERROR: -20(27041 /dev/sda1)ERROR: submiting READ on /dev/sda2 failed due to kgfknm error ERROR: -20(27041 /dev/sda2)ERROR: submiting READ on /dev/sdb1 failed due to kgfknm error ERROR: -20(27041 /dev/sdb1)Identified disk UFS:/dev/sdg1 with disk number:0 and timestamp (33103213 1600008192) Checking if the diskgroup is mounted or used by CSS Checking disk number:0 Generating configuration file.. Completed phase 1 Executing phase 2 Looking for /dev/sdg1 Modifying the header Completed phase 2 [oracle@ol7-19-phx1 ~]$ ============================== [oracle@ol7-19-phx1 ~]$ asmcmd mount FRA_PHX [oracle@ol7-19-phx2 ~]$ asmcmd mount FRA_PHX ============================== [oracle@ol7-19-phx1 ~]$ asmcmd lsdg FRA_PHX -g Inst_ID State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name 1 MOUNTED EXTERN N 512 512 4096 1048576 32767 32663 0 32663 0 N FRA_PHX/ 2 MOUNTED EXTERN N 512 512 4096 1048576 32767 32663 0 32663 0 N FRA_PHX/ [oracle@ol7-19-phx1 ~]$ crsctl stat res -t -w "TYPE = ora.diskgroup.type" -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.CRS.dg(ora.asmgroup) 1 ONLINE ONLINE ol7-19-phx1 STABLE 2 ONLINE ONLINE ol7-19-phx2 STABLE 3 OFFLINE OFFLINE STABLE ora.DATA_PHX.dg(ora.asmgroup) 1 ONLINE ONLINE ol7-19-phx1 STABLE 2 ONLINE ONLINE ol7-19-phx2 STABLE 3 OFFLINE OFFLINE STABLE ora.FRA_PHX.dg(ora.asmgroup) 1 ONLINE ONLINE ol7-19-phx1 STABLE 2 ONLINE ONLINE ol7-19-phx2 STABLE 3 OFFLINE OFFLINE STABLE ora.RECO.dg(ora.asmgroup) 1 OFFLINE OFFLINE STABLE 2 OFFLINE OFFLINE STABLE 3 OFFLINE OFFLINE STABLE -------------------------------------------------------------------------------- [oracle@ol7-19-phx1 ~]$ ### For when DG is not online: srvctl start diskgroup -diskgroup FRA_PHX -node "node_list" ============================== [oracle@ol7-19-phx1 ~]$ srvctl remove diskgroup -g RECO [oracle@ol7-19-phx1 ~]$ crsctl stat res -t -w "TYPE = ora.diskgroup.type" -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.CRS.dg(ora.asmgroup) 1 ONLINE ONLINE ol7-19-phx1 STABLE 2 ONLINE ONLINE ol7-19-phx2 STABLE 3 OFFLINE OFFLINE STABLE ora.DATA_PHX.dg(ora.asmgroup) 1 ONLINE ONLINE ol7-19-phx1 STABLE 2 ONLINE ONLINE ol7-19-phx2 STABLE 3 OFFLINE OFFLINE STABLE ora.FRA_PHX.dg(ora.asmgroup) 1 ONLINE ONLINE ol7-19-phx1 STABLE 2 ONLINE ONLINE ol7-19-phx2 STABLE 3 OFFLINE OFFLINE STABLE -------------------------------------------------------------------------------- [oracle@ol7-19-phx1 ~]$
Q.E.D.
There is another reason to rename a diskgroup: if you want to move an ASM diskgroup from one server to another, you can’t do that if the diskgroup has the same name. You’ll have to rename the diskgroup first.
Comment by Liron — July 11, 2020 @ 4:57 pm |
Thanks Liron as I did not know that.
Comment by mdinh — July 11, 2020 @ 10:36 pm |