Oracle Mount ASM 磁盘组失败 : ORA-15186, ORA-15025, ORA-15063

 

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

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

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

 

适用于:

Oracle Database – Enterprise Edition – 版本10.2.0.1 及以上
本文信息适用于任何平台。
10-May-2013检查相关性

症状

 

注意关于平台:虽然’/etc/sysconfig/oracleasm’只适用于Linux环境,类似的错误可能会出现并影响使用多路径设备的非Linux环境。
Mount ASM 磁盘组失败,出现:ORA-15186, ORA-15025, ORA-15063

alert_+ASM.log:
~~~~~~~~~~~~~~~~~~

注:Loaded library: /opt/oracle/extapi/64/asm/orcl/1/libasm.so
ORA-15186: ASMLIB error function = [asm_open(global)], error = [1], mesg = [Operation not permitted]
ORA-15025: could not open disk “ORCL:DISCO01BKP”
ORA-15186: ASMLIB error function = [asm_open(global)], error = [1], mesg = [Operation not permitted]
ORA-15025: could not open disk “ORCL:DISCO02BKP”
ORA-15186: ASMLIB error function = [asm_open(global)], error = [1], mesg = [Operation not permitted]
ORA-15025: could not open disk “ORCL:DISCO03BKP”
ORA-15186: ASMLIB error function = [asm_open(global)], error = [1], mesg = [Operation not permitted]
ORA-15025: could not open disk “ORCL:DISCO04BKP”
ORA-15186: ASMLIB error function = [asm_open(global)], error = [1], mesg = [Operation not permitted]
ORA-15025: could not open disk “ORCL:DISCO05BKP”
ERROR: no PST quorum in group: required 2, found 0

ERROR: diskgroup DATA2 was not mounted
ORA-15032: not all alterations performed
ORA-15017: diskgroup “DATA2” cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup “DATA2”

原因

所有asmlib 磁盘显示在ASM的v$asm_disk视图中,但它们的 HEADER_STATUS=UNKNOWN

但ASMLIB 查看磁盘:

$ /etc/init.d/oracleasm listdisks
DISCO01BKP
DISCO02BKP
DISCO03BKP
DISCO04BKP
DISCO05BKP
asmlib磁盘的列表,显示他们的主次编号(从左边开始第一组编号):

$ ls -l /dev/oracleasm/disks
brw-rw—- 1 oracle oinstall 8, 1 Dec 8 10:31 DISCO01BKP
brw-rw—- 1 oracle oinstall 8, 17 Dec 8 10:31 DISCO02BKP
brw-rw—- 1 oracle oinstall 8, 33 Dec 8 10:31 DISCO03BKP
brw-rw—- 1 oracle oinstall 8, 49 Dec 8 10:31 DISCO04BKP
brw-rw—- 1 oracle oinstall 8, 65 Dec 8 10:31 DISCO05BKP
‘cat /proc/partitions’显示asmlib设备被链接到‘sd’设备,而不是多路径(dm)’设备。这些asmlib设备在该问题之前是被链接到多路径设备的:

major minor #blocks name
8 1 209712478 sda1
8 17 209712478 sdb1
8 33 209712478 sdc1
8 49 209712478 sdd1
8 65 209712478 sde1

253 0 209715200 dm-0
253 1 209715200 dm-1
253 2 209715200 dm-2
253 3 209715200 dm-3
253 4 209715200 dm-4

 

解决方案

与将asmlib设备映射到多路径设备相关的asmlib 文件 (/etc/sysconfig/oracleasm) ,似乎未对多路径配置:

ORACLEASM_ENABLED=true
ORACLEASM_UID=oracle
ORACLEASM_GID=oinstall
ORACLEASM_SCANBOOT=true
ORACLEASM_SCANORDER=””
ORACLEASM_SCANEXCLUDE=””
ORACLEASM_SCANORDER 和 ORACLEASM_EXCLUDE 在/etc/sysconfig/oracleasm中被更新后,ASM就能以v$asm_disk.header_status=MEMBER显示asmlib磁盘。因此,ASM 能够mount 磁盘组。

ORACLEASM_SCANORDER=”mpath dm”
ORACLEASM_SCANEXCLUDE=”sd”

关注刘相兵的新浪微博

扫码加入微信Oracle小密圈,了解Oracle最新技术下载分享资源

Speak Your Mind

沪公网安备 31010802001379号

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569