【RAC】Diskgroup shows offline after restart even it is mounted in ASM instance

简介:
Diskgroup resource shows status offline after restart even it is mounted in ASM instance
Applies to:
Oracle Server - Enterprise Edition - Version: 11.2.0.1.0 - Release: 11.2
Information in this document applies to any platform.
Symptoms
After restart the 11.2 HAS stack, the diskgroup (.dg) resource is showing "OFFLINE" status, but diskgroup is mounted in the ASM instance.
For example:
$ crsctl stat res ora.DATA.dg
NAME=ora.DATA.dg
TYPE=ora.diskgroup.type
TARGET=OFFLINE, ONLINE
STATE=OFFLINE, ONLINE on host1

From ASM when you query , the diskgroup shows as mounted.
SQL> conn / as sysdba
Connected.
SQL> select name,state from v$asm_diskgroup;
NAME                            STATE
------------------------------ -----------
DATA                             MOUNTED

Changes
From the crsd.log:
2010-02-05 16:05:09.988: [AGFW][56] ora.DATA.dg host1 1 received state from probe request. Old state = UNKNOWN, New state = OFFLINE
From oraagent_oracle.log:
2010-02-05 16:05:09.799: [AGFW][9] ora.DATA.dg host1 1 state changed from: UNKNOWN to: OFFLINE

Cause
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. 

Solution
The bug has been fixed in 11.2.0.2 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
相关文章
|
存储 Oracle 关系型数据库
RAC创建ASM磁盘组时配置多路径和UDEV
RAC创建ASM磁盘组时配置多路径和UDEV
2890 7
RAC 增加4块 asm 磁盘
增加磁盘之前的asm状态
156 0
|
Oracle 关系型数据库 数据库
|
Oracle 关系型数据库 Python
|
SQL 关系型数据库 数据库
ORA-15149: another ASM instance found running on the host
【问题现象】 [grid@localhost ~]$ echo $ORACLE_SID +asm [grid@localhost ~]$ echo $ORACLE_HOME /u01/app/11.
1174 0
|
Oracle 关系型数据库 安全
|
SQL Oracle 关系型数据库