<\/p>\n
En un dataguard ya montado (12.2.0.1) encontramos que los archives se estaban guardando err\u00f3neamente en una ruta de la standby.<\/p>\n
Despu\u00e9s de comprobar el par\u00e1metro que los estaba dejando all\u00ed, procedimos a su modificaci\u00f3n para que estuviera igual que en la primary.<\/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
Pero al hacer la comprobaci\u00f3n del estado del dataguard desde el broker nos aparece un error:<\/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
Tras las comprobaciones:<\/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
Comprobamos y modificamos desde el 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
Y el estado del dataguard vuelve a ser correcto:<\/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