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=’*’;

Advertisements

One thought on “Warning: ORA-16714: the value of property is inconsistent with the database setting

  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

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s