ORA-15186: 存储维护后,ASMLIB 错误 = [5], mesg = [No such device]

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

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

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

 

Oracle 数据库企业版 – 11.2.0.0以及更高版本
本文档中的信息适用于任何平台

症状

RAC/有普通冗余磁盘组的独立配置

配置ASMLIB ASM磁盘。

  • 遵循下列存储操作  由于ORA-15186/ ORA-15282ASM磁盘不能被内联/加回:ASM磁盘是不可见的集群范围。

SQL> alter diskgroup ELETMP add failgroup ELETMP_FFG disk  ‘ORCL:SE9990V00A1P1’ rebalance power 11

ORA-15186: ASMLIB error function = [asm_open(global)],  error = [5],  mesg = [No such device]
ORA-15025: could not open disk “ORCL:SE9990V00A1P1”

2) v$asm_disk 显示了状态为CLOSED/UNKNOWN的磁盘。 shows disks with status

  GROUP DISK MOUNT_S    HEADER_STATUS    LIBRARY                                          LABEL                PATH
==================================================================================
0        1    CLOSED    UNKNOWN            ASM Library – version 2.0.4 (KABI_V2)    SE9990V00A1P1    ORCL:SE9990V00A1P1
0        0    CLOSED    UNKNOWN            ASM Library – version 2.0.4 (KABI_V2)    SE9990V0093P1    ORCL:SE9990F0093P1

3) alert_+ASM.log 显示:

ORA-15186: ASMLIB error function = [asm_open(global)],  error = [5],  mesg = [No such device]
ORA-15025: could not open disk “ORCL:SE9990V00A1P1”

and on the other nodes

NOTE: disk validation pending for group 1/0xf13a9d5b (ELETMP)
ORA-15186: ASMLIB error function = [asm_open(global)],  error = [5],  mesg = [No such device]

4) “oracleasm scandisks”已运行,且重新实例化ASMLIB磁盘     

…..
Disk “SE9990V0093P1” is a valid ASM disk on device [253,30]
Disk “SE9990V00A1P1” is a valid ASM disk on device [253,48]

5) KFED在所有节点上报告正确的磁盘头(成员) 

kfbh.type:                            1 ; 0x002: KFBTYP_DISKHEAD
kfdhdb.driver.provstr:          ORCLDISKSE9990V00A1P1 ; 0x000: length=21
kfdhdb.dsknum:                   0 ; 0x024: 0x0000
kfdhdb.grptyp:                     2 ; 0x026: KFDGTP_NORMAL
kfdhdb.hdrsts:                     3 ; 0x027: KFDHDR_MEMBER>>>>>
kfdhdb.dskname:                 SE9990V00A1P1 ; 0x028: length=13
kfdhdb.grpname:                 ELEVENDG ; 0x048: length=8
kfdhdb.fgname:                   ELEVENDG_FFG ; 0x068: length=12

6) KFOD在所有节点上发现所有磁盘(无论是作为ORCL/dev/oracleasm/disks

Disk          Size                          Path                                     User     Group
================================================================================

13:      51199 Mb    ORCL:SE9990V0093P1                       <unknown> <unknown>
14:      20473 Mb    ORCL:SE9990V00A1P1                       <unknown> <unknown>
================================================================================

 7) 多路径配置在所有节点上正常(无论是“multipath -ll”“BLKID”

变化

 存储维护(如先将所有路径脱机到磁盘)或任何类型的存储操作(如复制),这意味着 /dev/mapper/*设备的重新映射,且(主,次)发生变化。

原因

Bug 17047653 – ORA-15186: ASMLIB ERROR FUNCTION ERROR = [5]/DISKS SEEN CLOSED/UNKNOWN

关闭其副本 

  Bug 17896002 – AFTER RUNNING RENAMEDISK DB COMMAND IS FAILING STATING ASMLIB HEADER IS UNKNOWN

解决方案

 1) 应用17896002修补程序

 2) 解决办法: 重启ASM 实例(CRS 堆栈)

参考

BUG:17896002 – AFTER RUNNING RENAMEDISK DB COMMAND IS FAILING STATING ASMLIB HEADER IS UNKNOWN

Comment

*

沪ICP备14014813号-2

沪公网安备 31010802001379号