DG Broker Error – ORA-16714

ORA-16714: the value of property ArchiveLagTarget is inconsistent with the database setting

ORA-16714: the value of property LogArchiveMaxProcesses is inconsistent with the database setting

ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the database setting

On Primary

[oracle@rac1 ~]$ dgmgrl
DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production

Copyright (c) 2000, 2009, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
DGMGRL> connect /
Connected.
DGMGRL>
DGMGRL>
DGMGRL> show configuration;

Configuration - DELL

  Protection Mode: MaxPerformance
  Databases:
    DELL    - Primary database
    DELL_DG - Physical standby database
      Warning: ORA-16792: configurable property value is inconsistent with database setting

Fast-Start Failover: DISABLED

Configuration Status:
WARNING <------------

DGMGRL>

DGMGRL> SHOW CONFIGURATION VERBOSE;

Configuration - DELL

  Protection Mode: MaxPerformance
  Databases:
    DELL    - Primary database
    DELL_DG - Physical standby database
      Warning: ORA-16792: configurable property value is inconsistent with database setting

  Properties:
    FastStartFailoverThreshold      = '30'
    OperationTimeout                = '30'
    FastStartFailoverLagLimit       = '30'
    CommunicationTimeout            = '180'
    ObserverReconnect               = '0'
    FastStartFailoverAutoReinstate  = 'TRUE'
    FastStartFailoverPmyShutdown    = 'TRUE'
    BystandersFollowRoleChange      = 'ALL'
    ObserverOverride                = 'FALSE'
    ExternalDestination1            = ''
    ExternalDestination2            = ''
    PrimaryLostWriteAction          = 'CONTINUE'

Fast-Start Failover: DISABLED

Configuration Status:
WARNING

DGMGRL> 

DGMGRL> show database "DELL" statusreport;
STATUS REPORT
       INSTANCE_NAME   SEVERITY ERROR_TEXT

DGMGRL> show database "DELL_DG" statusreport
STATUS REPORT
       INSTANCE_NAME   SEVERITY ERROR_TEXT
             DELL_DG    WARNING ORA-16714: the value of property ArchiveLagTarget is inconsistent with the database setting
             DELL_DG    WARNING ORA-16714: the value of property LogArchiveMaxProcesses is inconsistent with the database setting
             DELL_DG    WARNING ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the database setting

DGMGRL> 

DGMGRL> show database "DELL_DG" InconsistentProperties
INCONSISTENT PROPERTIES
   INSTANCE_NAME        PROPERTY_NAME         MEMORY_VALUE         SPFILE_VALUE         BROKER_VALUE
         DELL_DG     ArchiveLagTarget                    0                                         0
         DELL_DG LogArchiveMaxProcesses                    4                                         4
         DELL_DG LogArchiveMinSucceedDest                    1                                         1

Solution:

On Standby

SQL> select name,open_mode,db_unique_name,database_role from v$database;

NAME      OPEN_MODE            DB_UNIQUE_NAME                 DATABASE_ROLE
--------- -------------------- ------------------------------ ----------------
DELL      MOUNTED              DELL_DG                        PHYSICAL STANDBY

SQL>

SQL> alter system set log_archive_max_processes=4 scope=both;

System altered.

SQL> alter system set archive_lag_target=0 scope=both;

System altered.

SQL>  alter system set log_archive_min_succeed_dest=1 scope=both;

System altered.

Related posts

Error: ORA-16765: Redo Apply is running

Khắc phục lỗi recovery khi OPEN RESETLOGS lỗi SYSTEM trong Oracle Database?

check the FRA usage and troubleshoot the issue in oracle DB