DG不能自动mount导致数据库不能正常启动：ORA-01157、ORA-01110、ORA-17503、ORA-150

DG不能自动mount导致数据库不能正常启动：ORA-01157、ORA-01110、ORA-17503、ORA-15001、ORA-15001现象：每次重启整个CRS之后，D

dg不能自动mount导致数据库不能正常启动：ora-01157、ora-01110、ora-17503、ora-15001、ora-15001
现象：
每次重启整个crs之后，db都不能自动开启到open状态，查看alert日志报错：
success: diskgroup unid was mounted
thu nov 14 21:46:01 2013
create relation sweeperr
setting recovery target incarnation to 1
successful mount of redo thread 1, with mount id 2364838615
database mounted in exclusive mode
lost write protection disabled
completed: alter database mount
thu nov 14 21:46:05 2013
alter database open migrate
errors in file /opt/app/diag/rdbms/nc/nc1/trace/nc1_dbw0_8399.trc:
ora-01157: cannot identify/lock data file 21 - see dbwr trace file
ora-01110: data file 21: '+indx/nc/datafile/indx.256.820323481'
ora-17503: ksfdopn:2 failed to open file +indx/nc/datafile/indx.256.820323481
ora-15001: diskgroup "indx" does not exist or is not mounted
ora-15001: diskgroup "indx" does not exist or is not mounted
errors in file /opt/app/diag/rdbms/nc/nc1/trace/nc1_dbw0_8399.trc:
ora-01157: cannot identify/lock data file 22 - see dbwr trace file
ora-01110: data file 22: '+indx/nc/datafile/indx.257.820323659'
ora-17503: ksfdopn:2 failed to open file +indx/nc/datafile/indx.257.820323659
ora-15001: diskgroup "indx" does not exist or is not mounted
从alert日志可以看出，indx dg的文件不能被读到，
查看发现indx dg处于dismount状态。

分析：
ASM中创建了2个DG：UNID,INDX.每次只有UNID会被自动mount,而INDX不能被自动MOUNT。
查看asm_diskgroups参数发现只设置了UNID，，这就是为什么每次INDX不会被自动MOUNT的原因了。
SQL>
SQL> show parameter asm

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string UNID
SQL> show parameter pfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string

解决办法：
将INDX添加到asm_diskgroups参数中。
spfile:alter system set asm_diskgroups='UNID','INDX' scope=both;
pfile:修改pfile中asm_diskgroups参数。

相关阅读：

ORA-01172、ORA-01151错误处理

BibiGPT-哔哔终结者

B站视频总结器-一键总结 音视频内容

871

查看详情

ORA-00600 [2662]错误解决

ORA-01078 和 LRM-00109 报错解决方法

ORA-00471 处理方法笔记

ORA-00314,redolog 损坏，或丢失处理方法

ORA-00257 归档日志过大导致无法存储的解决办法