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!
Comments