【Oracle ASM数据恢复】ORA-15066 & too many offline disks in PST (grp 1)

某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

_  __

(_)/   \

<‘_, ____)~~~~~~~

^^   ^^

 

Comment

*

沪ICP备14014813号

沪公网安备 31010802001379号