{"id":1675,"date":"2021-09-26T09:53:08","date_gmt":"2021-09-26T07:53:08","guid":{"rendered":"http:\/\/rootfan.com\/?p=1675"},"modified":"2024-06-09T21:54:39","modified_gmt":"2024-06-09T19:54:39","slug":"configuracion-de-oracle-19c-data-guard-paso-a-paso","status":"publish","type":"post","link":"https:\/\/rootfan.com\/es\/oracle-19c-data-guard-configuration-step-by-step\/","title":{"rendered":"Configuraci\u00f3n de Oracle 19c Data Guard Paso a Paso"},"content":{"rendered":"<p>Si quieres configurar un Oracle 19c Data Guard entonces necesitas tener 2 servidores.<\/p>\n\n\n\n<p>Un Data Guard f\u00edsico es la configuraci\u00f3n por defecto de Oracle Data Guard.<\/p>\n\n\n\n<p>Proporciona una copia f\u00edsicamente id\u00e9ntica de la base de datos primaria, con estructuras de base de datos en disco que son id\u00e9nticas a la base de datos primaria bloque por bloque. El esquema de la base de datos, incluidos los \u00edndices, es el mismo. <\/p>\n\n\n\n<p>Una base de datos standby f\u00edsica se mantiene sincronizada con la base de datos primaria, a trav\u00e9s de Redo Apply, que recupera los datos de archivelog recibidos de la base de datos primaria y aplica el archivelog a la base de datos f\u00edsica en espera.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>En el servidor 1, deber\u00edas tener una base de datos ya creada y en el servidor 2, s\u00f3lo necesitas los binarios sin base de datos creada.<\/p>\n\n\n\n<p>Uso \/etc\/hosts para configurar la resoluci\u00f3n de nombres.<\/p>\n\n\n\n<p>Aqu\u00ed est\u00e1 mi \/etc\/hosts en ambos servidores<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4\n::1         localhost localhost.localdomain localhost6 localhost6.localdomain6\n192.168.1.130 srv1.localdomain srv1\n192.168.1.131 srv2.localdomain srv2\n<\/pre><\/div>\n\n\n<p>En esta gu\u00eda te mostrar\u00e9 c\u00f3mo crear una base de datos standby entre Barcelona y Par\u00eds.<\/p>\n\n\n\n<p>Es bastante f\u00e1cil si sigues este paso a paso de configuraci\u00f3n de data guard.<\/p>\n\n\n\n<p>BCN es la base de datos primaria en el servidor srv1.<\/p>\n\n\n\n<p>PARIS es la base de datos standby en el servidor srv2.<\/p>\n\n\n\n<div class=\"wp-block-rank-math-toc-block\" id=\"rank-math-toc\"><h2>\u00cdndice<\/h2><nav><div><div><a href=\"#1-prepare-the-primary-database\">1. Preparar la base de datos primaria<\/a><\/div><div><a href=\"#2-prepare-the-standby-database\">2. Prepara la base de datos standby<\/a><\/div><div><a href=\"#3-duplicate-the-database\">3. Duplica la base de datos<\/a><\/div><div><a href=\"#4-perform-a-switchover-with-sqlplus\">4. Realiza un switchover con sqlplus<\/a><\/div><div><a href=\"#5-troubleshooting\">5. Soluci\u00f3n de problemas<\/a><\/div><\/div><\/nav><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"1-prepare-the-primary-database\">1. Preparar la base de datos primaria<\/h2>\n\n\n\n<p>Primero debes activar el archivelog en tu base de datos.<\/p>\n\n\n\n<p>Activar archivelog<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nsqlplus \/ as sysdba\nselect log_mode from v$database ;\nalter system set log_archive_dest_1 = &#039;LOCATION=USE_DB_RECOVERY_FILE_DEST&#039; scope=both;\nshutdown immediate\nstartup mount\nalter database archivelog;\nalter database open;\nalter system switch logfile;\nselect name from v$archived_log;\n<\/pre><\/div>\n\n\n<p>Activar el force logging<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect force_logging from v$database;\nalter database force logging;\nselect force_logging from v$database;\n<\/pre><\/div>\n\n\n<p>Comprobar el tama\u00f1o de los redo logs<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect group#, thread#, bytes\/1024\/1024 mb from v$log;\nselect thread#, instance from v$thread ;\n<\/pre><\/div>\n\n\n<p>Crear los standby redo logs<\/p>\n\n\n\n<p>Debes crear los standby logfiles del mismo tama\u00f1o que el resultado que tuviste en la consulta anterior, y tambi\u00e9n del mismo n\u00famero.<\/p>\n\n\n\n<p>Como tengo 3 redo logs y su tama\u00f1o es de 200m, entonces creo 3 standby logfiles de 200m cada uno.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nalter database add standby logfile thread 1 size 200m;\nalter database add standby logfile thread 1 size 200m;\nalter database add standby logfile thread 1 size 200m;\n<\/pre><\/div>\n\n\n<p>Comprobar los standby redo logs<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect group#, thread#, sequence#, bytes\/1024\/1024 mb, archived, status \nfrom v$standby_log;\n\nselect member from v$logfile where type = &#039;STANDBY&#039;;\n<\/pre><\/div>\n\n\n<p>Comprobar db_unique_name<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nshow parameter db_unique_name\n<\/pre><\/div>\n\n\n<p>Configurar log_archive_config<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nalter system set log_archive_config=&#039;DG_CONFIG=(BCN,PARIS)&#039; scope=both;\n<\/pre><\/div>\n\n\n<p>Establecer log_archive_dest_2<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nalter system set log_archive_dest_2=&#039;SERVICE=PARIS ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PARIS&#039; scope=both;\n<\/pre><\/div>\n\n\n<p>Establecer fal_server<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nshow parameter fal_server ;\nalter system set fal_server =&#039;PARIS&#039; scope=both;\n<\/pre><\/div>\n\n\n<p>fal_client ya no es necesario en Oracle 19c.<\/p>\n\n\n\n<p>Configurar el standby_file_management<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nshow parameter standby_file_management\nalter system set standby_file_management=&#039;AUTO&#039; scope=both;\n<\/pre><\/div>\n\n\n<p>Obten una lista de par\u00e1metros dependientes del directorio y crea los directorios necesarios en el servidor standby:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect name, value from v$parameter \nwhere upper(value) like upper(&#039;%\/bcn\/%&#039;);\n<\/pre><\/div>\n\n\n<p>Crear\u00e1s el directorio adump m\u00e1s adelante.<\/p>\n\n\n\n<p>Activa el flashback<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nalter database flashback on;\n<\/pre><\/div>\n\n\n<p>Comprueba el password file.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nls \/u01\/app\/oracle\/product\/19.0.0\/db_1\/dbs\/orapw*\n<\/pre><\/div>\n\n\n<p>A\u00f1ade a tnsnames.ora<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nvi $TNS_ADMIN\/tnsnames.ora\n\nBCN =\n  (DESCRIPTION =\n    (ADDRESS = (PROTOCOL = TCP)(HOST = srv1.localdomain)(PORT = 1521))\n    (CONNECT_DATA =\n      (SERVER = DEDICATED)\n      (SERVICE_NAME = BCN.localdomain)\n    )\n  )\n\nLISTENER_BCN =\n  (ADDRESS = (PROTOCOL = TCP)(HOST = srv1.localdomain)(PORT = 1521))\n\nPARIS =\n  (DESCRIPTION =\n    (ADDRESS = (PROTOCOL = TCP)(HOST = srv2.localdomain)(PORT = 1521))\n    (CONNECT_DATA =\n      (SERVER = DEDICATED)\n      (SERVICE_NAME = PARIS.localdomain)\n    )\n  )\n<\/pre><\/div>\n\n\n<p>En el servidor primario, a\u00f1ade una entrada est\u00e1tica para el listener<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nvi $TNS_ADMIN\/listener.ora\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      )\n<\/pre><\/div>\n\n\n<p>Recarga el listener<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nlsnrctl reload\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"2-prepare-the-standby-database\">2. Prepara la base de datos standby<\/h2>\n\n\n\n<p>Crea un archivo init con s\u00f3lo el db_name.<\/p>\n\n\n\n<p>Recuerda que db_name ser\u00e1 el mismo tanto en la base de datos primaria como en la base standby.<\/p>\n\n\n\n<p>S\u00f3lo el db_unique_name ser\u00e1 diferente.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\necho &#039;DB_NAME=BCN&#039; &gt; $ORACLE_HOME\/dbs\/initPARIS.ora\n<\/pre><\/div>\n\n\n<p>Copia el archivo de passwords del servidor primario al servidor standby.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nscp oracle@srv1:\/u01\/app\/oracle\/product\/19.0.0\/db_1\/dbs\/orapwBCN \/u01\/app\/oracle\/product\/19.0.0\/db_1\/dbs\/orapwPARIS\n\nls -al \/u01\/app\/oracle\/product\/19.0.0\/db_1\/dbs\/orapwPARIS\n<\/pre><\/div>\n\n\n<p>Copia el archivo tnsnames.ora<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nscp oracle@srv1:\/u01\/app\/oracle\/product\/19.0.0\/db_1\/network\/admin\/tnsnames.ora \/u01\/app\/oracle\/product\/19.0.0\/db_1\/network\/admin\/tnsnames.ora\n<\/pre><\/div>\n\n\n<p>En el servidor standby, a\u00f1ade una entrada est\u00e1tica en el listener que ser\u00e1 necesaria para duplicar una base de datos<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nvi $TNS_ADMIN\/listener.ora\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      )\n<\/pre><\/div>\n\n\n<p>Recarga el listener<\/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>Crea la carpeta adump<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nmkdir -p \/u01\/app\/oracle\/admin\/PARIS\/adump\n<\/pre><\/div>\n\n\n<p>Inicia la BD standby en nomount<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nsqlplus \/ as sysdba\nstartup nomount\nexit\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"3-duplicate-the-database\">3. Duplica la base de datos<\/h2>\n\n\n\n<p>Con\u00e9ctate a RMAN<\/p>\n\n\n\n<p>Debe conectarse a la base de datos primaria y a la base de datos en espera al mismo tiempo.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nrman TARGET sys\/oracle@BCN AUXILIARY sys\/oracle@PARIS\n<\/pre><\/div>\n\n\n<p>Duplica la base de datos<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nDUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE DORECOVER\nSPFILE\nSET DB_UNIQUE_NAME &#039;PARIS&#039; COMMENT &#039;Is standby&#039;\nSET LOG_ARCHIVE_DEST_2 &#039;SERVICE=BCN ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=BCN&#039;\nSET AUDIT_FILE_DEST &#039;\/u01\/app\/oracle\/admin\/PARIS\/adump&#039;\nSET CONTROL_FILES &#039;\/u01\/app\/oracle\/oradata\/PARIS\/controlfile\/control01.ctl&#039;\nSET FAL_SERVER &#039;BCN&#039;\nNOFILENAMECHECK;\n<\/pre><\/div>\n\n\n<p>Una vez realizado el comando de duplicar, ya habr\u00e1s creado tu base de datos standby.<\/p>\n\n\n\n<p>Ahora con\u00e9ctate a la base de datos standby y verifica su rol.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nsqlplus \/ as sysdba\nselect database_role from v$database;\nshow parameter db_name\nshow parameter db_unique_name\n<\/pre><\/div>\n\n\n<p>El db_name debe ser el mismo que el de la base de datos primaria y el db_unique_name debe ser PARIS.<\/p>\n\n\n\n<p>Ahora inicia el proceso de aplicaci\u00f3n de redo en la base de datos standby.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nalter database recover managed standby database \ndisconnect from session;\n<\/pre><\/div>\n\n\n<p>Comprueba en la base de datos standby que est\u00e9 aplicando los arhivelogs con esto.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect role, thread#, sequence#, action \nfrom v$dataguard_process;\n<\/pre><\/div>\n\n\n<p>Ahora ve al servidor primario y comprueba tambi\u00e9n los archivelogs y haz un switch logfile para generar un nuevo archivelog<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect sequence#, first_time, next_time \nfrom v$archived_log\norder by sequence#;\n\nalter system switch logfile;\n<\/pre><\/div>\n\n\n<p>Ahora ve a la base de datos standby y comprueba que se ha aplicado el nuevo archivelog.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect sequence#, first_time, next_time, applied \nfrom v$archived_log\norder by sequence#;\n<\/pre><\/div>\n\n\n<p>Deten el proceso de recuperaci\u00f3n en la standby<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nalter database recover managed standby database cancel;\n<\/pre><\/div>\n\n\n<p>Activa el flashback en la standby<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nalter database flashback on;\n<\/pre><\/div>\n\n\n<p>Vuelva a iniciar el proceso de recuperaci\u00f3n en la standby<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nalter database recover managed standby database \ndisconnect from session;\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"4-perform-a-switchover-with-sqlplus\">4. Realiza un switchover con sqlplus<\/h2>\n\n\n\n<p>Primero confirma que la sincronizaci\u00f3n est\u00e1 lista para realizar un switchover<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nsqlplus \/ as sysdba\nalter database switchover to PARIS verify;\n<\/pre><\/div>\n\n\n<p>Si no aparece ning\u00fan error en el comando anterior, entonces todo est\u00e1 bien.<\/p>\n\n\n\n<p>Si tienes errores, consulta el alert log para tener m\u00e1s detalles.<\/p>\n\n\n\n<p>En la base de datos primaria, comprueba que no hay ning\u00fan gap<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect status, gap_status \nfrom v$archive_dest_status \nwhere dest_id = 2;\n<\/pre><\/div>\n\n\n<p>Switchover a la base de datos standby<\/p>\n\n\n\n<p>Ejecutar desde la base de datos primaria:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nalter database switchover to PARIS;\n<\/pre><\/div>\n\n\n<p>Ahora ve a srv2 (que es ahora la base de datos primaria) y abre la base de datos<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nsqlplus \/ as sysdba\nalter database open;\n<\/pre><\/div>\n\n\n<p>Ahora ve a srv1 (la nueva base de datos standby) y monta la base de datos<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nstartup mount\nalter database recover managed standby database disconnect;\n<\/pre><\/div>\n\n\n<p>En srv1 verifica que todo est\u00e1 bien<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nselect database_role from v$database;\n\nselect role, thread#, sequence#, action from v$dataguard_process;\n<\/pre><\/div>\n\n\n<p>Ahora volvamos todo al punto de partida.<\/p>\n\n\n\n<p>Realizar\u00e1s un switchback.<\/p>\n\n\n\n<p>Comprueba primero que ambas bases de datos est\u00e1n listas.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nalter database switchover to BCN verify;\n<\/pre><\/div>\n\n\n<p>Ahora ve a srv2 y ejecuta el switchover de nuevo.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nalter database switchover to BCN;\n<\/pre><\/div>\n\n\n<p>Y abre la base de datos en srv1<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nalter database open;\n<\/pre><\/div>\n\n\n<p>En srv2 monta la base de datos e inicia de nuevo el proceso de recuperaci\u00f3n<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nstartup mount\nalter database recover managed standby database disconnect;\n<\/pre><\/div>\n\n\n<p>En srv2 verifica que el switchback ha sido correcto<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect database_role from v$database;\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"5-troubleshooting\">5. Soluci\u00f3n de problemas<\/h2>\n\n\n\n<p>Si tienes problemas, comprueba los par\u00e1metros en la base de datos primaria y en la base de datos standby con esta consulta.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nset linesize 200 pages 50\ncol value for a85\ncol name for a50\n\nselect name, value \nfrom gv$parameter\nwhere name in (&#039;db_name&#039;,&#039;db_unique_name&#039;,&#039;log_archive_config&#039;,    \n&#039;log_archive_dest_1&#039;,&#039;log_archive_dest_2&#039;,&#039;log_archive_dest_3&#039;,\n&#039;log_archive_dest_state_1&#039;,&#039;log_archive_dest_state_2&#039;,&#039;log_archive_dest_state_3&#039;, \n&#039;remote_login_passwordfile&#039;,&#039;log_archive_format&#039;,&#039;log_archive_max_processes&#039;,\n&#039;fal_server&#039;,&#039;fal_client&#039;,&#039;db_file_name_convert&#039;,\n&#039;log_file_name_convert&#039;, &#039;standby_file_management&#039;) \norder by 1;\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>Si desea configurar un Oracle 19c Data Guard entonces necesita tener 2 servidores. Un Data Guard f\u00edsico es la configuraci\u00f3n por defecto de Oracle Data Guard. Proporciona una copia f\u00edsicamente id\u00e9ntica de la base de datos primaria, con estructuras de base de datos en disco que son id\u00e9nticas a la base de datos primaria bloque a bloque. El esquema de la base de datos, ... <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/rootfan.com\/es\/oracle-19c-data-guard-configuration-step-by-step\/\" class=\"more-link\">Seguir leyendo<span class=\"screen-reader-text\"> \"Configuraci\u00f3n de Oracle 19c Data Guard Paso a Paso\"<\/span><\/a><\/p>","protected":false},"author":1,"featured_media":2928,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_focus_keyword":"Oracle 19c Data Guard Configuration","rank_math_title":"","rank_math_description":"Create an Oracle 19c Data Guard step by step. Become proficient in Oracle 19c Data Guard configuration with this comprehensive guide.","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":[79,32],"class_list":["post-1675","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-configuration","tag-data-guard"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/rootfan.com\/wp-content\/uploads\/pexels-photo-391522.jpeg?fit=1734%2C1300&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/1675","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=1675"}],"version-history":[{"count":60,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/1675\/revisions"}],"predecessor-version":[{"id":6162,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/1675\/revisions\/6162"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media\/2928"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media?parent=1675"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/categories?post=1675"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/tags?post=1675"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}