重庆思庄Oracle、Redhat认证学习论坛

标题: 11g rac数据库节点1启动异常，告警ORA-16188 [打印本页]

作者: denglj 时间: 2022-12-29 16:02
标题: 11g rac数据库节点1启动异常，告警ORA-16188

问题描述：11grac数据库节点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 InstanceShutdown

2 OFFLINE OFFLINE InstanceShutdown

ora.scan1.vip

1 ONLINE ONLINE hisdb2

--告警日志如下：

WARNING: The 'LOG_ARCHIVE_CONFIG' init.oraparameter settings

are inconsistent with another startedinstance. This may be

caused by the 'DB_UNIQUE_NAME' init.oraparameter being specified

differently on one or more of the other RACinstances; the

DB_UNIQUE_NAME parameter value MUST beidentical 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 settingsinconsistent 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 instancedue to error 16188

Mon Dec 26 10:30:43 2022

Dumping diagnostic data indirectory=[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 setlog_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数据库.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)