如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!
诗檀软件专业数据库修复团队
服务热线 ： 13764045638 QQ号:47079569 邮箱：service@parnassusdata.com
Oracle 数据库 – 企业版 – 11.2.0.0以及更高版本
本文档中的信息适用于任何平台
症状
RAC/有普通冗余磁盘组的独立配置
配置ASMLIB 的ASM磁盘。
- 遵循下列存储操作 由于ORA-15186/ ORA-15282，ASM磁盘不能被内联/加回：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