{"id":8480,"date":"2017-10-01T23:23:27","date_gmt":"2017-10-01T21:23:27","guid":{"rendered":"http:\/\/arumel.com\/?p=8480"},"modified":"2017-10-01T23:23:27","modified_gmt":"2017-10-01T21:23:27","slug":"limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile","status":"publish","type":"post","link":"https:\/\/arumel.com\/eu\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\/","title":{"rendered":"Limitaci\u00f3n en conversi\u00f3n autom\u00e1tica de standby controlfile a primary controlfile"},"content":{"rendered":"<p>Desde la versi\u00f3n 11g, la posibilidad de descargar los backups RMAN en una BD standby f\u00edsica (no aplica en standby l\u00f3gica) es completa, pudiendo hacer copia del controlfile para recuperar cualquier rol Data Guard (primaria o standby). Podemos por lo tanto hacer copias de la BD en una standby sin preocuparnos de c\u00f3mo generar, de ser necesario, un controlfile CURRENT en un escenario de disaster recovery de producci\u00f3n, ya que Oracle gestionar\u00e1 de manera autom\u00e1tica y transparente la conversi\u00f3n de rol que sea necesaria (aplica tambi\u00e9n a una standby a partir de un controlfile current). Como requisito, debemos configurar correctamente las BDs primaria y standby en el cat\u00e1logo RMAN, importante para una correcta ejecuci\u00f3n de los backups y escenarios de recuperaci\u00f3n en esta configuraci\u00f3n. Esta funcionalidad de intercambio de roles de controlfile entre primaria y standby aparece <a href=\"https:\/\/docs.oracle.com\/cd\/B28359_01\/server.111\/b28294\/rman.htm#BAJDCCGD\">documentada desde la versi\u00f3n 11.1<\/a> de base de datos. En esta documentaci\u00f3n se indica que los metadatos almacenados en el cat\u00e1logo RMAN permiten hacer un seguimiento correcto de todos los nombres de los ficheros de las BDs que componen la configuraci\u00f3n Data Guard, haciendo posible el intercambio de datafiles y controlfiles.<\/p>\n<p>Recientemente, haciendo una validaci\u00f3n de restore cruzado a un nuevo servidor en un cliente, encontr\u00e9 con que aparentemente esta premisa no se cumpl\u00eda, y la restauraci\u00f3n del controlfile manten\u00eda el nuevo controlfile de la BD como standby. Tras diferentes pruebas y consulta de informaci\u00f3n y de notas Metalink, encontramos que el problema ven\u00eda derivado del bug 18455956, que en realidad s\u00f3lo se presenta en un escenario en el que la restauraci\u00f3n del controlfile es ejecutado sin conexi\u00f3n al cat\u00e1logo RMAN, que era justo la prueba que quer\u00edamos validar haciendo una apertura con resetlogs sin con ello impactar al resto de la configuraci\u00f3n Data Guard registrada en el mismo cat\u00e1logo, evitando a\u00f1adir una nueva encarnaci\u00f3n &#8220;falsa&#8221; derivada de esta prueba. El objetivo global era validar un escenario en el que derivar todas las tareas de backup a una BD standby, pero este problema me hizo plantear la posibilidad de tener que hacer backups del controlfile primario (ayudado, todo sea dicho, por un error en la documentaci\u00f3n de certificaci\u00f3n Fecha Guard de Oracle University donde se indicaba que los controlfiles no son intercambiables entre primary y standby).<\/p>\n<p>Para verificar las posibilidades reales, creamos una BD single instance en un servidor con una standby f\u00edsica en otro. Para simplificar las cosas, las dos m\u00e1quinas son en realidad un cl\u00faster con Grid Infrastructure, que comparten acceso a un filesystem ACFS montado en \/acfs\/desdata. La BD primaria tiene por nombre <strong>alberto<\/strong> y la standby <strong>bertodg<\/strong> (nomenclatura de Sergio la quien debo agradecer que montara este contorno en un tiempo r\u00e9cord con su magia usando gdbClone!). Antes de hacer las pruebas de restauraci\u00f3n, ejecutamos en <strong>bertodg <\/strong>(standby) simplemente el comando <strong>backup database<\/strong> que hizo un backup a la FRA configurada en el mismo filesystem. Por lo tanto es un escenario sencillo donde los backups de las BDs est\u00e1n disponibles en los dos entornos sin necesidad de copiar datos previamente o tenerlos que recatalogar antes de restaurar.<\/p>\n<h1>Restauraci\u00f3n de BD primaria con copia de standby usando conexi\u00f3n a cat\u00e1logo RMAN<\/h1>\n<p>Conectados a la BD <strong>alberto<\/strong> (primaria) y al cat\u00e1logo, en esta prueba el script RMAN restaura expl\u00edcitamente el controfile del backup hecho previamente en la BD <strong>bertodg<\/strong> (standby). Pese a ser un standby controlfile, y sin especificar nada en el comando RMAN, este es restaurado de manera autom\u00e1tica como un current controlfile v\u00e1lido para una BD primaria.<\/p>\n<pre class=\"theme:terminal lang:default decode:true\">[oracle@nodo1 ]$ rman target \/ catalog=usrcat\/xxxxxx@rman\r\nRMAN&gt; run\r\n{\r\n  shutdown immediate;\r\n  startup nomount;\r\n  restore controlfile from '\/acfs\/desdata\/bertodg\/BERTODG\/backupset\/2017_09_29\/el1_mf_ncsnf_TAG20170929T120630_dww6sbyk_.bkp';\r\n  alter database mount;\r\n  restore database;\r\n  recover database noredo;\r\n  alter database open resetlogs;\r\n}2&gt; 3&gt; 4&gt; 5&gt; 6&gt; 7&gt; 8&gt; 9&gt; 10&gt; \r\n\r\ndatabase closed\r\ndatabase dismounted\r\nOracle instance shut down\r\n\r\nconnected to target database (not started)\r\nOracle instance started\r\n\r\nTotal System Global Arena    4275781632 bytees\r\n\r\nFixed Size                     2260088 bytees\r\nVariable Size               2449474440 bytees\r\nDatabase Buffers            1811939328 bytees\r\nRedo Buffers                  12107776 bytees\r\n\r\nStarting restore at 29\/09\/2017 12:54:12\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=212 device type=DISK\r\n\r\nchannel ORA_DISK_1: restoring control file\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:01\r\noutput file name=\/acfs\/desdata\/alberto\/control01.ctl\r\nFinished restore at 29\/09\/2017 12:54:13\r\n\r\ndatabase mounted\r\nreleased channel: ORA_DISK_1\r\n\r\nStarting restore at 29\/09\/2017 12:54:17\r\nStarting implicit crosscheck backup at 29\/09\/2017 12:54:17\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=212 device type=DISK\r\nCrosschecked 1 objects\r\nFinished implicit crosscheck backup at 29\/09\/2017 12:54:18\r\n\r\nStarting implicit crosscheck copy at 29\/09\/2017 12:54:18\r\nusing channel ORA_DISK_1\r\nCrosschecked 2 objects\r\nFinished implicit crosscheck copy at 29\/09\/2017 12:54:18\r\n\r\nsearching fuere all files in the recovery arena\r\ncataloging files...\r\ncataloging done\r\n\r\nList of Cataloged Files\r\n=======================\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_28\/el1_mf_1_34_06sfjc3k_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_28\/el1_mf_1_1_dwsnj7rf_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_28\/el1_mf_1_2_dwsnjx2d_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_28\/el1_mf_1_3_dwsnlrhm_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_28\/el1_mf_1_4_dwsnlvhy_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_28\/el1_mf_1_5_dwt92r23_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_28\/el1_mf_1_6_dwt92wjf_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_28\/el1_mf_1_7_dwtrr0tq_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_29\/el1_mf_1_8_dwvggf46_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_29\/el1_mf_1_1_dww55lnk_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_29\/el1_mf_1_2_dww55q9x_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_29\/el1_mf_1_3_dww5rdbj_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_29\/el1_mf_1_4_dww7z6wb_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_29\/el1_mf_1_1_dww7z75j_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_29\/el1_mf_1_2_dww7zbnc_.arc\r\n\r\nusing channel ORA_DISK_1\r\n\r\nchannel ORA_DISK_1: restoring datafile 00001\r\ninput datafile copy RECID=11 STAMP=955976061 file name=\/acfs\/desdata\/.ACFS\/snaps\/bertodg\/BERTODG\/datafile\/el1_mf_system_03sfjd9lo_.dbf\r\ndestination fuere restore of datafile 00001: \/acfs\/desdata\/.ACFS\/snaps\/alberto\/ALBERTO\/datafile\/el1_mf_system_02sfjc33_.dbf\r\nchannel ORA_DISK_1: copied datafile copy of datafile 00001\r\noutput file name=\/acfs\/desdata\/.ACFS\/snaps\/alberto\/ALBERTO\/datafile\/el1_mf_system_02sfjc33_.dbf RECID=15 STAMP=955976062\r\nchannel ORA_DISK_1: restoring datafile 00002\r\ninput datafile copy RECID=12 STAMP=955976061 file name=\/acfs\/desdata\/.ACFS\/snaps\/bertodg\/BERTODG\/datafile\/el1_mf_sysaux_04sfjd9lo_.dbf\r\ndestination fuere restore of datafile 00002: \/acfs\/desdata\/.ACFS\/snaps\/alberto\/ALBERTO\/datafile\/el1_mf_sysaux_03sfjc33_.dbf\r\nchannel ORA_DISK_1: copied datafile copy of datafile 00002\r\noutput file name=\/acfs\/desdata\/.ACFS\/snaps\/alberto\/ALBERTO\/datafile\/el1_mf_sysaux_03sfjc33_.dbf RECID=16 STAMP=955976065\r\nchannel ORA_DISK_1: restoring datafile 00003\r\ninput datafile copy RECID=13 STAMP=955976061 file name=\/acfs\/desdata\/.ACFS\/snaps\/bertodg\/BERTODG\/datafile\/el1_mf_undotbs1_05sfjd9lo_.dbf\r\ndestination fuere restore of datafile 00003: \/acfs\/desdata\/.ACFS\/snaps\/alberto\/ALBERTO\/datafile\/el1_mf_undotbs1_04sfjc33_.dbf\r\nchannel ORA_DISK_1: copied datafile copy of datafile 00003\r\noutput file name=\/acfs\/desdata\/.ACFS\/snaps\/alberto\/ALBERTO\/datafile\/el1_mf_undotbs1_04sfjc33_.dbf RECID=17 STAMP=955976068\r\nchannel ORA_DISK_1: restoring datafile 00004\r\ninput datafile copy RECID=14 STAMP=955976061 file name=\/acfs\/desdata\/.ACFS\/snaps\/bertodg\/BERTODG\/datafile\/el1_mf_users_06sfjd9r_.dbf\r\ndestination fuere restore of datafile 00004: \/acfs\/desdata\/.ACFS\/snaps\/alberto\/ALBERTO\/datafile\/el1_mf_users_05sfjc3i_.dbf\r\nchannel ORA_DISK_1: copied datafile copy of datafile 00004\r\noutput file name=\/acfs\/desdata\/.ACFS\/snaps\/alberto\/ALBERTO\/datafile\/el1_mf_users_05sfjc3i_.dbf RECID=18 STAMP=955976068\r\n\r\ndatafile 1 switched to datafile copy\r\ninput datafile copy RECID=19 STAMP=955976069 file name=\/acfs\/desdata\/.ACFS\/snaps\/alberto\/ALBERTO\/datafile\/el1_mf_system_02sfjc33_.dbf\r\ndatafile 2 switched to datafile copy\r\ninput datafile copy RECID=20 STAMP=955976069 file name=\/acfs\/desdata\/.ACFS\/snaps\/alberto\/ALBERTO\/datafile\/el1_mf_sysaux_03sfjc33_.dbf\r\ndatafile 3 switched to datafile copy\r\ninput datafile copy RECID=21 STAMP=955976069 file name=\/acfs\/desdata\/.ACFS\/snaps\/alberto\/ALBERTO\/datafile\/el1_mf_undotbs1_04sfjc33_.dbf\r\ndatafile 4 switched to datafile copy\r\ninput datafile copy RECID=22 STAMP=955976069 file name=\/acfs\/desdata\/.ACFS\/snaps\/alberto\/ALBERTO\/datafile\/el1_mf_users_05sfjc3i_.dbf\r\nFinished restore at 29\/09\/2017 12:54:29\r\n\r\nStarting recover at 29\/09\/2017 12:54:30\r\nusing channel ORA_DISK_1\r\nrenamed tempfile 1 to \/acfs\/desdata\/.ACFS\/snaps\/alberto\/ALBERTO\/datafile\/el1_mf_temp_dwsmc1kp_.tmp in control file\r\n\r\nFinished recover at 29\/09\/2017 12:54:31\r\n\r\ndatabase opened\r\nnew incarnation of database registered in recovery catalog\r\nstarting full resync of recovery catalog\r\nfull resync complete\r\nstarting full resync of recovery catalog\r\nfull resync complete<\/pre>\n<h1>Restauraci\u00f3n de BD primaria con copia de standby sin conexi\u00f3n a cat\u00e1logo RMAN<\/h1>\n<p>Repetimos la prueba anterior, pero esta vez sin conectar al cat\u00e1logo RMAN. Funcionan la restauraci\u00f3n y la recuperaci\u00f3n, pero <strong>no es posible abrir la BD<\/strong> porque el controlfile no fue modificado por Oracle durante el proceso y sigue marcado como standby.<\/p>\n<pre class=\"theme:terminal lang:default decode:true\">[oracle@nodo1 ]$ rman target \/\r\n\r\nRecovery Manager: Release 11.2.0.4.0 - Production on Sun Oct 1 15:57:04 2017\r\n\r\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.  All rights reserved.\r\n\r\nconnected to target database: ALBERTO (DBID=2724215542)\r\n\r\nRMAN&gt; run\r\n{\r\n  shutdown immediate;\r\n  startup nomount;\r\n  restore controlfile from '\/acfs\/desdata\/bertodg\/BERTODG\/backupset\/2017_09_29\/el1_mf_ncsnf_TAG20170929T120630_dww6sbyk_.bkp';\r\n  alter database mount;\r\n  restore database;\r\n  recover database noredo;\r\n  alter database open resetlogs;\r\n}2&gt; 3&gt; 4&gt; 5&gt; 6&gt; 7&gt; 8&gt; 9&gt; 10&gt; \r\n\r\nusing target database control file instead of recovery catalog\r\ndatabase closed\r\ndatabase dismounted\r\nOracle instance shut down\r\n\r\nconnected to target database (not started)\r\nOracle instance started\r\n\r\nTotal System Global Arena    4275781632 bytees\r\n\r\nFixed Size                     2260088 bytees\r\nVariable Size               2449474440 bytees\r\nDatabase Buffers            1811939328 bytees\r\nRedo Buffers                  12107776 bytees\r\n\r\nStarting restore at 01\/10\/2017 15:57:24\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=212 device type=DISK\r\n\r\nchannel ORA_DISK_1: restoring control file\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:01\r\noutput file name=\/acfs\/desdata\/alberto\/control01.ctl\r\nFinished restore at 01\/10\/2017 15:57:25\r\n\r\ndatabase mounted\r\nreleased channel: ORA_DISK_1\r\n\r\nStarting restore at 01\/10\/2017 15:57:30\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=212 device type=DISK\r\n\r\nskipping datafile 1; already restored to file \/acfs\/desdata\/.ACFS\/snaps\/bertodg\/BERTODG\/datafile\/el1_mf_system_03sfjd9lo_.dbf\r\nskipping datafile 2; already restored to file \/acfs\/desdata\/.ACFS\/snaps\/bertodg\/BERTODG\/datafile\/el1_mf_sysaux_04sfjd9lo_.dbf\r\nskipping datafile 3; already restored to file \/acfs\/desdata\/.ACFS\/snaps\/bertodg\/BERTODG\/datafile\/el1_mf_undotbs1_05sfjd9lo_.dbf\r\nskipping datafile 4; already restored to file \/acfs\/desdata\/.ACFS\/snaps\/bertodg\/BERTODG\/datafile\/el1_mf_users_06sfjd9r_.dbf\r\nrestore not done; all files read only, offline, or already restored\r\nFinished restore at 01\/10\/2017 15:57:31\r\n\r\nStarting recover at 01\/10\/2017 15:57:31\r\nusing channel ORA_DISK_1\r\n\r\nFinished recover at 01\/10\/2017 15:57:32\r\n\r\nRMAN-00571: ===========================================================\r\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\r\nRMAN-00571: ===========================================================\r\nRMAN-03002: failure of alter db command at 10\/01\/2017 15:57:33\r\nORA-01666: control file is for a standby database<\/pre>\n<p>Verificamos que el controlfile no fue transformado en CURRENT durante la operaci\u00f3n de RESTORE CONTROLFILE.<\/p>\n<pre class=\"theme:terminal lang:default decode:true\">SQL&gt; select controlfile_type from v$database;\r\n\r\nCONTROL\r\n-------\r\nSTANDBY<\/pre>\n<h1>Bug 18455856<\/h1>\n<p>Parece l\u00f3gico que al no contar con el cat\u00e1logo no sea posible tomar la decisi\u00f3n de convertir un controlfile a un tipo diferente del momento en el que se hizo backup, ya que Oracle no tiene la referencia del rol que desempe\u00f1a la BD que restauramos dentro de la configuraci\u00f3n Data Guard. De hecho, para cubrir este hecho, el comando RESTORE CONTROLFILE puede ser empleado, <a href=\"https:\/\/docs.oracle.com\/cd\/B28359_01\/backup.111\/b28273\/rcmsynta037.htm#RCMRF149\">ya desde 11gR1<\/a>, en 3 posibles variantes:<\/p>\n<ul>\n<li><strong>RESTORE CONTROLFILE<\/strong>. El controlfile es restaurado en la BD a la que estamos conectado y su tipo ser\u00e1 determinado en funci\u00f3n del rol asignado a la BD en el cat\u00e1logo RMAN al que estamos conectados. La BD sobre la que estamos trabajando mantendr\u00e1 el mismo rol que ten\u00eda registrada en el cat\u00e1logo antes de iniciar la recuperaci\u00f3n.<\/li>\n<li><strong>RESTORE PRIMARY CONTROLFILE<\/strong>. Con este comando forzamos que el controlfile que restauramos, sea un backup de una primary o de una standby, sea configurado para su uso en una BD primaria.<\/li>\n<li><strong>RESTORE STANDBY CONTROLFILE<\/strong>. El controlfile restaurado ser\u00e1 configurado c\u00f3mo STANDBY independientemente del rol que tuviera la BD desde la que fue hecho el backup.<\/li>\n<\/ul>\n<p>De este modo, tenemos la opci\u00f3n de restaurar un controlfile de manera autom\u00e1tica manteniendo el rol original si conectamos a un repositorio RMAN, y tenemos la opci\u00f3n de hacer una conversi\u00f3n espec\u00edfica en caso de que vayamos a cambiar el rol de la BD o de que no podamos determinarlo de manera autom\u00e1tica al no conectar al cat\u00e1logo. Si consultamos la nota <span id=\"kmPgTpl:r1:0:ol22\" class=\"xq\"><strong>Step by Step method to create Primary\/Standby Database from Standby Backup (Doc ID 1604251.1)<\/strong>, vemos que, como consecuencia de la correci\u00f3n del bug <span id=\"kmPgTpl:r1:ot71\" class=\"kmContent\">7553431<\/span>, aparece un nuevo bug, el <span id=\"kmPgTpl:r1:ot71\" class=\"kmContent\">18455956<\/span>. Sin el correspondiente parche aplicado, el comando RESTORE PRIMARY CONTROLFILE no hace la conversi\u00f3n necesaria si no estamos empleando un cat\u00e1logo RMAN cuando recuperamos una copia hecha en una standby. Si conectamos al cat\u00e1logo RMAN (workaround propuesto en el bug), desaparece el problema.<br \/>\n<\/span><\/p>\n<p>En nuestro escenario, comprobamos que el parche 18455956 no est\u00e1 instalado, con un nivel de PSU de abril de 2017.<\/p>\n<pre class=\"theme:terminal lang:default decode:true\">[oracle@nodo1 ]$ $ORACLE_HOME\/OPatch\/opatch lsinventory | grep \"Patch Set Update\"\r\nPatch description:  \"Database Patch Set Update : 11.2.0.4.170418 (24732075)\"\r\nSub-patch  24006111; \"Database Patch Set Update : 11.2.0.4.161018 (24006111)\"\r\nSub-patch  23054359; \"Database Patch Set Update : 11.2.0.4.160719 (23054359)\"\r\nSub-patch  22502456; \"Database Patch Set Update : 11.2.0.4.160419 (22502456)\"\r\nSub-patch  21948347; \"Database Patch Set Update : 11.2.0.4.160119 (21948347)\"\r\nSub-patch  21352635; \"Database Patch Set Update : 11.2.0.4.8 (21352635)\"\r\nSub-patch  20760982; \"Database Patch Set Update : 11.2.0.4.7 (20760982)\"\r\nSub-patch  20299013; \"Database Patch Set Update : 11.2.0.4.6 (20299013)\"\r\nSub-patch  19769489; \"Database Patch Set Update : 11.2.0.4.5 (19769489)\"\r\nSub-patch  19121551; \"Database Patch Set Update : 11.2.0.4.4 (19121551)\"\r\nSub-patch  18522509; \"Database Patch Set Update : 11.2.0.4.3 (18522509)\"\r\nSub-patch  18031668; \"Database Patch Set Update : 11.2.0.4.2 (18031668)\"\r\nSub-patch  17478514; \"Database Patch Set Update : 11.2.0.4.1 (17478514)\"\r\n\r\n[oracle@nodo1 ]$ $ORACLE_HOME\/OPatch\/opatch lsinventory | grep 18455956\r\n[oracle@nodo1 ]$<\/pre>\n<p>Al ser as\u00ed, podemos verificar que la restauraci\u00f3n falla cuando no empleamos cat\u00e1logo, incluso especificando la opci\u00f3n PRIMARY, como podemos ver en la siguiente prueba:<\/p>\n<pre class=\"theme:terminal lang:default decode:true\">[oracle@nodo1 ]$ rman target \/\r\n \r\nRecovery Manager: Release 11.2.0.4.0 - Production on Sun Oct 1 15:58:16 2017\r\n \r\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.  All rights reserved.\r\n \r\nconnected to target database: ALBERTO (DBID=2724215542)\r\n\r\nRMAN&gt; run\r\n{\r\n  shutdown immediate;\r\n  startup nomount;\r\n  restore primary controlfile from '\/acfs\/desdata\/bertodg\/BERTODG\/backupset\/2017_09_29\/el1_mf_ncsnf_TAG20170929T120630_dww6sbyk_.bkp';\r\n  alter database mount;\r\n  restore database;\r\n  recover database noredo;\r\n  alter database open resetlogs;\r\n}2&gt; 3&gt; 4&gt; 5&gt; 6&gt; 7&gt; 8&gt; 9&gt; 10&gt; \r\n\r\ndatabase dismounted\r\nOracle instance shut down\r\n\r\nconnected to target database (not started)\r\nOracle instance started\r\n\r\nTotal System Global Arena    4275781632 bytees\r\n\r\nFixed Size                     2260088 bytees\r\nVariable Size               2449474440 bytees\r\nDatabase Buffers            1811939328 bytees\r\nRedo Buffers                  12107776 bytees\r\n\r\nStarting restore at 01\/10\/2017 15:58:17\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=212 device type=DISK\r\n\r\nchannel ORA_DISK_1: restoring control file\r\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:01\r\noutput file name=\/acfs\/desdata\/alberto\/control01.ctl\r\nFinished restore at 01\/10\/2017 15:58:19\r\n\r\ndatabase mounted\r\nreleased channel: ORA_DISK_1\r\n\r\nStarting restore at 01\/10\/2017 15:58:23\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=212 device type=DISK\r\n\r\nskipping datafile 1; already restored to file \/acfs\/desdata\/.ACFS\/snaps\/bertodg\/BERTODG\/datafile\/el1_mf_system_03sfjd9lo_.dbf\r\nskipping datafile 2; already restored to file \/acfs\/desdata\/.ACFS\/snaps\/bertodg\/BERTODG\/datafile\/el1_mf_sysaux_04sfjd9lo_.dbf\r\nskipping datafile 3; already restored to file \/acfs\/desdata\/.ACFS\/snaps\/bertodg\/BERTODG\/datafile\/el1_mf_undotbs1_05sfjd9lo_.dbf\r\nskipping datafile 4; already restored to file \/acfs\/desdata\/.ACFS\/snaps\/bertodg\/BERTODG\/datafile\/el1_mf_users_06sfjd9r_.dbf\r\nrestore not done; all files read only, offline, or already restored\r\nFinished restore at 01\/10\/2017 15:58:24\r\n\r\nStarting recover at 01\/10\/2017 15:58:24\r\nusing channel ORA_DISK_1\r\n\r\nFinished recover at 01\/10\/2017 15:58:25\r\n\r\nRMAN-00571: ===========================================================\r\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\r\nRMAN-00571: ===========================================================\r\nRMAN-03002: failure of alter db command at 10\/01\/2017 15:58:25\r\nORA-01666: control file is for a standby database<\/pre>\n<h1>Alternativas sin uso de cat\u00e1logo<\/h1>\n<p>Ahora que conocemos tanto el problema como su alcance, podemos emplear diferentes alternativas como soluci\u00f3n. La primera pasa por recrear el controfile desde la propia BD standby para la recuperaci\u00f3n de la BD primaria.<\/p>\n<p>Puede resultar interesante saber que la BD standby que hemos recuperado puede ser abiera en modo s\u00f3lo lectura.<\/p>\n<pre class=\"theme:terminal lang:default decode:true\">SQL&gt; alter database open read only;\r\n\r\nDatabase altered.<\/pre>\n<p>Otra soluci\u00f3n pasa por la apertura de la BD recuperada, que ser\u00e1 una standby, como una BD primaria, forzando un failover de la misma. Previamente para evitar errores eliminamos los standby logs y tambi\u00e9n deshabilitamos flashback database, para evitar errores durante la apertura en el intento de habilitar flashback database.<\/p>\n<pre class=\"theme:terminal lang:default decode:true\">SQL&gt; select * from v$logfile;\r\n\r\n    GROUP# ESTATUS  TYPE    MEMBER\t\t\t\t\t\t\t\t\t    IS_\r\n---------- ------- ------- -------------------------------------------------------------------------------- ---\r\n\t 3\t   ONLINE  \/acfs\/desdata\/bertodg\/BERTODG\/onlinelog\/el1_mf_3_dwsnjzp0_.log\t\t    EN El\r\n\t 2\t   ONLINE  \/acfs\/desdata\/bertodg\/BERTODG\/onlinelog\/el1_mf_2_dwsnjzkj_.log\t\t    EN El\r\n\t 1\t   ONLINE  \/acfs\/desdata\/bertodg\/BERTODG\/onlinelog\/el1_mf_1_dwsnjzdr_.log\t\t    EN El\r\n\t 4\t   STANDBY \/acfs\/desdata\/bertodg\/BERTODG\/onlinelog\/el1_mf_4_dww5rdg9_.log\t\t    EN El\r\n\t 5\t   STANDBY \/acfs\/desdata\/bertodg\/BERTODG\/onlinelog\/el1_mf_5_dww5rdgy_.log\t\t    EN El\r\n\t 6\t   STANDBY \/acfs\/desdata\/bertodg\/BERTODG\/onlinelog\/el1_mf_6_dww5rdg2_.log\t\t    EN El\r\n\r\n\r\nSQL&gt; alter database clear logfile group 4;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; alter database clear logfile group 5;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; alter database clear logfile group 6;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; alter database open;\r\nalter database open\r\n*\r\nERROR at line 1:\r\nORA-38760: This database instance failed to turn on flashback database\r\n\r\nSQL&gt; alter database flashback off;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; alter database open;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; alter database flashback on;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt; select controlfile_type from v$database;\r\n\r\nCONTROL\r\n-------\r\nCURRENT<\/pre>\n<h1>Resumen<\/h1>\n<p>Debemos emplear cat\u00e1logo RMAN siempre para hacer copias en un entorno Data Guard. Pese a ello, hay escenarios, como una prueba de restauraci\u00f3n para convalidar los procedimientos internos de backup, en las que nos puede interesar evitar el uso del cat\u00e1logo para no interferir en la configuraci\u00f3n real de las copias. En casos como \u00e9ste, debemos ser conscientes, si estamos en la versi\u00f3n 11.2.0.4 (no afecta a 11.2.0.3 o anteriores), de la existencia del bug 18455856 por lo que tendremos que optar, bien por la aplicaci\u00f3n del correspondiente parche, bien por la procedimentaci\u00f3n del escenario habida cuenta la limitaci\u00f3n en la conversi\u00f3n a primary controlfile cuando no nos conectamos al cat\u00e1logo RMAN.<\/p>\n<h1>Cr\u00e9ditos<\/h1>\n<p>Ilustraci\u00f3n: Alicia Constela<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Desde la versi\u00f3n 11g, la posibilidad de descargar los backups RMAN en una BD standby f\u00edsica (no aplica en standby l\u00f3gica) es completa, pudiendo hacer copia del controlfile para recuperar cualquier rol Data Guard (primaria o standby). Podemos por lo tanto hacer copias de la BD en una standby sin preocuparnos de c\u00f3mo generar, de [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":8474,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[109,41,47],"tags":[],"class_list":["post-8480","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle-eu","category-portada-eu","category-slider-post-eu"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Limitaci\u00f3n en conversi\u00f3n autom\u00e1tica de standby controlfile a primary controlfile - Arumel<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/arumel.com\/eu\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Limitaci\u00f3n en conversi\u00f3n autom\u00e1tica de standby controlfile a primary controlfile - Arumel\" \/>\n<meta property=\"og:description\" content=\"Desde la versi\u00f3n 11g, la posibilidad de descargar los backups RMAN en una BD standby f\u00edsica (no aplica en standby l\u00f3gica) es completa, pudiendo hacer copia del controlfile para recuperar cualquier rol Data Guard (primaria o standby). Podemos por lo tanto hacer copias de la BD en una standby sin preocuparnos de c\u00f3mo generar, de [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/arumel.com\/eu\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\/\" \/>\n<meta property=\"og:site_name\" content=\"Arumel\" \/>\n<meta property=\"article:published_time\" content=\"2017-10-01T21:23:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/10\/ilustracion.alicia.suricata.01.png?fit=1294%2C1246&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"1294\" \/>\n\t<meta property=\"og:image:height\" content=\"1246\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Alberto Pereiro\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alberto Pereiro\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"15 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/arumel.com\\\/eu\\\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/eu\\\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\\\/\"},\"author\":{\"name\":\"Alberto Pereiro\",\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/1cdc5947f4270801792b02ec92332edc\"},\"headline\":\"Limitaci\u00f3n en conversi\u00f3n autom\u00e1tica de standby controlfile a primary controlfile\",\"datePublished\":\"2017-10-01T21:23:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/eu\\\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\\\/\"},\"wordCount\":1336,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/eu\\\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/ilustracion.alicia.suricata.01.png?fit=1294%2C1246&ssl=1\",\"articleSection\":[\"Oracle\",\"portada\",\"slider-post\"],\"inLanguage\":\"eu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/arumel.com\\\/eu\\\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/arumel.com\\\/eu\\\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\\\/\",\"url\":\"https:\\\/\\\/arumel.com\\\/eu\\\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\\\/\",\"name\":\"Limitaci\u00f3n en conversi\u00f3n autom\u00e1tica de standby controlfile a primary controlfile - Arumel\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/eu\\\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/eu\\\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/ilustracion.alicia.suricata.01.png?fit=1294%2C1246&ssl=1\",\"datePublished\":\"2017-10-01T21:23:27+00:00\",\"author\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/1cdc5947f4270801792b02ec92332edc\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/eu\\\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\\\/#breadcrumb\"},\"inLanguage\":\"eu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/arumel.com\\\/eu\\\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"eu\",\"@id\":\"https:\\\/\\\/arumel.com\\\/eu\\\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/ilustracion.alicia.suricata.01.png?fit=1294%2C1246&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/ilustracion.alicia.suricata.01.png?fit=1294%2C1246&ssl=1\",\"width\":1294,\"height\":1246},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/arumel.com\\\/eu\\\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"http:\\\/\\\/arumel.com\\\/eu\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Limitaci\u00f3n en conversi\u00f3n autom\u00e1tica de standby controlfile a primary controlfile\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/arumel.com\\\/#website\",\"url\":\"http:\\\/\\\/arumel.com\\\/\",\"name\":\"Arumel\",\"description\":\"Outro sitio WordPress m\u00e1is\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\\\/\\\/arumel.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"eu\"},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/1cdc5947f4270801792b02ec92332edc\",\"name\":\"Alberto Pereiro\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"eu\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a375a0c812714ad00388e6453d01b2231aa1ebc4e50587c1cf7eeee09e04eb64?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a375a0c812714ad00388e6453d01b2231aa1ebc4e50587c1cf7eeee09e04eb64?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a375a0c812714ad00388e6453d01b2231aa1ebc4e50587c1cf7eeee09e04eb64?s=96&d=mm&r=g\",\"caption\":\"Alberto Pereiro\"},\"url\":\"https:\\\/\\\/arumel.com\\\/eu\\\/author\\\/alberto\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Limitaci\u00f3n en conversi\u00f3n autom\u00e1tica de standby controlfile a primary controlfile - Arumel","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/arumel.com\/eu\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\/","og_locale":"en_US","og_type":"article","og_title":"Limitaci\u00f3n en conversi\u00f3n autom\u00e1tica de standby controlfile a primary controlfile - Arumel","og_description":"Desde la versi\u00f3n 11g, la posibilidad de descargar los backups RMAN en una BD standby f\u00edsica (no aplica en standby l\u00f3gica) es completa, pudiendo hacer copia del controlfile para recuperar cualquier rol Data Guard (primaria o standby). Podemos por lo tanto hacer copias de la BD en una standby sin preocuparnos de c\u00f3mo generar, de [&hellip;]","og_url":"https:\/\/arumel.com\/eu\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\/","og_site_name":"Arumel","article_published_time":"2017-10-01T21:23:27+00:00","og_image":[{"width":1294,"height":1246,"url":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/10\/ilustracion.alicia.suricata.01.png?fit=1294%2C1246&ssl=1","type":"image\/png"}],"author":"Alberto Pereiro","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Alberto Pereiro","Est. reading time":"15 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/arumel.com\/eu\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\/#article","isPartOf":{"@id":"https:\/\/arumel.com\/eu\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\/"},"author":{"name":"Alberto Pereiro","@id":"http:\/\/arumel.com\/#\/schema\/person\/1cdc5947f4270801792b02ec92332edc"},"headline":"Limitaci\u00f3n en conversi\u00f3n autom\u00e1tica de standby controlfile a primary controlfile","datePublished":"2017-10-01T21:23:27+00:00","mainEntityOfPage":{"@id":"https:\/\/arumel.com\/eu\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\/"},"wordCount":1336,"commentCount":0,"image":{"@id":"https:\/\/arumel.com\/eu\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/10\/ilustracion.alicia.suricata.01.png?fit=1294%2C1246&ssl=1","articleSection":["Oracle","portada","slider-post"],"inLanguage":"eu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/arumel.com\/eu\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/arumel.com\/eu\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\/","url":"https:\/\/arumel.com\/eu\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\/","name":"Limitaci\u00f3n en conversi\u00f3n autom\u00e1tica de standby controlfile a primary controlfile - Arumel","isPartOf":{"@id":"http:\/\/arumel.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/arumel.com\/eu\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\/#primaryimage"},"image":{"@id":"https:\/\/arumel.com\/eu\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/10\/ilustracion.alicia.suricata.01.png?fit=1294%2C1246&ssl=1","datePublished":"2017-10-01T21:23:27+00:00","author":{"@id":"http:\/\/arumel.com\/#\/schema\/person\/1cdc5947f4270801792b02ec92332edc"},"breadcrumb":{"@id":"https:\/\/arumel.com\/eu\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\/#breadcrumb"},"inLanguage":"eu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/arumel.com\/eu\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\/"]}]},{"@type":"ImageObject","inLanguage":"eu","@id":"https:\/\/arumel.com\/eu\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\/#primaryimage","url":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/10\/ilustracion.alicia.suricata.01.png?fit=1294%2C1246&ssl=1","contentUrl":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/10\/ilustracion.alicia.suricata.01.png?fit=1294%2C1246&ssl=1","width":1294,"height":1246},{"@type":"BreadcrumbList","@id":"https:\/\/arumel.com\/eu\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"http:\/\/arumel.com\/eu\/"},{"@type":"ListItem","position":2,"name":"Limitaci\u00f3n en conversi\u00f3n autom\u00e1tica de standby controlfile a primary controlfile"}]},{"@type":"WebSite","@id":"http:\/\/arumel.com\/#website","url":"http:\/\/arumel.com\/","name":"Arumel","description":"Outro sitio WordPress m\u00e1is","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/arumel.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"eu"},{"@type":"Person","@id":"http:\/\/arumel.com\/#\/schema\/person\/1cdc5947f4270801792b02ec92332edc","name":"Alberto Pereiro","image":{"@type":"ImageObject","inLanguage":"eu","@id":"https:\/\/secure.gravatar.com\/avatar\/a375a0c812714ad00388e6453d01b2231aa1ebc4e50587c1cf7eeee09e04eb64?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a375a0c812714ad00388e6453d01b2231aa1ebc4e50587c1cf7eeee09e04eb64?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a375a0c812714ad00388e6453d01b2231aa1ebc4e50587c1cf7eeee09e04eb64?s=96&d=mm&r=g","caption":"Alberto Pereiro"},"url":"https:\/\/arumel.com\/eu\/author\/alberto\/"}]}},"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9uvW6-2cM","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":8479,"url":"https:\/\/arumel.com\/es\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\/","url_meta":{"origin":8480,"position":0},"title":"Limitaci\u00f3n en conversi\u00f3n autom\u00e1tica de standby controlfile a primary controlfile","author":"Alberto Pereiro","date":"1 October, 2017","format":false,"excerpt":"","rel":"","context":"In &quot;Oracle&quot;","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/es\/oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/10\/ilustracion.alicia.suricata.01.png?fit=1200%2C1155&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/10\/ilustracion.alicia.suricata.01.png?fit=1200%2C1155&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/10\/ilustracion.alicia.suricata.01.png?fit=1200%2C1155&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/10\/ilustracion.alicia.suricata.01.png?fit=1200%2C1155&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/10\/ilustracion.alicia.suricata.01.png?fit=1200%2C1155&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":8484,"url":"https:\/\/arumel.com\/ca\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\/","url_meta":{"origin":8480,"position":1},"title":"Limitaci\u00f3n en conversi\u00f3n autom\u00e1tica de standby controlfile a primary controlfile","author":"Alberto Pereiro","date":"1 October, 2017","format":false,"excerpt":"","rel":"","context":"In &quot;Oracle&quot;","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/ca\/oracle-ca\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/10\/ilustracion.alicia.suricata.01.png?fit=1200%2C1155&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/10\/ilustracion.alicia.suricata.01.png?fit=1200%2C1155&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/10\/ilustracion.alicia.suricata.01.png?fit=1200%2C1155&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/10\/ilustracion.alicia.suricata.01.png?fit=1200%2C1155&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/10\/ilustracion.alicia.suricata.01.png?fit=1200%2C1155&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":8446,"url":"https:\/\/arumel.com\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\/","url_meta":{"origin":8480,"position":2},"title":"Limitaci\u00f3n en conversi\u00f3n autom\u00e1tica de standby controlfile a primary controlfile","author":"Alberto Pereiro","date":"1 October, 2017","format":false,"excerpt":"","rel":"","context":"In &quot;Oracle&quot;","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/oracle-2\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/10\/ilustracion.alicia.suricata.01.png?fit=1200%2C1155&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/10\/ilustracion.alicia.suricata.01.png?fit=1200%2C1155&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/10\/ilustracion.alicia.suricata.01.png?fit=1200%2C1155&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/10\/ilustracion.alicia.suricata.01.png?fit=1200%2C1155&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/10\/ilustracion.alicia.suricata.01.png?fit=1200%2C1155&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":8486,"url":"https:\/\/arumel.com\/en\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\/","url_meta":{"origin":8480,"position":3},"title":"Limitations with automatic RMAN conversion from standby controlfile to primary controlfile in 11.2.0.4","author":"Alberto Pereiro","date":"1 October, 2017","format":false,"excerpt":"","rel":"","context":"In &quot;Oracle&quot;","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/en\/oracle-en\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/10\/ilustracion.alicia.suricata.01.png?fit=1200%2C1155&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/10\/ilustracion.alicia.suricata.01.png?fit=1200%2C1155&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/10\/ilustracion.alicia.suricata.01.png?fit=1200%2C1155&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/10\/ilustracion.alicia.suricata.01.png?fit=1200%2C1155&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/10\/ilustracion.alicia.suricata.01.png?fit=1200%2C1155&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":7819,"url":"https:\/\/arumel.com\/es\/gdbclone-3-0-2-19-unsuccessful-open-on-filename-containing-newline-at-optgdbclonelibgdbclone_snap-pm-line-1292\/","url_meta":{"origin":8480,"position":4},"title":"gDBClone 3.0.2-19 &#8220;Unsuccessful open on filename containing newline at \/opt\/gDBClone\/lib\/gDBClone_Snap.pm line 1292.&#8221;","author":"sm","date":"8 July, 2017","format":false,"excerpt":"","rel":"","context":"In &quot;Oracle&quot;","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/es\/oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/arumel_xenia.jpeg?fit=635%2C900&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/arumel_xenia.jpeg?fit=635%2C900&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/arumel_xenia.jpeg?fit=635%2C900&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":9244,"url":"https:\/\/arumel.com\/es\/modificar-inconsistencias-en-un-dataguard-con-el-broker-dgmgrl\/","url_meta":{"origin":8480,"position":5},"title":"Modificar inconsistencias en un dataguard con el broker (dgmgrl)","author":"sm","date":"26 September, 2018","format":false,"excerpt":"Modificando inconsistencias en un dataguard con el broker (dgmgrl) \u00a0 En un dataguard ya montado (12.2.0.1) encontramos que los archives se estaban guardando err\u00f3neamente en una ruta de la standby. Despu\u00e9s de comprobar el par\u00e1metro que los estaba dejando all\u00ed, procedimos a su modificaci\u00f3n para que estuviera igual que en\u2026","rel":"","context":"In &quot;Oracle&quot;","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/es\/oracle\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/arumel_xenia.jpeg?fit=635%2C900&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/arumel_xenia.jpeg?fit=635%2C900&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/arumel_xenia.jpeg?fit=635%2C900&ssl=1&resize=525%2C300 1.5x"},"classes":[]}],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/10\/ilustracion.alicia.suricata.01.png?fit=1294%2C1246&ssl=1","_links":{"self":[{"href":"https:\/\/arumel.com\/eu\/wp-json\/wp\/v2\/posts\/8480","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/arumel.com\/eu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/arumel.com\/eu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/arumel.com\/eu\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/arumel.com\/eu\/wp-json\/wp\/v2\/comments?post=8480"}],"version-history":[{"count":3,"href":"https:\/\/arumel.com\/eu\/wp-json\/wp\/v2\/posts\/8480\/revisions"}],"predecessor-version":[{"id":8498,"href":"https:\/\/arumel.com\/eu\/wp-json\/wp\/v2\/posts\/8480\/revisions\/8498"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/arumel.com\/eu\/wp-json\/wp\/v2\/media\/8474"}],"wp:attachment":[{"href":"https:\/\/arumel.com\/eu\/wp-json\/wp\/v2\/media?parent=8480"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/arumel.com\/eu\/wp-json\/wp\/v2\/categories?post=8480"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/arumel.com\/eu\/wp-json\/wp\/v2\/tags?post=8480"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}