问题描述:11g rac数据库节点1启动异常,告警ORA-16188,如下所示:
环境介绍:该rac环境此前搭建过dg,将dg拆除后,一次系统重启便出现节点1数据库无法正常启动,告警ORA-16188.
1、异常重现
[grid@hisdb1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE hisdb1
ONLINE ONLINE hisdb2
ora.FRA.dg
ONLINE ONLINE hisdb1
ONLINE ONLINE hisdb2
ora.LISTENER.lsnr
ONLINE ONLINE hisdb1
ONLINE ONLINE hisdb2
ora.OCRBK.dg
ONLINE ONLINE hisdb1
ONLINE ONLINE hisdb2
ora.asm
ONLINE ONLINE hisdb1 Started
ONLINE ONLINE hisdb2 Started
ora.gsd
OFFLINE OFFLINE hisdb1
OFFLINE OFFLINE hisdb2
ora.net1.network
ONLINE ONLINE hisdb1
ONLINE ONLINE hisdb2
ora.ons
ONLINE ONLINE hisdb1
ONLINE ONLINE hisdb2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE hisdb2
ora.cvu
1 ONLINE ONLINE hisdb2
ora.heal.db
1 ONLINE OFFLINE
2 ONLINE ONLINE hisdb2 Open
ora.hisdb1.vip
1 ONLINE ONLINE hisdb1
ora.hisdb2.vip
1 ONLINE ONLINE hisdb2
ora.oc4j
1 ONLINE ONLINE hisdb2
ora.orcl.db
1 OFFLINE OFFLINE Instance Shutdown
2 OFFLINE OFFLINE Instance Shutdown
ora.scan1.vip
1 ONLINE ONLINE hisdb2
--告警日志如下:
WARNING: The 'LOG_ARCHIVE_CONFIG' init.ora parameter settings
are inconsistent with another started instance. This may be
caused by the 'DB_UNIQUE_NAME' init.ora parameter being specified
differently on one or more of the other RAC instances; the
DB_UNIQUE_NAME parameter value MUST be identical for all
instances of the database.
Errors in file /u01/app/oracle/diag/rdbms/heal/heal1/trace/heal1_lgwr_3486.trc:
ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance
Mon Dec 26 10:30:43 2022
ARC3 started with pid=40, OS id=3562
System state dump requested by (instance=1, osid=3486 (LGWR)), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/diag/rdbms/heal/heal1/trace/heal1_diag_3456_20221226103043.trc
LGWR (ospid: 3486): terminating the instance due to error 16188
Mon Dec 26 10:30:43 2022
Dumping diagnostic data in directory=[cdmp_20221226103043], requested by (instance=1, osid=3486 (LGWR)), summary=[abnormal instance termination].
Instance terminated by LGWR, pid = 3486
2、异常原因
此前清除时是将log_archive_config参数直接置为空,重启时该节点便会出现以上异常.根本原因还是在于参数log_archive_config的默认值设置错误.
3、解决方案
官方文档说明中,该参数的默认值为'SEND, RECEIVE, NODG_CONFIG'.
--按如下修改.
SQL> alter system set log_archive_config=NODG_CONFIG scope=both sid='*';
System altered.
SQL> show parameter log_archive_config
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_config string NODG_CONFIG
说明:此后成功open节点1数据库.
参考文档:https://www.cnblogs.com/syksky/p/9230251.html
11g rac数据库节点1启动异常,告警ORA-16188
原创Liujun_Deng 博主文章分类:Oracle ©著作权
文章标签 ORA-16188 log_archive_config NODG_CONFIG 文章分类 Oracle 数据库
©著作权归作者所有:来自51CTO博客作者Liujun_Deng的原创作品,请联系作者获取转载授权,否则将追究法律责任

提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
11g RAC 节点二MMON进程异常
mmon进程异常
mmon mmnl 进程异常 -
11g rac ORA-01157问题处理
ORA-01157 数据文件路径错误
ORA 01157 数据 -
11G RAC 安装
一、修改系统相关参数 1.修改主机名 vi /etc/hostname 临时方
linux 主机名 ip地址 -
windows下11g rac删除添加节点
windows 2008r2 11g 增删节点步骤
win oracle11g rac