Thursday, May 12, 2011

Don't forgot to check DATABASE resource attributes after drop ASM DiskGroup (11.2)

You may ask, what I mean on topic. Nothing!!! just I tested create ASM DiskGroup (FLASH_DG) and used it on my database... and then I drop it (FLASH_DG)... drop by using command-line from SQL*Plus.
Today... when I started database resource.
$ crsctl start res ora.dbm.db
CRS-2640: Required resource 'ora.FLASH_DG.dg' is missing.
CRS-4000: Command Start failed, or completed with errors.
OK... check this resource.
$ crsctl stat res ora.FLASH_DG.dg
CRS-2613: Could not find resource 'ora.FLASH_DG.dg'.
So, I checked database resource attributes.
$ crsctl stat res ora.dbm.db -p | grep ora.FLASH_DG.dg
START_DEPENDENCIES=hard(ora.DATA_EXA.dg,ora.RECO_EXA.dg,ora.FLASH_DG.dg) weak(type:ora.listener.type,global:type:ora.scan_listener.type,uniform:ora.ons,global:ora.gns) pullup(ora.DATA_EXA.dg,ora.RECO_EXA.dg,ora.FLASH_DG.dg)
STOP_DEPENDENCIES=hard(intermediate:ora.asm,shutdown:ora.DATA_EXA.dg,shutdown:ora.RECO_EXA.dg,shutdown:ora.FLASH_DG.dg)
That mean my attributes(START_DEPENDENCIES,STOP_DEPENDENCIES) wrong!!! just change...
$ crsctl modify resource ora.dbm.db -attr "START_DEPENDENCIES='hard(ora.DATA_EXA.dg,ora.RECO_EXA.dg) weak(type:ora.listener.type,global:type:ora.scan_listener.type,uniform:ora.ons,global:ora.gns) pullup(ora.DATA_EXA.dg,ora.RECO_EXA.dg)',STOP_DEPENDENCIES='hard(intermediate:ora.asm,shutdown:ora.DATA_EXA.dg,shutdown:ora.RECO_EXA.dg)'"
$ crsctl stat res ora.dbm.db -p | grep ora.FLASH_DG.dg
started database resource again...
$ crsctl start res ora.dbm.db
CRS-2672: Attempting to start 'ora.dbm.db' on 'exadb02'
CRS-2672: Attempting to start 'ora.dbm.db' on 'exadb04'
CRS-2672: Attempting to start 'ora.dbm.db' on 'exadb03'
CRS-2672: Attempting to start 'ora.dbm.db' on 'exadb01'
CRS-2676: Start of 'ora.dbm.db' on 'exadb02' succeeded
CRS-2676: Start of 'ora.dbm.db' on 'exadb01' succeeded
CRS-2676: Start of 'ora.dbm.db' on 'exadb03' succeeded
CRS-2676: Start of 'ora.dbm.db' on 'exadb04' succeeded

$ crsctl stat res ora.dbm.db
NAME=ora.dbm.db
TYPE=ora.database.type
TARGET=ONLINE , ONLINE , ONLINE , ONLINE
STATE=ONLINE on exadb01, ONLINE on exadb02, ONLINE on exadb03, ONLINE on exadb04
^ ^

No comments: