ORACLE ASM 没挂盘, 手动mount

数据库重启后无法启动

ORA-00210: cannot open the specified control file
ORA-00202: control file: '+FRA/sqmesdb/controlfile/current.284.1058976347'
ORA-17503: ksfdopn:2 Failed to open file +FRA/sqmesdb/controlfile/current.284.1058976347
ORA-15001: diskgroup "FRA" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-00210: cannot open the specified control file
ORA-00202: control file: '+DATA/sqmesdb/controlfile/current.285.1058976347'
ORA-17503: ksfdopn:2 Failed to open file +DATA/sqmesdb/controlfile/current.285.1058976347
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup

第一反应：完读子了

#  crsctl stat res -t

看到 ora.asm 是 Started但是DATA、FRA、OCR都是OFFLINE

顿时拔凉拔凉

检查多路径

# multipath -ll

一切正常

进入grid尝试手动挂载

# su - oragrid

$ sqlplus / as sysasm

> alter diskgroup data mount;

> alter diskgroup fra mount;

> alter diskgroup ocr mount;

所幸正常启动