Modifying inconsistencies in a dataguard from broker (dgmgrl)
In a dataguard configured (12.2.0.1) we found some archives in a wrong path in the standby.
We checked the wrong parameter, and we changed its value:
SQL> show parameter log_archive_dest NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_1 string location=/backup/recovery_area [...] SQL> alter system set log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST'; System altered.
But we could see in that moment its status is incorrect in the broker:
DGMGRL> show configuration Configuration - dgorppconfig Protection Mode: MaxPerformance Members: orpplive - Primary database stborpp - Physical standby database Warning: ORA-16792: configurable property value is inconsistent with member setting Fast-Start Failover: DISABLED Configuration Status: WARNING (status updated 42 seconds ago)
After checking the problem:
DGMGRL> show database stborpp inconsistentproperties INCONSISTENT PROPERTIES INSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE stborpp StandbyArchiveLocation USE_DB_RECOVERY_FILE_DEST /opt/oracle/app/oracle/recovery_area/ stborpp AlternateLocation (missing StandbArchiveLocation setting) DGMGRL> show database stborpp statusreport STATUS REPORT INSTANCE_NAME SEVERITY ERROR_TEXT stborpp WARNING ORA-16714: the value of property StandbyArchiveLocation is inconsistent with the member setting stborpp WARNING ORA-16714: the value of property AlternateLocation is inconsistent with the member setting
We check and modify from the broker:
DGMGRL> show database stborpp StandbyArchiveLocation StandbyArchiveLocation = '/opt/oracle/app/oracle/recovery_area/' DGMGRL> show database orpplive StandbyArchiveLocation StandbyArchiveLocation = 'USE_DB_RECOVERY_FILE_DEST' DGMGRL> edit database stborpp set property StandbyArchiveLocation='USE_DB_RECOVERY_FILE_DEST'; Property "standbyarchivelocation" updated
And the status come back to be correct:
DGMGRL> show configuration; Configuration - dgorppconfig Protection Mode: MaxPerformance Members: orpplive - Primary database stborpp - Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS (status updated 55 seconds ago)
Adding value with Arumel!!