{"id":1677,"date":"2021-10-20T22:08:20","date_gmt":"2021-10-20T20:08:20","guid":{"rendered":"http:\/\/rootfan.com\/?p=1677"},"modified":"2024-06-09T21:52:10","modified_gmt":"2024-06-09T19:52:10","slug":"configuracion-de-data-guard-broker-oracle-19c","status":"publish","type":"post","link":"https:\/\/rootfan.com\/es\/data-guard-broker-configuration-oracle-19c\/","title":{"rendered":"Configuraci\u00f3n Paso a Paso de Data Guard Broker en Oracle 19c"},"content":{"rendered":"<p>Si desea gestionar f\u00e1cilmente un data guard de Oracle, debe utilizar un data guard broker.<\/p>\n\n\n\n<p>El broker de Oracle Data Guard es un marco de gesti\u00f3n distribuido que automatiza y centraliza la creaci\u00f3n, el mantenimiento y la supervisi\u00f3n de las configuraciones de Data Guard.<\/p>\n\n\n\n<p>En mi configuraci\u00f3n, ya he creado un Data Guard. Puede comprobar <a href=\"http:\/\/rootfan.com\/es\/configuracion-de-oracle-19c-data-guard-paso-a-paso\/\" data-type=\"post\" data-id=\"1675\">esta entrada<\/a> para ver c\u00f3mo lo he creado.<\/p>\n\n\n\n<p>BCN es la base de datos primaria y PARIS es la base de datos en espera.<\/p>\n\n\n\n<p>En los comandos de abajo puedes quitar el sid='*' si no tienes una base de datos RAC y deber\u00edas estar listo.<\/p>\n\n\n\n<!--more-->\n\n\n\n<div class=\"wp-block-rank-math-toc-block\" id=\"rank-math-toc\"><h2><strong>\u00cdndice<\/strong><\/h2><nav><div><div class=\"\"><a href=\"#1-reset-log-archive-dest-2\">1. Restablecer LOG_ARCHIVE_DEST_2 <\/a><\/div><div class=\"\"><a href=\"#2-set-dg-broker-config-file\">2. Establecer dg_broker_config_file<\/a><\/div><div class=\"\"><a href=\"#3-enable-the-broker\">3. Habilitar el broker<\/a><\/div><div class=\"\"><a href=\"#4-create-the-configuration\">4. Crear la configuraci\u00f3n<\/a><\/div><div class=\"\"><a href=\"#5-configure-the-listeners\">5. Configurar los oyentes<\/a><\/div><div class=\"\"><a href=\"#6-enable-the-configuration\">6. Habilitar la configuraci\u00f3n<\/a><\/div><\/div><\/nav><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"1-reset-log-archive-dest-2\">1. Restablecer LOG_ARCHIVE_DEST_2 <\/h2>\n\n\n\n<p>En primer lugar, debe borrar el valor de LOG_ARCHIVE_DEST_2 en la base de datos primaria y en la base de datos en espera.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nshow parameter LOG_ARCHIVE_DEST_2\n\nSQL&gt; alter system set LOG_ARCHIVE_DEST_2=&#039;&#039; SCOPE=BOTH sid=&#039;*&#039;;\n<\/pre><\/div>\n\n\n<p>Una vez hecho esto, puede continuar.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"2-set-dg-broker-config-file\">2. Establecer dg_broker_config_file<\/h2>\n\n\n\n<p>Establezca el par\u00e1metro dg_broker_config_file1 y dg_broker_config_file2 en todas las instancias de primario y en espera.<\/p>\n\n\n\n<p>La ubicaci\u00f3n por defecto del archivo de configuraci\u00f3n del broker es $ORACLE_HOME\/dbs o $ORACLE_HOME\/database.<\/p>\n\n\n\n<p>Si desea que los archivos de configuraci\u00f3n del broker se encuentren en una ubicaci\u00f3n no predeterminada, establezca estos par\u00e1metros.<\/p>\n\n\n\n<p>En el caso de una base de datos RAC, establezca la ubicaci\u00f3n del archivo de configuraci\u00f3n del broker como ubicaci\u00f3n compartida y el mismo valor en todas las instancias.<\/p>\n\n\n\n<p>Si no tiene una base de datos RAC no es necesario utilizar el sid='*'.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nALTER SYSTEM SET dg_broker_config_file1 = &#039;&lt;path\/file_name&gt;.dat&#039; scope=both sid=&#039;*&#039;; \nALTER SYSTEM SET dg_broker_config_file2 = &#039;&lt;path\/file_name&gt;.dat&#039; scope=both sid=&#039;*&#039;;\n<\/pre><\/div>\n\n\n<p>O en caso de uso del sistema de archivos ASM:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nALTER SYSTEM SET dg_broker_config_file1 = &#039;&lt;+disk group\/file_name&gt;.dat&#039; scope=both sid=&#039;*&#039;; \nALTER SYSTEM SET dg_broker_config_file2 = &#039;&lt;+disk group\/file_name&gt;.dat&#039; scope=both sid=&#039;*&#039;;\n<\/pre><\/div>\n\n\n<p>Si desea que los archivos de configuraci\u00f3n del broker est\u00e9n en la ubicaci\u00f3n predeterminada, puede ignorar este paso.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"3-enable-the-broker\">3. Habilitar el broker<\/h2>\n\n\n\n<p>Habilite el broker en las bases de datos primaria y en espera.<\/p>\n\n\n\n<p>Si no dispone de una base de datos RAC, no es necesario utilizar sid='*'.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nALTER SYSTEM SET DG_BROKER_START=TRUE scope=both sid=&#039;*&#039;;\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"4-create-the-configuration\">4. Crear la configuraci\u00f3n<\/h2>\n\n\n\n<p>Conectar con DGMGRL en primario:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ dgmgrl\nDGMGRL for Linux: Release 19.0.0.0.0 - Production on Tue Oct 19 17:47:37 2021\nVersion 19.8.0.0.0\n\nCopyright (c) 1982, 2019, Oracle and\/or its affiliates.  All rights reserved.\n\nWelcome to DGMGRL, type &quot;help&quot; for information.\nDGMGRL&gt; CONNECT sys\/password;\nConnected.\n<\/pre><\/div>\n\n\n<p>Crear configuraci\u00f3n en primario:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nDGMGRL&gt; CREATE CONFIGURATION &#039;MYCONF&#039; AS PRIMARY DATABASE IS &#039;BCN&#039; CONNECT IDENTIFIER IS BCN;\nConfiguration &quot;MYCONF&quot; created with primary database &quot;BCN&quot;\n<\/pre><\/div>\n\n\n<p>A\u00f1ade el standby a la configuraci\u00f3n:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nDGMGRL&gt;  ADD DATABASE &#039;PARIS&#039; AS CONNECT IDENTIFIER IS PARIS MAINTAINED AS PHYSICAL;\nDatabase &quot; PARIS &quot; added\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"5-configure-the-listeners\">5. Configurar los oyentes<\/h2>\n\n\n\n<p>Configure la escucha en el servidor primario.<\/p>\n\n\n\n<p>Aseg\u00farese de a\u00f1adir la entrada para el corredor as\u00ed<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nvi $ORACLE_HOME\/network\/admin\/listener.ora\n\n# listener.ora Network Configuration File: \/u01\/app\/oracle\/product\/19.0.0\/db_1\/network\/admin\/listener.ora\n# Generated by Oracle configuration tools.\n\nLISTENER =\n  (DESCRIPTION_LIST =\n    (DESCRIPTION =\n      (ADDRESS = (PROTOCOL = TCP)(HOST = srv1.localdomain)(PORT = 1521))\n      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))\n    )\n  )\n\nSID_LIST_LISTENER=\n   (SID_LIST=\n        (SID_DESC=\n          (GLOBAL_DBNAME=BCN.localdomain)\n          (SID_NAME=BCN)\n          (ORACLE_HOME=\/u01\/app\/oracle\/product\/19.0.0\/db_1)\n        )\n        (SID_DESC=\n          (GLOBAL_DBNAME=BCN_DGMGRL.localdomain)\n          (SID_NAME=BCN)\n          (ORACLE_HOME=\/u01\/app\/oracle\/product\/19.0.0\/db_1)\n        )\n      )\n<\/pre><\/div>\n\n\n<p>Y recargar el oyente<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nlsnrctl reload\n<\/pre><\/div>\n\n\n<p>Configure la escucha en el servidor en espera.<\/p>\n\n\n\n<p>Aseg\u00farate de a\u00f1adir la entrada para _DGMGRL.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nvi $ORACLE_HOME\/network\/admin\/listener.ora\n\n# listener.ora Network Configuration File: \/u01\/app\/oracle\/product\/19.0.0\/db_1\/network\/admin\/listener.ora\n# Generated by Oracle configuration tools.\n\nLISTENER =\n  (DESCRIPTION_LIST =\n    (DESCRIPTION =\n      (ADDRESS = (PROTOCOL = TCP)(HOST = srv2.localdomain)(PORT = 1521))\n      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))\n    )\n  )\n\nSID_LIST_LISTENER=\n   (SID_LIST=\n        (SID_DESC=\n          (GLOBAL_DBNAME=PARIS.localdomain)\n          (SID_NAME=PARIS)\n          (ORACLE_HOME=\/u01\/app\/oracle\/product\/19.0.0\/db_1)\n        )\n        (SID_DESC=\n          (GLOBAL_DBNAME=PARIS_DGMGRL.localdomain)\n          (SID_NAME=PARIS)\n          (ORACLE_HOME=\/u01\/app\/oracle\/product\/19.0.0\/db_1)\n        )\n      )\n<\/pre><\/div>\n\n\n<p>Y recargar el oyente en espera tambi\u00e9n<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nlsnrctl reload\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"6-enable-the-configuration\">6. Habilitar la configuraci\u00f3n<\/h2>\n\n\n\n<p>Ahora s\u00f3lo tienes que activar la configuraci\u00f3n que acabas de crear.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nDGMGRL&gt; ENABLE CONFIGURATION;\nEnabled.\n<\/pre><\/div>\n\n\n<p>Utilice el comando SHOW para verificar que la configuraci\u00f3n y sus bases de datos se han habilitado y puesto en l\u00ednea correctamente:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nDGMGRL&gt; SHOW CONFIGURATION;\n\nConfiguration\nName: MYCONF\nEnabled: YES\nProtection Mode: MaxPerformance\nFast-Start Failover: DISABLED\n\nDatabases:\nBCN - Primary database\nPARIS - Physical standby database\n\nCurrent status for &quot;MYCONF&quot;\nSUCCESS\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>Si desea gestionar f\u00e1cilmente un Data Guard de Oracle, debe utilizar un broker de Data Guard. El broker de Oracle Data Guard es un marco de gesti\u00f3n distribuido que automatiza y centraliza la creaci\u00f3n, mantenimiento y monitorizaci\u00f3n de las configuraciones de Data Guard. En mi configuraci\u00f3n, ya he creado un Data Guard. Puedes consultar este post para ... <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/rootfan.com\/es\/data-guard-broker-configuration-oracle-19c\/\" class=\"more-link\">Seguir leyendo<span class=\"screen-reader-text\"> \"Configuraci\u00f3n Paso a Paso de Data Guard Broker en Oracle 19c\"<\/span><\/a><\/p>","protected":false},"author":1,"featured_media":2934,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_focus_keyword":"Data Guard Broker Configuration","rank_math_title":"","rank_math_description":"Configure Data Guard Broker in Oracle 19c with this step-by-step guide. #DataGuard #BrokerConfiguration #Oracle19c","rank_math_robots":"","rank_math_og_title":"","rank_math_og_description":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[31],"tags":[34,32],"class_list":["post-1677","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-broker","tag-data-guard"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/rootfan.com\/wp-content\/uploads\/pexels-photo-2166711.jpeg?fit=1880%2C1254&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/1677","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/comments?post=1677"}],"version-history":[{"count":26,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/1677\/revisions"}],"predecessor-version":[{"id":6161,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/1677\/revisions\/6161"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media\/2934"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media?parent=1677"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/categories?post=1677"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/tags?post=1677"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}