Diskgroup resource shows status offline after restart even it is mounted in ASM instance

  今天在自己的测试库上,添加ASM磁盘组后,重启CRS服务后,新添加的ASM磁盘组无法自动ONLINE,环境如下

    oracle 11.2.0.1.0 + ASM +REDHAT     RAC

    OS VERSION:redhat 5.8 64-bit

    DB VERSION:oracle 11.2.0.1.0 64-bit  

  手动online该磁盘组可以成功,后来在metalink上查了下,原来这是一个bug。文档id 1065158.1

 

 Diskgroup resource shows status offline after restart even it is mounted in ASM instance (文档 ID 1065158.1)     
________________________________________
修改时间:2011-12-28 类型:PROBLEM 
 
In this Document
  Symptoms
  Changes
  Cause
  Solution
  References
________________________________________
APPLIES TO: 
  Oracle Server - Enterprise Edition - Version: 11.2.0.1.0 and later   [Release: 11.2 and later ]
  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 <dg_name> [-n "<node_list>"]

or
2. Modify the attribute AUTO_START to "always"
     crsctl modify resource ora.<diskgroup>.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)"

 

 

 

  

posted @ 2014-08-04 14:29  BitMore  阅读(1883)  评论(0编辑  收藏  举报