Re: RMAN - Rewind Backup to SCN/Point-in-Time

To add more information:

Client once asked to restore the whole database to sometime the day before the last full RMAN incremental level 0 backup. All datafiles, control files and redo were on-line. The level 0 backup was successful with 'archivelog all delete input', so there are no archivelogs to rewind.

Its all in the RMAN backup.

I was thinking incomplete recovery to SCN or point-in-time with RESETLOGS might do it. I'm building a test database to try various recovery scenarios.

To reiterate: Can an entire database be recovered to an SCN or point-in_time using UNTIL SCN or UNTIL TIME clause from just an incremental level 0 backup?

Cheers,

• Alan Sterger

On 9/27/2011 3:18 PM, Alan Sterger wrote:
> Hello List,
>
> Is it possible to take an RMAN backup (full or incremental level 0)
> and rewind it, rollback to a SCN or point-in-time within the
> controlfile's CONTROL_FILE_RECORD_KEEP_TIME window?
>
> Database is 9.2.0.8 and in Archivelog mode.
>
> Cheers,
>
> -- Alan Sterger
>
>

--
http://www.freelists.org/webpage/oracle-l