Add new standby database as a cluster RAC standby
1. Make a cluster ready spfile in ASM
SQL> create spfile='+DATA/orcl/spfileorcl.ora' from pfile='/gg_nas/oracle/standby/orcl/initorcl.ora';
2. Stop the recovery on standby.
alter database recover managed standby database cancel;
3. Modify initracdb11.ora on rac1 and initracdb12.ora on all nodes to point to location in ASM
4. Rename any existing spfiles in $ORACLE_HOME/dbs
mv spfileORCL1.ora spfileORCL1.ora.old
scp initORCL1.ora NODEb:/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/initORCL2.ora
scp initORCL1.ora NODEc:/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/initORCL3.ora
scp initORCL1.ora NODEd:/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/initORCL4.ora
scp initORCL1.ora NODEe:/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/initORCL5.ora
scp initORCL1.ora NODEf:/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/initORCL6.ora
5. bounce the database and make sure the new spfile is in place in ASM.
show parameter spfile;
6. Register the standby database in Clusterware
srvctl add database -d ORCL -p '+DATA/orcl/spfileorcl.ora' -o $ORACLE_HOME -s mount -r physical_standby
srvctl add instance -d ORCL -i ORCL1 -n NODEa
srvctl add instance -d ORCL -i ORCL2 -n NODEb
srvctl add instance -d ORCL -i ORCL3 -n NODEc
srvctl add instance -d ORCL -i ORCL4 -n NODEd
srvctl add instance -d ORCL -i ORCL5 -n NODEe
srvctl add instance -d ORCL-i ORCL6 -n NODEf
7. verify the cluster database ORCL look good:
srvctl config database -d ORCL
8. start all the instance for the cluster database ORCL
srvctl start database -d ORCL
9. start the recovery of the database on node NODEa
alter database recover managed standby database using current logfile disconnect from session;
10. check and make sure ORCL is in sync with its primary
No comments:
Post a Comment