This discussion is archived
5 Replies Latest reply: Feb 6, 2013 3:45 PM by user88831 RSS

recovery using restored controlfile + datafiles

user88831 Newbie
Currently Being Moderated
Hi Guys,
version: 10.2.0.5
Let's say I have a rman backup to tape (full backup, controlfile, archivelogs) taken at 3am this morning.
At 6pm, someone accidentally deleted the datafiles and controlfiles and the db crash. Archivelogs, redologs are still there.
If i restore the controlfile and datafiles from the 3am backup and do a recover database, am i still able to perform a point in time recovery? (including the transactions in redolog). If yes, how is the controlfile able to know which archive logs to apply?

Or do i need really need the current controlfile to perform recovery up to the crash time?

thanks

Legend

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