ORA-15042: ASM disk"33"ismissingfromgroupnumber"2" 原因 操作系统重启后,ASM启动后无法mount磁盘组,报错说找不到对应的磁盘。 此种原因大致有: ASM_DISKSTRING设置不当,导致部分需要的ASM DISK没有被ASM_DISKSTRING找出来; 尝试add disk到某个diskgroup,但是过程中发生了问题或者中断了,此时基于某种考虑对该add...
ORA-15042: ASM disk"20"is missing from group number"1" ERROR: ALTER DISKGROUP DG_XFF MOUNT /* asm agent *//* {1:51107:7083} */ 这里比较明显,由于存储工程师直接删除了lun,这里导致磁盘组DG_XFF丢失asm disk 20,使得磁盘组无法直接mount,由于该磁盘组已经进行了较长时间的rebalance,丢失的盘中已...
SQL>alterdiskgrouptestmount;alterdiskgrouptestmount*ERRORatline1:ORA-15032:notallalterations performedORA-15040:diskgroupisincompleteORA-15042: ASM disk"4"ismissingfromgroupnumber"2"SQL>alterdiskgrouptestmountforce;alterdiskgrouptestmountforce*ERRORatline1:ORA-15032:notallalterations performedORA-15040:diskgro...
ASM丢失disk header导致ORA-15032、ORA-15040、ORA-15042 Diskgroup无法mount的案例不少,这里我们介绍下如何解决。
Oracle Database Cloud Exadata Service - Version N/A and later: ORA-15040, ORA-15066, ORA-15042 when ASM disk is not present in all nodes of a Rac Cluster. Adding a
NLSRTL Version 11.2.0.3.0 – Production SQL> alter diskgroup datadg mount; alter diskgroup datadg mount * ERROR at line 1: ORA-15032: not all alterations performed ORA-15040: diskgroup is incomplete ORA-15042: ASM disk “5” is missing from group number “1” ...
通过脚本找到数据块与ASM磁盘的映射关系,由于是normal冗余,此处会看到两副本,LXN_KFFXP为0的是primary extent在1号disk上,为1的是secondary extent在4号disk上,稍后我们就模拟offline 1号disk所在fg,并且破坏4号盘。 代码语言:javascript 复制 SQL>@asm_block ...
根据上述多种不同的原因,该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 ...
NLSRTL Version 11.2.0.3.0 – Production SQL> alter diskgroup datadg mount; alter diskgroup datadg mount * ERROR at line 1: ORA-15032: not all alterations performed ORA-15040: diskgroup is incomplete ORA-15042: ASM disk “5” is missing from group number “1” ...
SQL> ALTER DISKGROUP DG_XFF MOUNT /* asm agent *//* {1:51107:7083} */ NOTE: cache registered group DG_XFF number=1 incarn=0xdd6f975a NOTE: cache began mount (first) of group DG_XFF number=1 incarn=0xdd6f975a NOTE: Assigning number (1,0) to disk (/dev/rhdisk10) ...