Applies to:
Oracle 11gR2 RAC
Scenario:
(2 node RAC with 11gR2 in RHEL 5.3 x86_64)
I was having 2 ASM diskgroup (ARC1_DG & ARC2_DG) assigned for archive logs and standby Dataguard when first RAC .
Due to some reason that management want to merge these 2 diskgroups into one (ARC1_DG).
I confimed that ARC2_DG was not contain any file and diskgroup ARC2_DG dropped successfully.
Issue:
After a schedule reboot for the 2 nodes, all CRS resources are ONLINE except database resource (STATE=OFFLINE).
I try “srvctl” to startup up database resource but fail with following errors.
$ srvctl start database -d MYDB
PRCR-1079 : Failed to start resource ora.mydb.db
CRS-2640: Required resource ‘ora.ARC2_DG.dg’ is missing.
I notice ora.ARC2_DG.dg resource is one of the start/stop dependency for ora.mydb.db.
$ crsctl status resource ora.mydb.db -f | grep ARC2_DG
START_DEPENDENCIES=hard(ora.DAT1_DG.dg,ora.RDO1_DG.dg,ora.RDO2_DG.dg,ora.SRL_DG.dg,ora.ARC1_DG.dg,ora.ARC2_DG.dg) weak(type:ora.listener.type,global:type:ora.scan_listener.type,uniform:ora.ons,uniform:ora.eons) pullup(ora.DAT1_DG.dg,ora.RDO1_DG.dg,ora.RDO2_DG.dg,ora.SRL_DG.dg,ora.ARC1_DG.dg,ora.ARC2_DG.dg)
STOP_DEPENDENCIES=hard(intermediate:ora.asm,shutdown:ora.DAT1_DG.dg,shutdown:ora.RDO1_DG.dg,shutdown:ora.RDO2_DG.dg,shutdown:ora.SRL_DG.dg,shutdown:ora.ARC1_DG.dg,shutdown:ora.ARC2_DG.dg)
Question:
How to remove the ASM resource from CRS start/stop dependency?
Solution:
Since ASM diskgroup ARC2_DG has been physically dropped. We would like to remove ARC2_DG resource from CRS start/stop dependency for database resource ora.mydb.db.
$ srvctl modify database -d MYDB -a “DAT1_DG,RDO1_DG,RDO2_DG,SRL_DG,ARC1_DG”
$ srvctl disable diskgroup -g ARC2_DG
$ srvctl remove diskgroup -g ARC2_DG –f
Back-out Plan:
By default OCR backup is running every 4 hours.
You may check OCR backup as follow:
$ cd $CRS_HOME/bin
$ ./ocrconfig –showbackup
If necessary, you may restore OCR.
$ cd $CRS_HOME/bin
$ ./ocrconfig –restore