DG Broker Error – ORA-16714
Issue:
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
Data collection:
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 DGMGRL>
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. SQL>
On Primary
DGMGRL> show database "DELL_DG" statusreport STATUS REPORT INSTANCE_NAME SEVERITY ERROR_TEXT <---- No errors this time DGMGRL> DGMGRL> DGMGRL> show configuration; Configuration - DELL Protection Mode: MaxPerformance Databases: DELL - Primary database DELL_DG - Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS <---------- DGMGRL>
Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.
Thank you,
Rajasekhar Amudala
Email: br8dba@gmail.com
WhatsApp : +
Linkedin: https://www.linkedin.com/in/rajasekhar-amudala/