Re: RMAN - Rewind Backup to SCN/Point-in-Time
- From: Alan Sterger <asterger@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 27 Sep 2011 22:53:25 -0400
Hello List,
I've been a DBA since Oracle 7 on enterprise class systems. Back then,
there was no RMAN. Most backups where done cold, using Backup Exec,
Veritas, ... Even when RMAN was released, most enterprises were happy
with their big iron tape robots or had advanced to hot, split mirror
backups. So yes, my knowledge of RMAN is stunted.
Robert I did buy your 10g RMAN book and have read it. I was hoping for
more recovery scenarios but alas, a book can't be all things to all people.
Yes, I want to recover to an earlier SCN or point-in-time than is
contained within an incremental level 0 backup. The point is to
recover, the tool or method is not important. How about SQLPlus? How
about Log Miner?
Cheers,
-- Alan Sterger
On 9/27/2011 9:12 PM, Alan Sterger wrote:
> Hello List,
>
> 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
>>
>>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
