How to move OCR , vote file and ASM SPILE to new diskgroup in oracle RAC database?
AB Answered question 22/09/2022
There are around 7 steps to move OCR, vote and ASM SPFILE file from one ASM disk group to another ASM disk group.
Below are the steps:
- Create New diskgroups(CRS) for OCR and Voting files.
--Login as SYSASM using SQLPLUS into ASM instance on one node and run below command: SQL> create diskgroup CRS normal redundancy disk 'RACDB:DISK1' ,'RACDB:DISK2' ,'RACDB:DISK3' attribute 'compatible.rdbms'='19.3.0.0', 'compatible.asm'='19.3.0.0'; Diskgroup created.
- Mount disk group in all RAC nodes
SQL> alter diskgroup CRS mount; SQL> select name, state, type from v$asm_diskgroup;
- Move OCR and Vote file from <Current diskgroup> to <CRS>
$ORACLE_HOME/bin/bin/ocrconfig -add +CRS $ORACLE_HOME/bin/bin/ocrconfig -delete +DATA $ORACLE_HOME/bin/crsctl replace votedisk +CRS
- Change ASM SPFILE location from <Current diskgroup> to <CRS> Diskgroup.
create pfile='/export/home/grid/pfilen.ora' from spfile; create spfile='+CRS' from pfile='/export/home/grid/pfilen.ora';
- Restart CRS
--Mount disk group in all RAC nodes: SQL> alter diskgroup CRS mount; …. To be sure --Restart CRS in all nodes to startup CRS using new SPFILE from +CRS : $> crsctl stop crs $> crsctl start crs
- Ensure ALL Cluster resources are started successfully
$ORACLE_HOME/bin/crsctl stat res -init -t $ORACLE_HOME/bin/crsctl check cluster -all $ORACLE_HOME/bin/crsctl stat res -t
- Modify the backup location for the OCR
ocrconfig -backuploc <new location>
meda Changed status to publish 22/09/2022