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

  • From: Robert Freeman <robertgfreeman@xxxxxxxxx>
  • To: "asterger@xxxxxxxxxxxxx" <asterger@xxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 28 Sep 2011 00:58:21 -0700 (PDT)

The point that I've tried to make, and perhaps not very well, is that it's not 
about RMAN. It's about understanding the internals of the Oracle database. This 
is about how backup and recovery works, period. RMAN is nothing more than a 
glorified set of scripts that automate the backup and recovery process and some 
interfaces into other restore related functionality (like flashback). Still, 
it's just a backup and backups still, fundamentally work the same way as it did 
back in the V7 days. Yes, RMAN comes with incremental backups and the like but 
the basics still apply. If you knew how to backups then, then you know how to 
do them now. Sure there are more bells and whistles (transportable tablespaces, 
flashback, etc...) but the basic and fundamental things have not changed.

The other problem is that I think you have rephrased this question at least 
three different ways, such that it's become three different questions. Thus, 
your question really is not clear to me at all. Perhaps this is just a failing 
on my part to comprehend what you are trying to accomplish. I *think* I've 
answered your question, but I'm just not sure.

If you have some recovery scenarios that are not in the book that you think 
should be in the book please send them my way. We have a whole chapter 
dedicated to just those and I'm happy to add one if it seems relevant.



Robert G. Freeman
Master Principal Consultant, Oracle Corporation, Oracle ACE
Author of various books on RMAN, New Features and this shorter signature line.

the opinion of one Oracle employee. I can be wrong, have been wrong in the past 
and will be wrong in the future. If your problem is a critical production 
problem, you should always contact Oracle support for assistance. Statements in 
this email in no way represent Oracle Corporation or any subsidiaries and 
reflect only the opinion of the author of this email.

From: Alan Sterger <asterger@xxxxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Sent: Tuesday, September 27, 2011 7:53 PM
Subject: Re: RMAN - Rewind Backup to SCN/Point-in-Time

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?


-- 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 and in Archivelog mode.
>> Cheers,
>> -- Alan Sterger


Other related posts: