Diskgroup resource shows status offline after restart even it is mounted in ASM instance
Oracle Server - Enterprise Edition - Version: 188.8.131.52.0 - Release: 11.2
Information in this document applies to any platform.
After restart the 11.2 HAS stack, the diskgroup (.dg) resource is showing "OFFLINE" status, but diskgroup is mounted in the ASM instance.
$ crsctl stat res ora.DATA.dg
STATE=OFFLINE, ONLINE on host1
From ASM when you query , the diskgroup shows as mounted.
SQL> conn / as sysdba
SQL> select name,state from v$asm_diskgroup;
From the crsd.log:
2010-02-05 16:05:09.988: [AGFW] ora.DATA.dg host1 1 received state from probe request. Old state = UNKNOWN, New state = OFFLINE
2010-02-05 16:05:09.799: [AGFW] ora.DATA.dg host1 1 state changed from: UNKNOWN to: OFFLINE
This is caused by an unpublished bug 8663101 11.2 DG RES OFFLINE, BUT DISKGROUP MOUNTED AFTER RESTART HAS STACK
The diskgroup is mounted in asm before crsd is up so crsd is never notified of the diskgroup resource start.
The bug has been fixed in 184.108.40.206 patchset.
Two workarounds available:
1. Manually start the diskgroup:
srvctl start diskgroup -g [-n ""]
2. Modify the attribute AUTO_START to "always"
crsctl modify resource ora..dg -attr AUTO_START=always
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22664653/viewspace-706682/，如需转载，请注明出处，否则将追究法律责任。