环境:
双节点RAC+单节点DG,数据库版本11.2.0.4
问题描述:
RAC中的node1因为故障自动重启,但是在数据库open的时候,报错
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 tpemr1_lgwr_7408.trc:
ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance
LGWR(ospid: 7048): terminating the instance due to error 16188
![点击并拖拽以移动 wAAACH5BAEKAAAALAAAAAABAAEAAAICRAEAOw==](https://img-blog.csdnimg.cn/2022010620295529425.gif)
ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance
从网上查资料 结合数据库实际情况确定,是由于在RAC拆完DG后,参数修改不正确,导致数据库重启后open失败
我的修改操作:
alter system set log_archive_config='' scope=both sid='*' 和alter system reset log_archive_config scope=both sid='*'
经验证这两种方式都不对
正确的修改操作:
alter system set log_archive_config=NODG_CONFIG scope=both sid='*';
问题在于v$dataguard_config在集群间未被同步更新。