标签：11g rac instance ONLINE OFFLINE 16188 hisdb1 hisdb2 ora
问题描述：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,
instance,
ONLINE,
OFFLINE,
16188,
hisdb1,
hisdb2,
ora
From： https://blog.51cto.com/u_12991611/5970891