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.
1234
--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
12
SQL> alter diskgroup CRS mount;
SQL> select name, state, type from v
$asm_diskgroup
;
- Move OCR and Vote file from <Current diskgroup> to <CRS>
123
$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.
12
create pfile=
'/export/home/grid/pfilen.ora'
from spfile;
create spfile=
'+CRS'
from pfile=
'/export/home/grid/pfilen.ora'
;
- Restart CRS
12345
--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
123
$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
1
ocrconfig -backuploc <new location>
meda Changed status to publish 22/09/2022