This discussion is archived
14 Replies Latest reply: Oct 3, 2012 3:28 PM by user301176 RSS

recover db failed due to the restore was 7 days ago: default of controlfile

user301176 Explorer
Currently Being Moderated
We restore production backups on 09/24 UTC time to a pilot testing environment.

Then due to some reasons, we did not recover until this morning. However the recover got me errors such as:
RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time

I tried to restore the controlfile from autobackup, the rman will look controlfile autobackup up to 09/25, and said nothing found.

At this point, what I can do to recover the db still without redo the restore of this Sunday backup?

Thanks in advance.

Legend

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