You will be this error when you change a parameter inside the DB and not on dataguard broker (if exists) or the other way around.

DGMGRL> show configuration

Configuration - config

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

    standbydb - Physical standby database
      Warning: ORA-16792: configurable property value is inconsistent with database setting

Fast-Start Failover: DISABLED

Configuration Status:
WARNING   (status updated 38 seconds ago)

DGMGRL>

To know which parameter is having issues, run this:

DGMGRL>  show database standbydb inconsistentproperties
INCONSISTENT PROPERTIES
   INSTANCE_NAME        PROPERTY_NAME         MEMORY_VALUE         SPFILE_VALUE         BROKER_VALUE
         STANDBYDB     ArchiveLagTarget                  900                  900                    0

DGMGRL>

You can change or on the DB, of on the broker,. In this case we are changing on broker side:

DGMGRL> edit database standbydb set property ArchiveLagTarget=900;
Property "archivelagtarget" updated
DGMGRL>
DGMGRL> edit database primary set property ArchiveLagTarget=900;
Property "archivelagtarget" updated
DGMGRL>


DGMGRL> show configuration

Configuration - config

  Protection Mode: MaxPerformance
  Members:
  primarydb - Primary database
    standbydb - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS   (status updated 52 seconds ago)

DGMGRL>

And warning gone!

Last modified: 18 June 2025

Author

Comments

Write a Reply or Comment

Your email address will not be published.