14 Replies Latest reply: Oct 3, 2012 5:28 PM by 877440 RSS

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

      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.