使用Data Guard迁移数据库后,rac 2节点启动失败ora-16188 问题原因 1、 rac 2节点启动失败,提示ORA-16188 LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance [oracle@xxdb2 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 5 19:51:52 2022 Copyright (...
之前清除的时候,是直接将log_archive_confi的参数值直接置空。若重启该节点的时候,就会遇到ora-16188错误。 LGWR: terminating instance due to error16188 然后实例被终止。 问题在于v$dataguard_config在集群间未被同步更新。 解决也好解决 altersystemsetlog_archive_config=NODG_CONFIG scope=both sid='*'; ...
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 /u02/diag/rdbms/<DB UNIQUE NAME>/<SID>/trace/<SID>_lgwr_21567.trc: ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with prev...
ORA-16188 Cloud Applications Cloud Infrastructure On-Premises Applications Middleware Database Engineered Systems Java Systems Operating Environments Virtualization Industry-Specific Applications Architecture Center Tutorials and Labs All Services & Products
ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance LGWR: terminating instance due to error 16188 and instance will be terminated. ++ Problem is v$dataguard_config is not updated between instances Changes Cause
问题描述:11grac数据库节点1启动异常,告警ORA-16188,如下所示: 环境介绍:该rac环境此前搭建过DG,将DG拆除后一次系统重启便出现节点1数据库无法正常启动,告警ORA-16188. 1、异常重现 [grid@hisdb1 ~]$ CRSCTL stat res -t --- 命名目标状态服务器STATE_DETAILS --- ...
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]. ...
问题描述:11g rac数据库节点1启动异常,告警ORA-16188,如下所示: 环境介绍:该rac环境此前搭建过dg,将dg拆除后,一次系统重启便出现节点1数据库无法正常启动,告警ORA-16188. 1、异常重现 [grid@hisdb1 ~]$ crsctl stat res -t --- NAME TARGET STATE SERVER STATE_DETAILS ---...