{"id":1219,"date":"2015-01-09T16:23:23","date_gmt":"2015-01-09T19:23:23","guid":{"rendered":"http:\/\/www.dbarj.com.br\/?p=1219"},"modified":"2019-10-23T17:01:21","modified_gmt":"2019-10-23T20:01:21","slug":"resume-oracle-duplicate-database-failed-recovery-datafiles","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/en\/2015\/01\/resume-oracle-duplicate-database-failed-recovery-datafiles\/","title":{"rendered":"Resume an Oracle DUPLICATE database that failed on RECOVERY of datafiles"},"content":{"rendered":"<p>A time ago, the problem that I used to face was the failure of the recovery part of the duplicate\u00a0script for any problems (like forgetting to set the db_recovery_area_dest_size big enough to hold the archives that will come from duplicate) and I ended up having to start the DUPLICATE command all over again. The recovery part would bring only some GBs,\u00a0less than 1% compared to the size of the full backup restore part (about <strong>500 GBs<\/strong>). So, running it again was a big waste of time.<\/p>\n<p>To resume the <span style=\"color: #800000;\"><strong>DUPLICATE<\/strong><\/span> command, I started to dissect it. Here I will show an example of how to resume a tape backup duplicate that failed in the recovery part.<\/p>\n<p><span style=\"color: #0000ff;\">PS: Before starting, as stated in the comments, it&#8217;s important to say that <strong><span style=\"color: #000000;\">DUPLICATE<\/span><\/strong> is most of the times a <strong><span style=\"color: #000000;\">RESUMABLE<\/span><\/strong>\u00a0operation, as soon as you trigger it again <span style=\"color: #000000;\"><strong>WITH SAME SINTAX<\/strong> <\/span>and with your destination database back in <span style=\"color: #000000;\"><strong>NOMOUNT<\/strong><\/span>. It will skip on most cases the already retrieved datafiles and archivelogs. This article is more intended to understand its internals in very particular cases or when you need a manual approach. Just consider it if you already tried running the same command again and it downloaded everything. =]<\/span><\/p>\n<p>Scenario:<\/p>\n<ul>\n<li>Source DB: <strong>DBPROD<\/strong><\/li>\n<li>Destination DB: <strong>DBTEST<\/strong><\/li>\n<\/ul>\n<p>I create my own pfile for\u00a0<strong>DBTEST<\/strong>, set up the parameters and created the directories.<\/p>\n<p>After starting the database in nomount, I issued the command:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">-- My DUPLICATE command\r\n\r\nconnect target mdoxdba\/\"xxx\"@dbprod\r\nconnect auxiliary mdoxdba\/\"xxx\"@dbtest\r\nconnect catalog rman\/\"xxx\"@rmanbkp\r\n\r\nRUN\r\n{\r\n\tSET UNTIL TIME \"to_date('2015-01-06 00:00:00','yyyy-mm-dd hh24:mi:ss')\";\r\n\tALLOCATE AUXILIARY CHANNEL T1 TYPE 'sbt_tape';\r\n\tDUPLICATE TARGET DATABASE TO 'dbtest';\r\n}<\/pre>\n<p>Note that my until time is <strong>06\/Jan<\/strong>. My latest full was on <strong>03\/Jan<\/strong>. So I have 3 days of archivelogs to be applied.<\/p>\n<p>Then, when the script started the recovery phase, I aborted it (CTRL+C) to simulate a failure:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">Recovery Manager: Release 11.1.0.7.0 - Production on Fri Jan 9 12:15:49 2015\r\n\r\nCopyright (c) 1982, 2007, Oracle.  All rights reserved.\r\n\r\nRMAN&gt;\r\nconnected to target database: DBPROD (DBID=2452006932)\r\n\r\nRMAN&gt;\r\nconnected to auxiliary database: DBTEST (not mounted)\r\n\r\nRMAN&gt;\r\nconnected to recovery catalog database\r\n\r\nRMAN&gt; 2&gt; 3&gt; 4&gt; 5&gt; 6&gt; 7&gt;\r\nexecuting command: SET until clause\r\n\r\nallocated channel: t1\r\nchannel t1: SID=554 device type=SBT_TAPE\r\nchannel t1: Data Protector A.08.10\/205\r\n\r\nStarting Duplicate Db at 09-JAN-15\r\n\r\ncontents of Memory Script:\r\n{\r\n   set until scn  13169104914343;\r\n   set newname for datafile  1 to\r\n \"\/oravl02\/oradata\/dbtest\/system01.dbf\";\r\n   set newname for datafile  2 to\r\n \"\/oravl02\/oradata\/dbtest\/sysaux01.dbf\";\r\n   set newname for datafile  3 to\r\n \"\/oravl02\/oradata\/dbtest\/undotbs01.dbf\";\r\n   set newname for datafile  4 to\r\n \"\/oravl02\/oradata\/dbtest\/users01.dbf\";\r\n   set newname for datafile  5 to\r\n \"\/oravl02\/oradata\/dbtest\/usr01.dbf\";\r\n   set newname for datafile  6 to\r\n \"\/oravl02\/oradata\/dbtest\/usr02.dbf\";\r\n   restore\r\n   clone database\r\n   ;\r\n}\r\nexecuting Memory Script\r\n\r\nexecuting command: SET until clause\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nStarting restore at 09-JAN-15\r\n\r\nchannel t1: starting datafile backup set restore\r\nchannel t1: specifying datafile(s) to restore from backup set\r\nchannel t1: restoring datafile 00001 to \/oravl02\/oradata\/dbtest\/system01.dbf\r\nchannel t1: restoring datafile 00002 to \/oravl02\/oradata\/dbtest\/sysaux01.dbf\r\nchannel t1: restoring datafile 00003 to \/oravl02\/oradata\/dbtest\/undotbs01.dbf\r\nchannel t1: restoring datafile 00004 to \/oravl02\/oradata\/dbtest\/users01.dbf\r\nchannel t1: restoring datafile 00005 to \/oravl02\/oradata\/dbtest\/usr01.dbf\r\nchannel t1: restoring datafile 00006 to \/oravl02\/oradata\/dbtest\/usr02.dbf\r\nchannel t1: reading from backup piece 1hprsdqk_1_1\r\nchannel t1: piece handle=1hprsdqk_1_1 tag=FULL_DB_INCR_ONLINE\r\nchannel t1: restored backup piece 1\r\nchannel t1: restore complete, elapsed time: 00:09:45\r\nFinished restore at 09-JAN-15\r\nsql statement: CREATE CONTROLFILE REUSE SET DATABASE \"DBTEST\" RESETLOGS ARCHIVELOG\r\n  MAXLOGFILES     16\r\n  MAXLOGMEMBERS      3\r\n  MAXDATAFILES      100\r\n  MAXINSTANCES     8\r\n  MAXLOGHISTORY      292\r\n LOGFILE\r\n  GROUP  1 ( '\/oravl02\/oradata\/dbtest\/redo01.log' ) SIZE 50 M  REUSE,\r\n  GROUP  2 ( '\/oravl02\/oradata\/dbtest\/redo02.log' ) SIZE 50 M  REUSE,\r\n  GROUP  3 ( '\/oravl02\/oradata\/dbtest\/redo03.log' ) SIZE 50 M  REUSE\r\n DATAFILE\r\n  '\/oravl02\/oradata\/dbtest\/system01.dbf'\r\n CHARACTER SET AL32UTF8\r\n\r\n\r\ncontents of Memory Script:\r\n{\r\n   switch clone datafile all;\r\n}\r\nexecuting Memory Script\r\n\r\ndatafile 2 switched to datafile copy\r\ninput datafile copy RECID=1 STAMP=868537545 file name=\/oravl02\/oradata\/dbtest\/sysaux01.dbf\r\ndatafile 3 switched to datafile copy\r\ninput datafile copy RECID=2 STAMP=868537545 file name=\/oravl02\/oradata\/dbtest\/undotbs01.dbf\r\ndatafile 4 switched to datafile copy\r\ninput datafile copy RECID=3 STAMP=868537545 file name=\/oravl02\/oradata\/dbtest\/users01.dbf\r\ndatafile 5 switched to datafile copy\r\ninput datafile copy RECID=4 STAMP=868537545 file name=\/oravl02\/oradata\/dbtest\/usr01.dbf\r\ndatafile 6 switched to datafile copy\r\ninput datafile copy RECID=5 STAMP=868537545 file name=\/oravl02\/oradata\/dbtest\/usr02.dbf\r\n\r\ncontents of Memory Script:\r\n{\r\n   set until time  \"to_date('2015-01-06 00:00:00','yyyy-mm-dd hh24:mi:ss')\";\r\n   recover\r\n   clone database\r\n    delete archivelog\r\n   ;\r\n}\r\nexecuting Memory Script\r\n\r\nexecuting command: SET until clause\r\n\r\nStarting recover at 09-JAN-15\r\n\r\nstarting media recovery\r\n\r\nchannel t1: starting archived log restore to default destination\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7304\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7305\r\nchannel t1: reading from backup piece 1jprsef0_1_1\r\n\r\nuser interrupt received\r\nOracle Error:\r\nORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below\r\nORA-01194: file 1 needs more recovery to be consistent\r\nORA-01110: data file 1: '\/oravl02\/oradata\/dbtest\/system01.dbf'\r\n\r\nreleased channel: t1\r\nRMAN-00571: ===========================================================\r\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\r\nRMAN-00571: ===========================================================\r\nRMAN-03002: failure of Duplicate Db command at 01\/09\/2015 12:26:47\r\nRMAN-03015: error occurred in stored script Memory Script\r\nRMAN-03099: job cancelled at user request\r\n\r\nRMAN&gt;<\/pre>\n<p>Here we can see that the RESTORE completed <strong>successfully<\/strong>. After that, the DUPLICATE created the controlfile with only the SYSTEM datafile. It then\u00a0performed\u00a0a &#8220;<strong>switch datafile all<\/strong>&#8221; to add the rest.<\/p>\n<p>When it started the RECOVER step, I aborted it.<\/p>\n<p>So, how can\u00a0we resume that?<\/p>\n<p>First, we need to finish the recovery. Let&#8217;s open again the <strong>rman<\/strong> connecting to auxiliary, target and catalog servers (if present) and then rerun the recovery step.<\/p>\n<p>Note below that I allocate the auxiliary channel again and the\u00a0<strong>DBTEST<\/strong> must remains in MOUNT state.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">RMAN&gt; run\r\n2&gt; {\r\n3&gt;    allocate auxiliary channel t1 type 'SBT_TAPE';\r\n5&gt;    set until time  \"to_date('2015-01-06 00:00:00','yyyy-mm-dd hh24:mi:ss')\";\r\n6&gt;    recover\r\n7&gt;    clone database\r\n8&gt;     delete archivelog\r\n9&gt;    ;\r\n10&gt; }\r\n\r\nallocated channel: t1\r\nchannel t1: SID=552 device type=SBT_TAPE\r\nchannel t1: Data Protector A.08.10\/205\r\n\r\nexecuting command: SET until clause\r\n\r\nStarting recover at 09-JAN-15\r\nadded tempfile \/oravl04\/oradata\/dbprod\/dbprod\/temp01.dbf to tablespace TEMPORARY in control file\r\n\r\nstarting media recovery\r\n\r\nchannel t1: starting archived log restore to default destination\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7304\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7305\r\nchannel t1: reading from backup piece 1jprsef0_1_1\r\nchannel t1: piece handle=1jprsef0_1_1 tag=FULL_ARCHIVELOG_ONLINE\r\nchannel t1: restored backup piece 1\r\nchannel t1: restore complete, elapsed time: 00:03:55\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7304_bbzsz4nh_.arc thread=1 sequence=7304\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7304_bbzsz4nh_.arc RECID=2 STAMP=868538309\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7305_bbzsz4o6_.arc thread=1 sequence=7305\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7305_bbzsz4o6_.arc RECID=1 STAMP=868538308\r\nchannel t1: starting archived log restore to default destination\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7306\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7307\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7308\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7309\r\nchannel t1: reading from backup piece 1lprto0p_1_1\r\nchannel t1: piece handle=1lprto0p_1_1 tag=ARCHIVE_ONLINE\r\nchannel t1: restored backup piece 1\r\nchannel t1: restore complete, elapsed time: 00:00:55\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7306_bbzt0nlk_.arc thread=1 sequence=7306\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7306_bbzt0nlk_.arc RECID=4 STAMP=868538362\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7307_bbzt0nns_.arc thread=1 sequence=7307\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7307_bbzt0nns_.arc RECID=6 STAMP=868538362\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7308_bbzt0nn1_.arc thread=1 sequence=7308\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7308_bbzt0nn1_.arc RECID=5 STAMP=868538362\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7309_bbzt0np3_.arc thread=1 sequence=7309\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7309_bbzt0np3_.arc RECID=3 STAMP=868538362\r\nchannel t1: starting archived log restore to default destination\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7310\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7311\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7312\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7313\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7314\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7315\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7316\r\nchannel t1: restoring archived log\r\narchived log thread=1 sequence=7317\r\nchannel t1: reading from backup piece 1mps0cd1_1_1\r\nchannel t1: piece handle=1mps0cd1_1_1 tag=ARCHIVE_ONLINE\r\nchannel t1: restored backup piece 1\r\nchannel t1: restore complete, elapsed time: 00:00:55\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7310_bbzt2v2x_.arc thread=1 sequence=7310\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7310_bbzt2v2x_.arc RECID=9 STAMP=868538434\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7311_bbzt2v3d_.arc thread=1 sequence=7311\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7311_bbzt2v3d_.arc RECID=10 STAMP=868538434\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7312_bbzt2v22_.arc thread=1 sequence=7312\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7312_bbzt2v22_.arc RECID=8 STAMP=868538434\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7313_bbzt2v3p_.arc thread=1 sequence=7313\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7313_bbzt2v3p_.arc RECID=11 STAMP=868538434\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7314_bbzt2v42_.arc thread=1 sequence=7314\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7314_bbzt2v42_.arc RECID=12 STAMP=868538434\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7315_bbzt2v4c_.arc thread=1 sequence=7315\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7315_bbzt2v4c_.arc RECID=13 STAMP=868538434\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7316_bbzt2v4t_.arc thread=1 sequence=7316\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7316_bbzt2v4t_.arc RECID=14 STAMP=868538434\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7317_bbzt2v55_.arc thread=1 sequence=7317\r\nchannel clone_default: deleting archived log(s)\r\narchived log file name=\/oravl02\/oradata\/dbtest\/fast_recovery_area\/DBTEST\/archivelog\/2015_01_09\/o1_mf_1_7317_bbzt2v55_.arc RECID=7 STAMP=868538429\r\nmedia recovery complete, elapsed time: 00:00:21\r\nFinished recover at 09-JAN-15\r\nreleased channel: t1\r\n\r\nRMAN&gt;<\/pre>\n<p>Perfect, the recovery worked. From here, we have 2 ways to finish our task: The easy and obvious way OR\u00a0the DUPLICATE way (dissecting it). I will show you both:<\/p>\n<h3><span style=\"color: #800000;\">1. The easy way:<\/span><\/h3>\n<p>Finally, let&#8217;s open the database with resetlogs:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">SQL&gt; alter database open resetlogs;\r\n\r\nDatabase altered.\r\n\r\nSQL&gt;<\/pre>\n<p>Ok. Your database is ready now.<\/p>\n<h3><span style=\"color: #800000;\">2. The DUPLICATE dissected\u00a0way:<\/span><\/h3>\n<p>The DUPLICATE command do a lot of extra steps, probably because it can receive a lot of combinations of conditions,\u00a0such as\u00a0skipping some tablespaces. It is a more generic implementation mode to handle a wider range of cases:<\/p>\n<p>To simulate, first let&#8217;s put the database in NOMOUNT\u00a0state again to recreate the controlfile\u00a0(note that I did it still using the RMAN session):<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">RMAN&gt; RUN\r\n2&gt; {\r\n3&gt;    shutdown clone immediate;\r\n4&gt;    startup clone nomount ;\r\n5&gt; }\r\n\r\ndatabase dismounted\r\nOracle instance shut down\r\n\r\nconnected to auxiliary database (not started)\r\nOracle instance started\r\n\r\nTotal System Global Area    7081771008 bytes\r\n\r\nFixed Size                     2147080 bytes\r\nVariable Size               3283610872 bytes\r\nDatabase Buffers            3791650816 bytes\r\nRedo Buffers                   4362240 bytes\r\n\r\nRMAN&gt;<\/pre>\n<p>Next, instead of recreating the controlfile with all datafiles, oracle will only create it with the SYSTEM datafile. Let&#8217;s do that. (It is the same command that executed in the beginning):<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">SQL&gt; CREATE CONTROLFILE REUSE SET DATABASE \"DBTEST\" RESETLOGS ARCHIVELOG\r\n  2    MAXLOGFILES     16\r\n  3    MAXLOGMEMBERS      3\r\n  4    MAXDATAFILES      100\r\n  5    MAXINSTANCES     8\r\n  6    MAXLOGHISTORY      292\r\n  7   LOGFILE\r\n  8    GROUP  1 ( '\/oravl02\/oradata\/dbtest\/redo01.log' ) SIZE 50 M  REUSE,\r\n  9    GROUP  2 ( '\/oravl02\/oradata\/dbtest\/redo02.log' ) SIZE 50 M  REUSE,\r\n 10    GROUP  3 ( '\/oravl02\/oradata\/dbtest\/redo03.log' ) SIZE 50 M  REUSE\r\n 11   DATAFILE\r\n 12    '\/oravl02\/oradata\/dbtest\/system01.dbf'\r\n 13   CHARACTER SET AL32UTF8;\r\n\r\nControl file created.\r\n\r\nSQL&gt;<\/pre>\n<p>Now, let&#8217;s add to the controlfile the others datafiles. Connect again RMAN\u00a0to the auxiliary and target DBs:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">RMAN&gt; run\r\n2&gt; {\r\n3&gt;    set newname for tempfile  1 to \"\/oravl02\/oradata\/dbtest\/temp01.dbf\";\r\n4&gt;    switch clone tempfile all;\r\n5&gt;    set newname for datafile 1 to \"\/oravl02\/oradata\/dbtest\/system01.dbf\";\r\n6&gt;    set newname for datafile 2 to \"\/oravl02\/oradata\/dbtest\/sysaux01.dbf\";\r\n7&gt;    set newname for datafile 3 to \"\/oravl02\/oradata\/dbtest\/undotbs01.dbf\";\r\n8&gt;    set newname for datafile 4 to \"\/oravl02\/oradata\/dbtest\/users01.dbf\";\r\n9&gt;    set newname for datafile 5 to \"\/oravl02\/oradata\/dbtest\/usr01.dbf\";\r\n10&gt;    set newname for datafile 6 to \"\/oravl02\/oradata\/dbtest\/usr02.dbf\";\r\n11&gt;    catalog clone datafilecopy \"\/oravl02\/oradata\/dbtest\/sysaux01.dbf\";\r\n12&gt;    catalog clone datafilecopy \"\/oravl02\/oradata\/dbtest\/undotbs01.dbf\";\r\n13&gt;    catalog clone datafilecopy \"\/oravl02\/oradata\/dbtest\/users01.dbf\";\r\n14&gt;    catalog clone datafilecopy \"\/oravl02\/oradata\/dbtest\/usr01.dbf\";\r\n15&gt;    catalog clone datafilecopy \"\/oravl02\/oradata\/dbtest\/usr02.dbf\";\r\n16&gt;    switch clone datafile all;\r\n17&gt; }\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nrenamed tempfile 1 to \/oravl02\/oradata\/dbtest\/temp01.dbf in control file\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nexecuting command: SET NEWNAME\r\n\r\ncataloged datafile copy\r\ndatafile copy file name=\/oravl02\/oradata\/dbtest\/sysaux01.dbf RECID=1 STAMP=868554741\r\n\r\ncataloged datafile copy\r\ndatafile copy file name=\/oravl02\/oradata\/dbtest\/undotbs01.dbf RECID=2 STAMP=868554741\r\n\r\ncataloged datafile copy\r\ndatafile copy file name=\/oravl02\/oradata\/dbtest\/users01.dbf RECID=3 STAMP=868554741\r\n\r\ncataloged datafile copy\r\ndatafile copy file name=\/oravl02\/oradata\/dbtest\/usr01.dbf RECID=4 STAMP=868554742\r\n\r\ncataloged datafile copy\r\ndatafile copy file name=\/oravl02\/oradata\/dbtest\/usr02.dbf RECID=5 STAMP=868554742\r\n\r\ndatafile 2 switched to datafile copy\r\ninput datafile copy RECID=1 STAMP=868554741 file name=\/oravl02\/oradata\/dbtest\/sysaux01.dbf\r\ndatafile 3 switched to datafile copy\r\ninput datafile copy RECID=2 STAMP=868554741 file name=\/oravl02\/oradata\/dbtest\/undotbs01.dbf\r\ndatafile 4 switched to datafile copy\r\ninput datafile copy RECID=3 STAMP=868554741 file name=\/oravl02\/oradata\/dbtest\/users01.dbf\r\ndatafile 5 switched to datafile copy\r\ninput datafile copy RECID=4 STAMP=868554742 file name=\/oravl02\/oradata\/dbtest\/usr01.dbf\r\ndatafile 6 switched to datafile copy\r\ninput datafile copy RECID=5 STAMP=868554742 file name=\/oravl02\/oradata\/dbtest\/usr02.dbf\r\n\r\nRMAN&gt;<\/pre>\n<p><em><strong><span style=\"color: #3366ff;\">P.S: Although not present in the trace of the DUPLICATE, here I&#8217;ve added the &#8220;set newname&#8221; clause for all datafiles. Otherwise, it would fail.\u00a0In fact, when is RMAN that runs, it doesn&#8217;t need to execute those &#8220;sets&#8221; in the final block because this was already done in the beggining.\u00a0As the session is the same, it does not need to rerun them.<\/span><\/strong><\/em><\/p>\n<p>So, finally, open your DB with resetlogs:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"oracledb\">RMAN&gt; run\r\n2&gt; {\r\n3&gt;    Alter clone database open resetlogs;\r\n4&gt; }\r\n\r\ndatabase opened\r\n\r\nRMAN&gt;<\/pre>\n<p>And that&#8217;s it! Using those methods, there is no need to restore all the datafiles again.<\/p>\n<p>Some useful sites that helped me out and where you can find more\u00a0information:<\/p>\n<ul>\n<li><a href=\"http:\/\/www.pythian.com\/blog\/rman-duplicate-in-details\" target=\"_blank\" rel=\"noopener noreferrer\">http:\/\/www.pythian.com\/blog\/rman-duplicate-in-details<\/a><\/li>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?id=360962.1\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?id=360962.1<\/a><\/li>\n<li><a href=\"https:\/\/oraclefunda.wordpress.com\/2009\/02\/15\/33\/\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/oraclefunda.wordpress.com\/2009\/02\/15\/33\/<\/a><\/li>\n<\/ul>\n<b>Have you enjoyed? Please leave a comment or give a \ud83d\udc4d!<\/b>\n<div class='watch-action'><div class='watch-position align-left'><div class='action-like'><a class='lbg-style2 like-1219 jlk' href='javascript:void(0)' data-task='like' data-post_id='1219' data-nonce='de4404f630' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.dbarj.com.br\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-1219 lc'>+14<\/span><\/a><\/div><\/div> <div class='status-1219 status align-left'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>A time ago, the problem that I used to face was the failure of the recovery part of the duplicate\u00a0script for any problems (like forgetting to set the db_recovery_area_dest_size big enough to hold the archives that will come from duplicate) and I ended up having to start the DUPLICATE command all over again. The recovery &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/www.dbarj.com.br\/en\/2015\/01\/resume-oracle-duplicate-database-failed-recovery-datafiles\/\">Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26],"tags":[],"class_list":["post-1219","post","type-post","status-publish","format-standard","hentry","category-rman-en","item-wrap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Resume an Oracle DUPLICATE database that failed on RECOVERY of datafiles - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"How to resume an Oracle DUPLICATE database that failed on RECOVERY of datafiles\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbarj.com.br\/en\/2015\/01\/resume-oracle-duplicate-database-failed-recovery-datafiles\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\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:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/01\\\/resume-oracle-duplicate-database-failed-recovery-datafiles\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/01\\\/resume-oracle-duplicate-database-failed-recovery-datafiles\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"Resume an Oracle DUPLICATE database that failed on RECOVERY of datafiles\",\"datePublished\":\"2015-01-09T19:23:23+00:00\",\"dateModified\":\"2019-10-23T20:01:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/01\\\/resume-oracle-duplicate-database-failed-recovery-datafiles\\\/\"},\"wordCount\":675,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"articleSection\":[\"Recovery Manager (RMAN)\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/01\\\/resume-oracle-duplicate-database-failed-recovery-datafiles\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/01\\\/resume-oracle-duplicate-database-failed-recovery-datafiles\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/01\\\/resume-oracle-duplicate-database-failed-recovery-datafiles\\\/\",\"name\":\"Resume an Oracle DUPLICATE database that failed on RECOVERY of datafiles - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\"},\"datePublished\":\"2015-01-09T19:23:23+00:00\",\"dateModified\":\"2019-10-23T20:01:21+00:00\",\"description\":\"How to resume an Oracle DUPLICATE database that failed on RECOVERY of datafiles\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/01\\\/resume-oracle-duplicate-database-failed-recovery-datafiles\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/01\\\/resume-oracle-duplicate-database-failed-recovery-datafiles\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/01\\\/resume-oracle-duplicate-database-failed-recovery-datafiles\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Resume an Oracle DUPLICATE database that failed on RECOVERY of datafiles\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"width\":712,\"height\":712,\"caption\":\"DBA RJ\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Resume an Oracle DUPLICATE database that failed on RECOVERY of datafiles - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"How to resume an Oracle DUPLICATE database that failed on RECOVERY of datafiles","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:\/\/www.dbarj.com.br\/en\/2015\/01\/resume-oracle-duplicate-database-failed-recovery-datafiles\/","twitter_misc":{"Written by":"DBA RJ","Est. reading time":"14 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbarj.com.br\/en\/2015\/01\/resume-oracle-duplicate-database-failed-recovery-datafiles\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/2015\/01\/resume-oracle-duplicate-database-failed-recovery-datafiles\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"Resume an Oracle DUPLICATE database that failed on RECOVERY of datafiles","datePublished":"2015-01-09T19:23:23+00:00","dateModified":"2019-10-23T20:01:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2015\/01\/resume-oracle-duplicate-database-failed-recovery-datafiles\/"},"wordCount":675,"commentCount":4,"publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"articleSection":["Recovery Manager (RMAN)"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbarj.com.br\/en\/2015\/01\/resume-oracle-duplicate-database-failed-recovery-datafiles\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/en\/2015\/01\/resume-oracle-duplicate-database-failed-recovery-datafiles\/","url":"https:\/\/www.dbarj.com.br\/en\/2015\/01\/resume-oracle-duplicate-database-failed-recovery-datafiles\/","name":"Resume an Oracle DUPLICATE database that failed on RECOVERY of datafiles - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/#website"},"datePublished":"2015-01-09T19:23:23+00:00","dateModified":"2019-10-23T20:01:21+00:00","description":"How to resume an Oracle DUPLICATE database that failed on RECOVERY of datafiles","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/en\/2015\/01\/resume-oracle-duplicate-database-failed-recovery-datafiles\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/en\/2015\/01\/resume-oracle-duplicate-database-failed-recovery-datafiles\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbarj.com.br\/en\/2015\/01\/resume-oracle-duplicate-database-failed-recovery-datafiles\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbarj.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"Resume an Oracle DUPLICATE database that failed on RECOVERY of datafiles"}]},{"@type":"WebSite","@id":"https:\/\/www.dbarj.com.br\/en\/#website","url":"https:\/\/www.dbarj.com.br\/en\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbarj.com.br\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","width":712,"height":712,"caption":"DBA RJ"},"logo":{"@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png"}}]}},"_links":{"self":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/1219","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/comments?post=1219"}],"version-history":[{"count":2,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/1219\/revisions"}],"predecessor-version":[{"id":4321,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/1219\/revisions\/4321"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/media?parent=1219"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/categories?post=1219"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/tags?post=1219"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}