11g asm单实例数据库启动

# 背景：DG备库节点主机重启之后，数据库没有重启
# 在诊断重启数据库中遇到的问题记录

1 11g ASM单实例数据库，启动ohasd无反应
crsctl start has

2 查看ohasd日志，提示：TIMED OUT WAITING FOR OHASD MONITOR
nohup /bin/dd if=/var/tmp/.oracle/npohasd of=/dev/null bs=1024 count=1 &

3 再次启动oha 成功拉起ASM实例
crsctl start has

4 查看CRS资源发现磁盘组 DATADG OCR 状态为OFFLINE
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.DATA.dg    ora....up.type ONLINE    ONLINE    paas...-002 
ora.DATADG.dg  ora....up.type ONLINE    OFFLINE          
ora.OCR.dg     ora....up.type ONLINE    OFFLINE      
ora.diskmon    ora....on.type OFFLINE   OFFLINE       

5 尝试mount磁盘组
su - grid
sqlplus / as sysasm

SQL> alter diskgroup OCR mount;
alter diskgroup OCR mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15017: diskgroup "OCR" cannot be mounted
ORA-15040: diskgroup is incomplete

SQL> alter diskgroup DATADG mount;
alter diskgroup DATADG mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15036: disk '/dev/asm_data9' is truncated

# 使用命令fdisk -l 查看磁盘信息时，
# 发现磁盘组sdb9也在磁盘组DATA中，而DATA磁盘组状态为ONLINE，
# 于想到是11GASM单节点，尝试启动数据库

6 尝试启动数据库 启动数据库成功
[oracle@paas-crm-oracle-002 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 25 17:18:37 2020

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 1.0689E+11 bytes
Fixed Size                  2265864 bytes
Variable Size            9932115192 bytes
Database Buffers         9.6905E+10 bytes
Redo Buffers               55242752 bytes
SQL> alter database mount standby database;

Database altered.