System & Database Related Solutions: ASM SPILE to new Diskgroup (Oracle 19c RAC)

root@misdg:/d01/soft# /d01/app/19c/grid/bin/crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 9501fcc2dc854f80bff978f053afd973 (/dev/rdsk/c0t6006016084734D00B615DA687385B576d0s0) [OCRVOTE]
Located 1 voting disk(s).
root@misdg:/d01/soft#

----Alert log-----
CREATE DISKGROUP OCRVOTE1 EXTERNAL REDUNDANCY DISK '/dev/rdsk/c0t6006016084734D00116EDB6817C70198d0s0' SIZE 511829M
ATTRIBUTE 'compatible.asm'='19.0.0.0','compatible.advm'='19.0.0.0','au_size'='4M'

/d01/app/19c/grid/bin/crsctl replace votedisk +OCRVOTE1

root@misdg:/d01/soft# /d01/app/19c/grid/bin/crsctl replace votedisk +OCRVOTE1
Successful addition of voting disk 2e091a5ac02d4f4ebfb44511c10221ec.
Successful deletion of voting disk 9501fcc2dc854f80bff978f053afd973.
Successfully replaced voting disk group with +OCRVOTE1.
CRS-4266: Voting file(s) successfully replaced

root@misdg:/d01/soft#
root@misdg:/d01/soft# /d01/app/19c/grid/bin/crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'misdg'
CRS-2673: Attempting to stop 'ora.crsd' on 'misdg'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on server 'misdg'
CRS-2673: Attempting to stop 'ora.qosmserver' on 'misdg'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'misdg'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'misdg'
CRS-33673: Attempting to stop resource group 'ora.asmgroup' on server 'misdg'
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'misdg'
CRS-2673: Attempting to stop 'ora.OCRVOTE.dg' on 'misdg'
CRS-2673: Attempting to stop 'ora.OCRVOTE1.dg' on 'misdg'
CRS-2673: Attempting to stop 'ora.REDO01.dg' on 'misdg'
CRS-2673: Attempting to stop 'ora.REDO02.dg' on 'misdg'
CRS-2673: Attempting to stop 'ora.REDO03.dg' on 'misdg'
CRS-2673: Attempting to stop 'ora.cvu' on 'misdg'
CRS-2677: Stop of 'ora.cvu' on 'misdg' succeeded
CRS-2677: Stop of 'ora.FRA.dg' on 'misdg' succeeded
CRS-2677: Stop of 'ora.OCRVOTE.dg' on 'misdg' succeeded
CRS-2677: Stop of 'ora.REDO01.dg' on 'misdg' succeeded
CRS-2677: Stop of 'ora.OCRVOTE1.dg' on 'misdg' succeeded
CRS-2677: Stop of 'ora.REDO03.dg' on 'misdg' succeeded
CRS-2677: Stop of 'ora.REDO02.dg' on 'misdg' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'misdg'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'misdg' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'misdg'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'misdg' succeeded
CRS-2673: Attempting to stop 'ora.misdg.vip' on 'misdg'
CRS-2677: Stop of 'ora.scan1.vip' on 'misdg' succeeded
CRS-2677: Stop of 'ora.asm' on 'misdg' succeeded
CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'misdg'
CRS-2677: Stop of 'ora.misdg.vip' on 'misdg' succeeded
CRS-2677: Stop of 'ora.qosmserver' on 'misdg' succeeded
CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'misdg' succeeded
CRS-2673: Attempting to stop 'ora.asmnet1.asmnetwork' on 'misdg'
CRS-2677: Stop of 'ora.asmnet1.asmnetwork' on 'misdg' succeeded
CRS-33677: Stop of resource group 'ora.asmgroup' on server 'misdg' succeeded.
CRS-2673: Attempting to stop 'ora.ons' on 'misdg'
CRS-2677: Stop of 'ora.ons' on 'misdg' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'misdg'
CRS-2677: Stop of 'ora.net1.network' on 'misdg' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'misdg' has completed
CRS-2677: Stop of 'ora.crsd' on 'misdg' succeeded
CRS-2673: Attempting to stop 'ora.storage' on 'misdg'
CRS-2673: Attempting to stop 'ora.crf' on 'misdg'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'misdg'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'misdg'
CRS-2677: Stop of 'ora.drivers.acfs' on 'misdg' succeeded
CRS-2677: Stop of 'ora.crf' on 'misdg' succeeded
CRS-2677: Stop of 'ora.storage' on 'misdg' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'misdg'
CRS-2677: Stop of 'ora.mdnsd' on 'misdg' succeeded
CRS-2677: Stop of 'ora.asm' on 'misdg' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'misdg'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'misdg' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'misdg'
CRS-2673: Attempting to stop 'ora.evmd' on 'misdg'
CRS-2677: Stop of 'ora.ctssd' on 'misdg' succeeded
CRS-2677: Stop of 'ora.evmd' on 'misdg' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'misdg'
CRS-2677: Stop of 'ora.cssd' on 'misdg' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'misdg'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'misdg'
CRS-2677: Stop of 'ora.gipcd' on 'misdg' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'misdg' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'misdg' has completed
CRS-4133: Oracle High Availability Services has been stopped.

