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

DGMGRL> show configuration
Warning: ORA-16714: the value of property ArchiveLagTarget is inconsistent with the database setting
Warning: ORA-16714: the value of property LogArchiveMaxProcesses is inconsistent with the database setting
Warning: ORA-16714: the value of property LogArchiveMinSucceedDest is inconsistent with the database setting
 
DGMGRL> show database ‘PRIMARY’ InconsistentProperties
INCONSISTENT PROPERTIES
INSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE
swx2 ArchiveLagTarget 0 0
swx2 LogArchiveMaxProcesses 4 4
swx2 LogArchiveMinSucceedDest 1 1
 
SOLUTION :
—————–
 
FROM SQLPLUS SET THE PARAMETERS AND UPDATE IN SPFILE AND MEMORY
SQL> alter system set log_archive_max_processes=4 scope=both sid=’*’;
SQL> alter system set archive_lag_target=0 scope=both sid=’*’;
SQL> alter system set log_archive_min_succeed_dest=1 scope=both sid=’*’;

Category: Database

Tags:

One comment

  1. Thank you very much, Mr. Shadab for providing a solution for a problem I was facing with one of my standby databases in multiple standby Data Guard setup. This set was also successful with your invaluable assistance in the past.
    Now, dg broker configuration is showing success for both of standby databases.

    Thanks and regards
    Mohammad Ahsan

Leave a Reply

Article by: Shadab Mohammad