Warning: ORA-16792: configurable property value is inconsistent with member setting

Warning: ORA-16792: configurable property value is inconsistent with member setting解决方法

1.问题描述

在dataguard搭建完成后，开启dataguard broker的时候报错，操作记录及报错日志如下：

DGMGRL> show configuration;

Configuration - raccfg

  Protection Mode: MaxPerformance
  Members:
  rac    - Primary database
    Warning: ORA-16792: configurable property value is inconsistent with member setting

    stbrac - Physical standby database 

Fast-Start Failover: DISABLED

Configuration Status:
WARNING   (status updated 32 seconds ago)

DGMGRL>
DGMGRL> show database rac InconsistentProperties
INCONSISTENT PROPERTIES
   INSTANCE_NAME        PROPERTY_NAME         MEMORY_VALUE         SPFILE_VALUE         BROKER_VALUE 
            rac2     ArchiveLagTarget                    0                                         0 
            rac2 LogArchiveMinSucceedDest                    1                                         1 
            rac2 DataGuardSyncLatency                    0                                         0 

DGMGRL>  show database rac InconsistentProperties
INCONSISTENT PROPERTIES
   INSTANCE_NAME        PROPERTY_NAME         MEMORY_VALUE         SPFILE_VALUE         BROKER_VALUE 
            rac2     ArchiveLagTarget                    0                                         0 
            rac2 LogArchiveMinSucceedDest                    1                                         1 
            rac2 DataGuardSyncLatency         

2.解决方法

查了一下，发现SPFILE_VALUE 参数是空的，执行如下命令即可解决，你那边报错的参数可能不一样需要根据实际情况修改。

[oracle@rac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Mon Sep 27 13:23:13 2021

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> alter system set archive_lag_target=0 scope=both sid='*';
alter system set log_archive_min_succeed_dest=1 scope=both sid='*';
alter system set data_guard_sync_latency=0 scope=both sid='*';

System altered.

SQL> 
System altered.

SQL> 
System altered.

SQL>