<\/p>\n
In a dataguard configured (12.2.0.1) we found some archives in a wrong path in the standby.<\/p>\n
We checked the wrong parameter, and we changed its value:<\/p>\n
SQL> show parameter log_archive_dest\n\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\nlog_archive_dest_1 string location=\/backup\/recovery_area\n[...]\n\nSQL> alter system set log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST';\n\nSystem altered.<\/pre>\n<\/p>\n
But we could see in that moment its status is incorrect in the broker:<\/p>\n
DGMGRL> show configuration\nConfiguration - dgorppconfig\nProtection Mode: MaxPerformance\nMembers:\norpplive - Primary database\nstborpp - Physical standby database\nWarning: ORA-16792: configurable property value is inconsistent with member setting\n\nFast-Start Failover: DISABLED\n\nConfiguration Status:\nWARNING (status updated 42 seconds ago)<\/pre>\n<\/p>\n
After checking the problem:<\/p>\n
DGMGRL> show database stborpp inconsistentproperties\nINCONSISTENT PROPERTIES\nINSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE\nstborpp StandbyArchiveLocation USE_DB_RECOVERY_FILE_DEST \/opt\/oracle\/app\/oracle\/recovery_area\/\nstborpp AlternateLocation (missing StandbArchiveLocation setting)\n\nDGMGRL> show database stborpp statusreport\nSTATUS REPORT\nINSTANCE_NAME SEVERITY ERROR_TEXT\nstborpp WARNING ORA-16714: the value of property StandbyArchiveLocation is inconsistent with the member setting\nstborpp WARNING ORA-16714: the value of property AlternateLocation is inconsistent with the member setting<\/pre>\n<\/p>\n
We check and modify from the broker:<\/p>\n
DGMGRL> show database stborpp StandbyArchiveLocation\nStandbyArchiveLocation = '\/opt\/oracle\/app\/oracle\/recovery_area\/'\n\nDGMGRL> show database orpplive StandbyArchiveLocation\nStandbyArchiveLocation = 'USE_DB_RECOVERY_FILE_DEST'\n\nDGMGRL> edit database stborpp set property StandbyArchiveLocation='USE_DB_RECOVERY_FILE_DEST';\nProperty \"standbyarchivelocation\" updated<\/pre>\n<\/p>\n
And the status come back to be correct:<\/p>\n
DGMGRL> show configuration;\nConfiguration - dgorppconfig\nProtection Mode: MaxPerformance\nMembers:\norpplive - Primary database\nstborpp - Physical standby database\n\nFast-Start Failover: DISABLED\n\nConfiguration Status:\nSUCCESS (status updated 55 seconds ago)<\/pre>\n<\/p>\n