Diskgroup resource shows status offline after restart even it is mounted in ASM instance [ID 1065158.1]

		修改时间 28-FEB-2010 类型 PROBLEM 状态 PUBLISHED

In this Document
Symptoms
Changes
Cause
Solution
References

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 ""]


or

2. Modify the attribute AUTO_START to "always"

    
crsctl modify resource ora..dg -attr AUTO_START=always

间接的解决方法是：以grid用户执行修改以上命令，比如：

crsctl modify resource ora.DATA.dg -attr AUTO_START=always

crsctl modify resource ora.FLA.dg -attr AUTO_START=always

References

NOTE:1060920.1 - ALERT.LOG for ASM Shows "WARNING: failed to online diskgroup resource ora.GI.dg (unable to communicate with CRSD/OHASD)"

显示相关信息相关的

产品

Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition

关键字

V$ASM_DISKGROUP; CRSD; STATS; V$ASM_DISKGROUP