root@misdg:/d01/soft# /d01/app/19c/grid/bin/crsctl start has
CRS-4123: Oracle High Availability Services has been started.
root@misdg:/d01/soft#

root@misdg:/d01/soft# /d01/app/19c/grid/bin/crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 2e091a5ac02d4f4ebfb44511c10221ec (/dev/rdsk/c0t6006016084734D00116EDB6817C70198d0s0) [OCRVOTE1]
Located 1 voting disk(s).
root@misdg:/d01/soft#

root@misdg:/d01/soft# /d01/app/19c/grid/bin/crsctl check cluster -all
**************************************************************
misdg:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
root@misdg:/d01/soft#

root@misdg:/d01/soft# /d01/app/19c/grid/bin/ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 4
Total space (kbytes) : 491684
Used space (kbytes) : 84292
Available space (kbytes) : 407392
ID : 1626978053
Device/File Name : +OCRVOTE
Device/File integrity check succeeded
Device/File not configured
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check succeeded
root@misdg:/d01/soft#

----------Move the OCR to new diskgroup.
/d01/soft# /d01/app/19c/grid/bin/ocrconfig -add +OCRVOTE1
root@misdg:/d01/soft# /d01/app/19c/grid/bin/ocrconfig -add +OCRVOTE1
root@misdg:/d01/soft# /d01/app/19c/grid/bin/ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 4
Total space (kbytes) : 491684
Used space (kbytes) : 84292
Available space (kbytes) : 407392
ID : 1626978053
Device/File Name : +OCRVOTE
Device/File integrity check succeeded
Device/File Name : +OCRVOTE1
Device/File integrity check succeeded
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check succeeded
root@misdg:/d01/soft#
--Connect with SQLPLUS ASM instance
col path for a30
col name for a20
col header_status for a20
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +OCRVOTE/misdg-cluster/ASMPARAMETERFILE/registry.253.1213202967
SQL>

asmcmd spmove '+OCRVOTE/misdg-cluster/ASMPARAMETERFILE/registry.253.1213202967' '+OCRVOTE1/misdg-cluster/spfileASM.ora'
-bash-5.2$ asmcmd spmove '+OCRVOTE/misdg-cluster/ASMPARAMETERFILE/registry.253.1213202967' '+OCRVOTE1/misdg-cluster/spfileASM.ora'
ORA-15032: not all alterations performed
ORA-15028: ASM file '+OCRVOTE/misdg-cluster/ASMPARAMETERFILE/registry.253.1213202967' not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
-bash-5.2$
--Delete the old diskgroup
/d01/soft# /d01/app/19c/grid/bin/ocrconfig -delete +OCRVOTE
root@misdg:/d01/soft# /d01/app/19c/grid/bin/ocrconfig -delete +OCRVOTE
root@misdg:/d01/soft#
root@misdg:/d01/soft# /d01/app/19c/grid/bin/ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 4
Total space (kbytes) : 491684
Used space (kbytes) : 84292
Available space (kbytes) : 407392
ID : 1626978053
Device/File Name : +OCRVOTE1
Device/File integrity check succeeded
Device/File not configured
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check succeeded
root@misdg:/d01/soft#
---- Verify Move the SPFILE to newdiskgroup.
-bash-5.2$ asmcmd spget
+OCRVOTE1/misdg-cluster/spfileASM.ora
-bash-5.2$
reboot server
root@misdg:~# /d01/app/19c/grid/bin/crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE misdg STABLE
ora.net1.network
ONLINE ONLINE misdg STABLE
ora.ons
ONLINE ONLINE misdg STABLE
ora.proxy_advm
OFFLINE OFFLINE misdg STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE misdg STABLE
2 ONLINE OFFLINE STABLE
3 ONLINE OFFLINE STABLE
ora.FRA.dg(ora.asmgroup)
1 ONLINE ONLINE misdg STABLE
2 OFFLINE OFFLINE STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE misdg STABLE
ora.OCRVOTE1.dg(ora.asmgroup)
1 ONLINE ONLINE misdg STABLE
2 OFFLINE OFFLINE STABLE
3 OFFLINE OFFLINE STABLE
ora.REDO01.dg(ora.asmgroup)
1 ONLINE ONLINE misdg STABLE
2 OFFLINE OFFLINE STABLE
3 OFFLINE OFFLINE STABLE
ora.REDO02.dg(ora.asmgroup)
1 ONLINE ONLINE misdg STABLE
2 OFFLINE OFFLINE STABLE
3 OFFLINE OFFLINE STABLE
ora.REDO03.dg(ora.asmgroup)
1 ONLINE ONLINE misdg STABLE
2 OFFLINE OFFLINE STABLE
3 OFFLINE OFFLINE STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE misdg Started,STABLE
2 OFFLINE OFFLINE STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE misdg STABLE
2 OFFLINE OFFLINE STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE misdg STABLE
ora.misdg.vip
1 ONLINE ONLINE misdg STABLE
ora.qosmserver
1 ONLINE ONLINE misdg STABLE
ora.scan1.vip
1 ONLINE ONLINE misdg STABLE
--------------------------------------------------------------------------------
root@misdg:~#

System & Database Related Solutions

Pages

Sunday, 5 October 2025

Move OCR , Vote File , ASM SPILE to new Diskgroup (Oracle 19c RAC)