联系：手机/微信(+86 17813235971) QQ(107644445)
标题：ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
客户反馈,rac有一个节点无法open(可以mount),在open过程报如下错误
alert日志内容中报错主要为:
ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance
Thu Feb 29 17:46:15 2024
Successful mount of redo thread 1, with mount id 354054158
Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE)
Lost write protection disabled
Completed: ALTER DATABASE MOUNT /* db agent *//* {1:32636:2} */
ALTER DATABASE OPEN /* db agent *//* {1:32636:2} */
Picked broadcast on commit scheme to generate SCNs
ARCH: STARTING ARCH PROCESSES
Thu Feb 29 17:46:16 2024
ARC0 started with pid=39, OS id=15401176
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Thu Feb 29 17:46:18 2024
ARC1 started with pid=41, OS id=11993228
Thu Feb 29 17:46:18 2024
ARC2 started with pid=42, OS id=15007986
Thu Feb 29 17:46:18 2024
ARC3 started with pid=43, OS id=12779724
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
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 /oracle/oracle/diag/rdbms/xff/xff1/trace/xff1_lgwr_12976288.trc:
ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance
LGWR (ospid: 12976288): terminating the instance due to error 16188
Thu Feb 29 17:46:18 2024
System state dump requested by(instance=1, osid=12976288 (LGWR)),summary=[abnormal instance termination].
System State dumped to trace file /oracle/oracle/diag/rdbms/xff/xff1/trace/xff1_diag_13041806.trc
Thu Feb 29 17:46:18 2024
ORA-1092 : opitsk aborting process
Thu Feb 29 17:46:19 2024
License high water mark = 1
Instance terminated by LGWR, pid = 12976288
USER (ospid: 15532254): terminating the instance
Instance terminated by USER, pid = 15532254
检查LOG_ARCHIVE_CONFIG和DB_UNIQUE_NAME参数配置
SQL> select inst_id,value,name,length(value) from gv$parameter where name in ('log_archive_config','db_unique_name');
INST_ID VALUE NAME LENGTH(VALUE)
---------- ------------------------------ ------------------------------------- -------------
2 log_archive_config
2 xff db_unique_name 8
1 log_archive_config
1 xff db_unique_name 8
设置尝试log_archive_config配置为”和reset 均数据库无法正常启动
SQL> alter system set log_archive_config='' sid='*'; 系统已更改。 SQL> alter system reset log_archive_config scope=both sid='*'; 系统已更改。
设置log_archive_config=NODG_CONFIG数据库启动成功
SQL> alter system set log_archive_config=NODG_CONFIG scope=both sid='*'; 系统已更改。 SQL> alter database open; 数据库已更改。 SQL> exit 从 Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options 断开
