This discussion is archived
6 Replies Latest reply: Jul 4, 2013 3:44 AM by 950743 RSS

rman ruplicate / recovery thru new data file addition

950743 Newbie
Currently Being Moderated


I need to refresh test system using backup of prod and  using rman duplicate command...

here is the senario

prod db was back up completes at  4am  ,  9am new data file addedd to the prod db ... and i want to use 4am backup to restore and recover up to 4pm same day!! 


here is error



RMAN-03002: failure of Duplicate Db command at 06/29/2013 11:23:52
RMAN-03015: error occurred in stored script Memory Script
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20201: datafile not found in the recovery catalog
RMAN-06010: error while looking up datafile: 9





are there step by step guide to carry out such duplicate  ?

thank in advance


  • Correct Answers - 10 points
  • Helpful Answers - 5 points