{"id":2367,"date":"2023-11-13T12:03:50","date_gmt":"2023-11-13T11:03:50","guid":{"rendered":"http:\/\/clemente.pamplona.name\/dba\/?p=2367"},"modified":"2025-05-08T17:42:53","modified_gmt":"2025-05-08T15:42:53","slug":"resincronizar-un-dataguard-bastante-desactualizado","status":"publish","type":"post","link":"http:\/\/clemente.pamplona.name\/dba\/resincronizar-un-dataguard-bastante-desactualizado\/","title":{"rendered":"Resincronizar un dataguard bastante desactualizado"},"content":{"rendered":"<p>Hoy veremos rapidamente una entrada de como podemos volver a dejar una PHYSICAL standby de nuevo sincronizada .<br \/>\nSupongamos que entramos a ver el estado de nuestro dataguard y nos encontramos con esto.<\/p>\n<pre>\r\nConfiguration - TEST_SNDBY\r\n  Protection Mode: MaxPerformance\r\n  Members:\r\n  TEST- Primary database\r\n    Error: ORA-16724: cannot resolve gap for one or more members\r\n    TEST_STBY- Physical standby database\r\n      Warning: ORA-16809: multiple warnings detected for the member\r\nFast-Start Failover:  Disabled\r\nConfiguration Status:\r\nERROR   (status updated 50 seconds ago)\r\n\r\nDGMGRL> show database 'TEST_STBY';\r\nDatabase - TEST_SNDBY\r\n  Role:               PHYSICAL STANDBY\r\n  Intended State:     APPLY-ON\r\n  Transport Lag:      104 days 20 hours 8 minutes 57 seconds (computed 1 second ago)\r\n  Apply Lag:          104 days 20 hours 8 minutes 58 seconds (computed 2 seconds ago)\r\n  Average Apply Rate: 0 Byte\/s\r\n  Real Time Query:    OFF\r\n  Instance(s):\r\n    TEST\r\n  Database Warning(s):\r\n    ORA-16853: apply lag has exceeded specified threshold\r\n    ORA-16855: transport lag has exceeded specified threshold\r\nDatabase Status:\r\nWARNING\r\n<DGMGRL> \r\n<\/Pre>\r\n\r\n<h1> Que hacemos ahora? <\/h1>\r\nLlevamos mas de tres meses de retraso, lo que probablemente significara casi el rehacer la database.\r\nLa solucion desde la 19 es muy sencilla, y es resincronizar mediante red con el comando <b><i>   RECOVER STANDBY DATABASE FROM SERVICE TEST_DGMGRL;<\/I><\/b>\r\nLos pasos exactos serian\r\n\r\n<pre>\r\n$ORACLE_HOME\/bin\/sqlplus \"\/as sysdba\" << EOF\r\n recover managed standby database cancel;\r\n alter system set dg_broker_start=false;\r\n shutdown immediate;\r\n startup nomount;\r\n alter database mount standby database;\r\nEOF\r\n \r\n$ORACLE_HOME\/bin\/dgmgrl \/  << EOF\r\nRECOVER STANDBY DATABASE FROM SERVICE TEST_DGMGRL;\r\nEOF\r\n\r\n$ORACLE_HOME\/bin\/sqlplus \"\/as sysdba\" << EOF\r\n alter system set dg_broker_start=true;\r\nEOF\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Hoy veremos rapidamente una entrada de como podemos volver a dejar una PHYSICAL standby de nuevo sincronizada . Supongamos que entramos a ver el estado de nuestro dataguard y nos encontramos con esto. Configuration &#8211; TEST_SNDBY Protection Mode: MaxPerformance Members: &hellip; <a href=\"http:\/\/clemente.pamplona.name\/dba\/resincronizar-un-dataguard-bastante-desactualizado\/\">Sigue leyendo <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[975,52],"tags":[1037,873,1038,1039,798,806],"class_list":["post-2367","post","type-post","status-publish","format-standard","hentry","category-19c","category-dataguard","tag-apply-lag","tag-dataguard","tag-physical-standby","tag-recover-standby-database","tag-restore","tag-standby"],"_links":{"self":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2367","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/comments?post=2367"}],"version-history":[{"count":3,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2367\/revisions"}],"predecessor-version":[{"id":2396,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2367\/revisions\/2396"}],"wp:attachment":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/media?parent=2367"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/categories?post=2367"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/tags?post=2367"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}