某10.2.0.5 ASM系统由于存储故障导致normal redundancy diskgroup中的4个failgroup中的2个failgroup的ASM DISK均无法访问,在10g中若ASM disk无法访问将直接将disk drop出diskgroup中。   报错如下:  
Sat Nov 15 17:05:36 CST 2013
WARNING: PST-initiated drop disk 1(739802527).1(3915943320) 
WARNING: PST-initiated drop disk 1(739802527).3(3915943321) 
Sat Nov 15 17:05:36 CST 2013
NOTE: PST update: grp = 1
Sat Nov 15 17:05:36 CST 2013
ERROR: too many offline disks in PST (grp 1)
Sat Nov 15 17:05:36 CST 2013
ERROR: ORA-15066 signalled during reconfiguration of diskgroup DATADG
NOTE: requesting all-instance membership refresh for group=1
Sat Nov 15 17:05:36 CST 2013
NOTE: membership refresh pending for group 1/0x2c187d9f (DATADG)
WARNING: rejecting drop force of disk number 1
WARNING: rejecting drop force of disk number 3
SUCCESS: refreshed membership for 1/0x2c187d9f (DATADG)
Sat Nov 15 17:05:39 CST 2013
ERROR: PST-initiated disk drop failed
Sat Nov 15 17:05:39 CST 2013
ERROR: PST-initiated MANDATORY DISMOUNT of group DATADG
NOTE: cache dismounting group 1/0x2C187D9F (DATADG) 
Sat Nov 15 17:05:39 CST 2013
NOTE: halting all I/Os to diskgroup DATADG


由于是normal redundancy,所以只能丢失一个failgroup。ASM尝试drop 2个failgroup时会导致diskgroup被强制DISMOUNT,即PST-initiated MANDATORY DISMOUNT of group DATADG。   PST-initiated drop disk =》 PST初始化drop disk ERROR: too many offline disks in PST (grp 1) ==> ASM认为若drop 这么多disk会导致丢失数据,所以是too many offline disk   WARNING: rejecting drop force of disk number 1 WARNING: rejecting drop force of disk number 3  ==> ASM拒绝drop这些disk ERROR: PST-initiated disk drop failed==> PST初始化drop disk失败 ERROR: PST-initiated MANDATORY DISMOUNT of group ORADATA==》 强制dismount diskgroup   以上对于该asm diskgroup的维护将陷入死循环,即 mount diskgroup => 开始drop disk=> 由于drop disk过多 导致asm 强制dismount diskgroup => 人为再次手动mount diskgroup。 该ASM Diskgroup实际变得不可用了。   我们可以通过设置隐藏参数或者手动patch PST的方式来绕过该问题,具体需要了解ASM 底层数据结构的工程师现场根据实际情况实施,再次不再鏖述。  

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638   QQ号:47079569    邮箱:service@parnassusdata.com

_  __ (_)/   \ <'_, ____)~~~~~~~ ^^   ^^