ORA-15042 ASM disk "disknumber" is missing错误详解

Posted by PDSERVICE on Jul 19, 2014 In ASM ORA-15066 ORA-15042

ORA-15042 ASM disk "disknumber" is missing from group number "groupnumber"

ORA-15066: offlining disk "" may result in a data loss

遇到该错误ORA-15042说明ASM下对应groupnumber的disk group 下对应disknumber的ASM Disk无法被找到，引起该错误的可能性有多种,如：

ASM_DISKSTRING设置不当，导致部分需要的ASM DISK没有被ASM_DISKSTRING反映出来

尝试add disk到某个diskgroup，但是过程中发生了问题或者中断了，此时用户对该add的disk 做了dd清理磁盘头，但是实际上diskgroup 的metadata中已经记录了该asm disk

单纯的ASM Disk的header被损坏或者彻底丢失，其原因可能是存储IO故障或人为的误损坏asm disk header或者是OS工具的导致

根据上述多种不同的原因，该ORA-15042错误有不同的解决方案,例如手动构造asm disk header等等。

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

Errors in file

ORA-15066: offlining disk "" may result in a data loss

ORA-15042: ASM disk "29" is missing

ORA-15042: ASM disk "28" is missing

ORA-15042: ASM disk "27" is missing

ORA-15042: ASM disk "26" is missing

You are here