oracle-03150,【案例】Oracle报错ORA-15032 ORA-15017 ORA-15063 ASM磁盘组无法mount

天萃荷净

运维DBA反映数据库服务器重启后，Oracle ASM磁盘组无法mount，分析原因为分区无法识别导致asm diskgroup无法mount，报错ORA-15032 ORA-15017 ORA-15063

1.Oracle ASM无法mount报错ORA-15032,ORA-15017,ORA-15063

主机重启之后，导致四个磁盘组中的data2磁盘组无法mount(报ORA-15032,ORA-15017,ORA-15063),数据库无法open

Wed Mar 09 18:10:53 2016

NOTE: Assigning number (1,1) to disk (/dev/oracleasm/disks/VOL011)

Wed Mar 09 18:10:53 2016

ERROR: no read quorum in group: required 1, found 0 disks

NOTE: cache dismounting (clean) group 1/0xBD42B778 (DATA2)

NOTE: messaging CKPT to quiesce pins Unix process pid: 45093, image: oracle@BA (TNS V1-V3)

NOTE: dbwr not being msg'd to dismount

NOTE: lgwr not being msg'd to dismount

NOTE: cache dismounted group 1/0xBD42B778 (DATA2)

NOTE: cache ending mount (fail) of group DATA2 number=1 incarn=0xbd42b778

NOTE: cache deleting context for group DATA2 1/0xbd42b778

GMON dismounting group 1 at 16 for pid 18, osid 45093

NOTE: Disk DATA2_0001 in mode 0x9 marked for de-assignment

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"

ERROR: ALTER DISKGROUP DATA2 MOUNT /* asm agent *//* {0:0:431} */

这里很明显由于缺少asm disk导致data2无法正常mount,进一步分析发现data2是有两块磁盘