1g数据库里面一个套RAC环境,之前搭建过DG,后来拆除掉。某次演练重启的时候,碰到数据库无法open的情况。
日志显示 WARNING: The 'LOG_ARCHIVE_CONFIG' init.ora parameter settingsare inconsistent with another started instance. This may becaused by the 'DB_UNIQUE_NAME' init.ora parameter being specifieddifferently on one or more of the other RAC instances; theDB_UNIQUE_NAME parameter value MUST be identical for allinstances of the database.Errors in file xxx_lgwr_26567.trc:ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance
之前清除的时候,是直接将log_archive_confi的参数值直接置空。若重启该节点的时候,就会遇到ora-16188错误。
LGWR: terminating instance due to error 16188
然后实例被终止。
问题在于v$dataguard_config在集群间未被同步更新。
解决也好解决
alter system set log_archive_config=NODG_CONFIG scope=both sid='*';