Re: RMAN - Rewind Backup to SCN/Point-in-Time
Date: Wed, 28 Sep 2011 00:58:21 -0700 (PDT)
Message-ID: <1317196701.91910.YahooMailNeo_at_web113202.mail.gq1.yahoo.com>
Alan,
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.
Cheers!
RF
Robert G. Freeman
Master Principal Consultant, Oracle Corporation, Oracle ACE
Author of various books on RMAN, New Features and this shorter signature line.
Blog: http://robertgfreeman.blogspot.com
Note: THIS EMAIL IS NOT AN OFFICIAL ORACLE SUPPORT COMMUNICATION. It is just 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_at_earthlink.net> To: oracle-l_at_freelists.org
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?
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
>>
>>
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 28 2011 - 02:58:21 CDT