{"id":8486,"date":"2017-10-01T23:26:58","date_gmt":"2017-10-01T21:26:58","guid":{"rendered":"http:\/\/arumel.com\/?p=8486"},"modified":"2017-10-01T23:26:58","modified_gmt":"2017-10-01T21:26:58","slug":"limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4","status":"publish","type":"post","link":"https:\/\/arumel.com\/en\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\/","title":{"rendered":"Limitations with automatic RMAN conversion from standby controlfile to primary controlfile in 11.2.0.4"},"content":{"rendered":"<p>11g brought the hability of moving all backup activity to a physical standby database without restrictions, including controlfile copies that are interchangeable between primary and standby databases. This let us backup a standby database covering any primary failure wituout the need of rebuild our controlfile as Oracle will be able to transform it and maintain the original or specified roel we are interested on. As a requisite, we need to configure a RMAN catalog and correctly register our Data Guard configuration on it. This is very important for succesfull backups and specially sucesfull restores. We can find information regarding this role independency for controlfile copies since <a href=\"https:\/\/docs.oracle.com\/cd\/B28359_01\/server.111\/b28294\/rman.htm#BAJDCCGD\">version 11.1 documentation<\/a>. Here we can find that metadata information stored inside the catalog is what enables the database to be able to be conscious of datafiles names and configuration all along the Data Guard, being able to cross restore or backup datafiles and controlfiles.<\/p>\n<p>Days ago, performing in a test environment restoration from a standby database, I found this was not the real behaviour, because the database I restored still was seing its controlfile as standby. After additional tests and search for mor information in My Oracle Support, we found we could be hitting bug 18455956, that arises in a restore environment when no RMAN catalog is used. We were trying to perform our test restoration explicitly without using catalog just to avoid aplying changes in database incarnation configuration when opening the restored database with resetlogs option. These tests where performed to validate a backup strategy based completely in backups being taken from the standby database.<\/p>\n<p>So finally, I performed additional tests in a new single instance test environment in Data Guard configuration, using two servers in cluster configuration with Grid Infrastructure, using shared ACFS storage for both database to be able to access the databases taken at the standby location. Primary database was named\u00a0<strong>alberto<\/strong> and standby database was named <strong>bertodg<\/strong> (names given by Sergio, to whom I want to thank for providing me in a very fast way this environment using his magic with gdbClone tool!). First step was the execution of a <strong>backup database<\/strong> RMAN command connected to <strong>bertosg (standby) <\/strong>generating a backup inside the FRA, created in the same filesystem. By doing so, we primary and standby database share the access to backups and there&#8217;s no need to perform additional copy or recatalog of backup pieces.<\/p>\n<h1><span style=\"color: #000000;\">Primary restore from standby copy with RMAN catalog connection<\/span><\/h1>\n<p>We connect to the <strong>alberto<\/strong> database and we also use a catalog connection. In this test our RMAN script is explicitly restoring the controlfile from the backuppiece in standby&#8217;s FRA. We took a backup of a standby controlfile, but it is restored at the primary location as a current controlfile, fine for a primary database.There&#8217;s no need to tell RMAN anything about this, all is performed automatically.<\/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\/o1_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 Area    4275781632 bytes\r\n\r\nFixed Size                     2260088 bytes\r\nVariable Size               2449474440 bytes\r\nDatabase Buffers            1811939328 bytes\r\nRedo Buffers                  12107776 bytes\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 for all files in the recovery area\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\/o1_mf_1_34_06sfjc3k_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_28\/o1_mf_1_1_dwsnj7rf_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_28\/o1_mf_1_2_dwsnjx2d_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_28\/o1_mf_1_3_dwsnlrhm_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_28\/o1_mf_1_4_dwsnlvhy_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_28\/o1_mf_1_5_dwt92r23_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_28\/o1_mf_1_6_dwt92wjf_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_28\/o1_mf_1_7_dwtrr0tq_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_29\/o1_mf_1_8_dwvggf46_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_29\/o1_mf_1_1_dww55lnk_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_29\/o1_mf_1_2_dww55q9x_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_29\/o1_mf_1_3_dww5rdbj_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_29\/o1_mf_1_4_dww7z6wb_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_29\/o1_mf_1_1_dww7z75j_.arc\r\nFile Name: \/acfs\/desdata\/alberto\/ALBERTO\/archivelog\/2017_09_29\/o1_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\/o1_mf_system_03sfjd9o_.dbf\r\ndestination for restore of datafile 00001: \/acfs\/desdata\/.ACFS\/snaps\/alberto\/ALBERTO\/datafile\/o1_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\/o1_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\/o1_mf_sysaux_04sfjd9o_.dbf\r\ndestination for restore of datafile 00002: \/acfs\/desdata\/.ACFS\/snaps\/alberto\/ALBERTO\/datafile\/o1_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\/o1_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\/o1_mf_undotbs1_05sfjd9o_.dbf\r\ndestination for restore of datafile 00003: \/acfs\/desdata\/.ACFS\/snaps\/alberto\/ALBERTO\/datafile\/o1_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\/o1_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\/o1_mf_users_06sfjd9r_.dbf\r\ndestination for restore of datafile 00004: \/acfs\/desdata\/.ACFS\/snaps\/alberto\/ALBERTO\/datafile\/o1_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\/o1_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\/o1_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\/o1_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\/o1_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\/o1_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\/o1_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>Primary restore from standby copy without RMAN catalog connection<\/h1>\n<p>Let&#8217;s repeat same test, but this time <span style=\"text-decoration: underline;\">without connecting to the RMAN catalog<\/span>. Restore and recover database works fine, but <strong><span style=\"text-decoration: underline;\">it&#8217;s not possible to open the database<\/span><\/strong> because controlfile was not converted during the process and is still a standby controlfie.<\/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\/o1_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 Area    4275781632 bytes\r\n\r\nFixed Size                     2260088 bytes\r\nVariable Size               2449474440 bytes\r\nDatabase Buffers            1811939328 bytes\r\nRedo Buffers                  12107776 bytes\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\/o1_mf_system_03sfjd9o_.dbf\r\nskipping datafile 2; already restored to file \/acfs\/desdata\/.ACFS\/snaps\/bertodg\/BERTODG\/datafile\/o1_mf_sysaux_04sfjd9o_.dbf\r\nskipping datafile 3; already restored to file \/acfs\/desdata\/.ACFS\/snaps\/bertodg\/BERTODG\/datafile\/o1_mf_undotbs1_05sfjd9o_.dbf\r\nskipping datafile 4; already restored to file \/acfs\/desdata\/.ACFS\/snaps\/bertodg\/BERTODG\/datafile\/o1_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>We can check that we have restores a STANDBY CONTROLFILE, this is not what we are looking for as we are not trying to change the role of our primary database.<\/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><span style=\"color: #000000;\">Bug 18455956<\/span><\/h1>\n<p>It could be OK that Oracle do not convert the standby controlfile when we are not connected to the catalog, just because it has no way to tell the role of the database as this information is inside the catalog. In fact, RESTORE CONTROLFILE command can be manually performed,\u00a0<a href=\"https:\/\/docs.oracle.com\/cd\/B28359_01\/backup.111\/b28273\/rcmsynta037.htm#RCMRF149\">since 11gR1<\/a>, in 3 different ways:<\/p>\n<ul>\n<li><span style=\"color: #000000;\"><strong>RESTORE CONTROLFILE<\/strong><\/span>. Controlfile is restored into the database, and the role is determined by means of gathering this information form the recovery catalog. The role will remain the same the database had before starting restoration.<\/li>\n<li><span style=\"color: #000000;\"><strong>RESTORE PRIMARY CONTROLFILE<\/strong><\/span>. We force the controlfile to be transformed into a primary controlfile without caring if it was originally a primary or standby one.<\/li>\n<li><span style=\"color: #000000;\"><strong>RESTORE STANDBY CONTROLFILE<\/strong><\/span>. Controlfile will be converted into a standby controlfile.<\/li>\n<\/ul>\n<p>So we have the choice of automatically restore a controlfile depending on the role of the database we are connected to if we use a recovery catalog, and alsa can specify the role we want this restored controlfile to be converted to if we just want to use a backup to create a new primary or standby database independently of what kind of controlfile we have. Taking a look at MOS note <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>, we see that as consequence of bug <span id=\"kmPgTpl:r1:ot71\" class=\"kmContent\">7553431<\/span>, a new bug arises after applying the patch, <span id=\"kmPgTpl:r1:ot71\" class=\"kmContent\">18455956<\/span>. <span style=\"text-decoration: underline;\">Without path 18455956 applied, RESTORE PRIMARY CONTROLFILE command won&#8217;t convert a standby controlfile if we are not using recovery catalog when restoring from a standby controlfile<\/span>. Using a recovery catalog is just the workaround for avoinding this issue.<br \/>\n<\/span><\/p>\n<p>In our test case, we verify patch 18455956 is not applied in our 11.2.0.4 April&#8217;s 2017 PSU level.<\/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>We check we are hitting this bug by performing another test using RESTORE PRIMARY CONTROLFILE:<\/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\/o1_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 Area    4275781632 bytes\r\n\r\nFixed Size                     2260088 bytes\r\nVariable Size               2449474440 bytes\r\nDatabase Buffers            1811939328 bytes\r\nRedo Buffers                  12107776 bytes\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\/o1_mf_system_03sfjd9o_.dbf\r\nskipping datafile 2; already restored to file \/acfs\/desdata\/.ACFS\/snaps\/bertodg\/BERTODG\/datafile\/o1_mf_sysaux_04sfjd9o_.dbf\r\nskipping datafile 3; already restored to file \/acfs\/desdata\/.ACFS\/snaps\/bertodg\/BERTODG\/datafile\/o1_mf_undotbs1_05sfjd9o_.dbf\r\nskipping datafile 4; already restored to file \/acfs\/desdata\/.ACFS\/snaps\/bertodg\/BERTODG\/datafile\/o1_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\r\n<\/pre>\n<h1>Alternatives when we are not using recovery catalog<\/h1>\n<p>Now we know the problem, we can use different aproaches as a workaround if we want to perfom a recovery without connecting to RMAN catalog.<\/p>\n<p>It can be interesting taking in care we can just open the database in this state in read only mode. This enables checking the data if that is just what we need.<\/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>We can recreate the controlfile from the satdnby (backup controlfile to trace) and adapt it to recreate the primary version. Another solution is to open the restored standby database as a primary database, by forcing a failover. This is what we test in the next test. Before that, we clear the standby logs and disable flashback database to avoid errors when trying to open the database:<\/p>\n<pre class=\"theme:terminal lang:default decode:true\">SQL&gt; select * from v$logfile;\r\n\r\n    GROUP# STATUS  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\/o1_mf_3_dwsnjzp0_.log\t\t    NO\r\n\t 2\t   ONLINE  \/acfs\/desdata\/bertodg\/BERTODG\/onlinelog\/o1_mf_2_dwsnjzkj_.log\t\t    NO\r\n\t 1\t   ONLINE  \/acfs\/desdata\/bertodg\/BERTODG\/onlinelog\/o1_mf_1_dwsnjzdr_.log\t\t    NO\r\n\t 4\t   STANDBY \/acfs\/desdata\/bertodg\/BERTODG\/onlinelog\/o1_mf_4_dww5rdg9_.log\t\t    NO\r\n\t 5\t   STANDBY \/acfs\/desdata\/bertodg\/BERTODG\/onlinelog\/o1_mf_5_dww5rdgy_.log\t\t    NO\r\n\t 6\t   STANDBY \/acfs\/desdata\/bertodg\/BERTODG\/onlinelog\/o1_mf_6_dww5rdg2_.log\t\t    NO\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><span style=\"color: #000000;\">Summary<\/span><\/h1>\n<p>We must use a recovery catlaog when performing backups in a Data Guard configuration. Anyway, there are specific scenarios where a connection to the catalog is not desirable, just to avoid any disturb in the real state of production backups. If this is our case, we must be conscius, if we are using 11.2.0.4 (this issue does not affect 11.2.0.3 or earlier versions) of the existence of bug 18455856 that will make us choose between applying the software patch, or planning the restore operations with this handicup in mind.<\/p>\n<h1>Credits<\/h1>\n<p>Ilustraci\u00f3n: Alicia Constela<\/p>\n","protected":false},"excerpt":{"rendered":"<p>11g brought the hability of moving all backup activity to a physical standby database without restrictions, including controlfile copies that are interchangeable between primary and standby databases. This let us backup a standby database covering any primary failure wituout the need of rebuild our controlfile as Oracle will be able to transform it and maintain [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":8476,"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":[76,26,49],"tags":[],"class_list":["post-8486","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle-en","category-portada-en","category-slider-post-en"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Limitations with automatic RMAN conversion from standby controlfile to primary controlfile in 11.2.0.4 - 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\/en\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Limitations with automatic RMAN conversion from standby controlfile to primary controlfile in 11.2.0.4 - Arumel\" \/>\n<meta property=\"og:description\" content=\"11g brought the hability of moving all backup activity to a physical standby database without restrictions, including controlfile copies that are interchangeable between primary and standby databases. This let us backup a standby database covering any primary failure wituout the need of rebuild our controlfile as Oracle will be able to transform it and maintain [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/arumel.com\/en\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\/\" \/>\n<meta property=\"og:site_name\" content=\"Arumel\" \/>\n<meta property=\"article:published_time\" content=\"2017-10-01T21:26:58+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=\"14 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/arumel.com\\\/en\\\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/en\\\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\\\/\"},\"author\":{\"name\":\"Alberto Pereiro\",\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/1cdc5947f4270801792b02ec92332edc\"},\"headline\":\"Limitations with automatic RMAN conversion from standby controlfile to primary controlfile in 11.2.0.4\",\"datePublished\":\"2017-10-01T21:26:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/en\\\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\\\/\"},\"wordCount\":1089,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/en\\\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\\\/#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\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/arumel.com\\\/en\\\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/arumel.com\\\/en\\\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\\\/\",\"url\":\"https:\\\/\\\/arumel.com\\\/en\\\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\\\/\",\"name\":\"Limitations with automatic RMAN conversion from standby controlfile to primary controlfile in 11.2.0.4 - Arumel\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/en\\\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/en\\\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\\\/#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:26:58+00:00\",\"author\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/1cdc5947f4270801792b02ec92332edc\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/arumel.com\\\/en\\\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/arumel.com\\\/en\\\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/arumel.com\\\/en\\\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\\\/#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\\\/en\\\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"http:\\\/\\\/arumel.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Limitations with automatic RMAN conversion from standby controlfile to primary controlfile in 11.2.0.4\"}]},{\"@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\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/1cdc5947f4270801792b02ec92332edc\",\"name\":\"Alberto Pereiro\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@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\\\/en\\\/author\\\/alberto\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Limitations with automatic RMAN conversion from standby controlfile to primary controlfile in 11.2.0.4 - 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\/en\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\/","og_locale":"en_US","og_type":"article","og_title":"Limitations with automatic RMAN conversion from standby controlfile to primary controlfile in 11.2.0.4 - Arumel","og_description":"11g brought the hability of moving all backup activity to a physical standby database without restrictions, including controlfile copies that are interchangeable between primary and standby databases. This let us backup a standby database covering any primary failure wituout the need of rebuild our controlfile as Oracle will be able to transform it and maintain [&hellip;]","og_url":"https:\/\/arumel.com\/en\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\/","og_site_name":"Arumel","article_published_time":"2017-10-01T21:26:58+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":"14 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/arumel.com\/en\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\/#article","isPartOf":{"@id":"https:\/\/arumel.com\/en\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\/"},"author":{"name":"Alberto Pereiro","@id":"http:\/\/arumel.com\/#\/schema\/person\/1cdc5947f4270801792b02ec92332edc"},"headline":"Limitations with automatic RMAN conversion from standby controlfile to primary controlfile in 11.2.0.4","datePublished":"2017-10-01T21:26:58+00:00","mainEntityOfPage":{"@id":"https:\/\/arumel.com\/en\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\/"},"wordCount":1089,"commentCount":0,"image":{"@id":"https:\/\/arumel.com\/en\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\/#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":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/arumel.com\/en\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/arumel.com\/en\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\/","url":"https:\/\/arumel.com\/en\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\/","name":"Limitations with automatic RMAN conversion from standby controlfile to primary controlfile in 11.2.0.4 - Arumel","isPartOf":{"@id":"http:\/\/arumel.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/arumel.com\/en\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\/#primaryimage"},"image":{"@id":"https:\/\/arumel.com\/en\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\/#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:26:58+00:00","author":{"@id":"http:\/\/arumel.com\/#\/schema\/person\/1cdc5947f4270801792b02ec92332edc"},"breadcrumb":{"@id":"https:\/\/arumel.com\/en\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/arumel.com\/en\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/arumel.com\/en\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\/#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\/en\/limitations-with-automatic-rman-conversion-from-standby-controlfile-to-primary-controlfile-in-11-2-0-4\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"http:\/\/arumel.com\/en\/"},{"@type":"ListItem","position":2,"name":"Limitations with automatic RMAN conversion from standby controlfile to primary controlfile in 11.2.0.4"}]},{"@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":"en-US"},{"@type":"Person","@id":"http:\/\/arumel.com\/#\/schema\/person\/1cdc5947f4270801792b02ec92332edc","name":"Alberto Pereiro","image":{"@type":"ImageObject","inLanguage":"en-US","@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\/en\/author\/alberto\/"}]}},"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9uvW6-2cS","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":8446,"url":"https:\/\/arumel.com\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\/","url_meta":{"origin":8486,"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\/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":8479,"url":"https:\/\/arumel.com\/es\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\/","url_meta":{"origin":8486,"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\/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":8480,"url":"https:\/\/arumel.com\/eu\/limitacion-conversion-automatica-de-standby-controlfile-primary-controlfile\/","url_meta":{"origin":8486,"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\/eu\/oracle-eu\/"},"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":8486,"position":3},"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":7865,"url":"https:\/\/arumel.com\/en\/gdbclone-3-0-2-19-unsuccessful-open-on-filename-containing-newline-at-optgdbclonelibgdbclone_snap-pm-line-1292\/","url_meta":{"origin":8486,"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":"gDBClone \"gDBClone_Snap.pm line 1292\" If you are using gDBClone to do snapshots from your databases on acfs, you'll have noticed that in the last version (3.0.2-19) published 2017-06-30, when you do a snap from your databases, previously cloned, it shows you an error just in this moment: INFO: 2017-07-07 18:09:08:\u2026","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\/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":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":8486,"position":5},"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":[]}],"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\/en\/wp-json\/wp\/v2\/posts\/8486","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/comments?post=8486"}],"version-history":[{"count":5,"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/posts\/8486\/revisions"}],"predecessor-version":[{"id":8499,"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/posts\/8486\/revisions\/8499"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/media\/8476"}],"wp:attachment":[{"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/media?parent=8486"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/categories?post=8486"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/arumel.com\/en\/wp-json\/wp\/v2\/tags?post=8486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}