Re: RMAN - Rewind Backup to SCN/Point-in-Time
Date: Tue, 27 Sep 2011 18:37:27 -0700 (PDT)
Message-ID: <1317173847.35049.YahooMailNeo_at_web113211.mail.gq1.yahoo.com>
I'm actually going to answer this with a tentative maybe, but there are some big IF's here..... (I'll let the initial shock wear off, don't worry folks,I've not lost my mind).
I'm assuming that your question is something like restoring to SCN 90000 via RMAN, and then being able to then rollback to SCN 80000 once the restore is complete.
First, NO you can't do it with just RMAN. To be honest, if you don't know this answer then I'd be really nervous with you around my databases anywhere. You can only do a point-in-time recovery to the point of the backup after the LAST datafile that has been backed up. In this case, this restore will also require any redo generated since the BEGINNING of the backup. If your datafile backup ends at 18:00, then the oldest point you could ever hope to restore to with that backup set is 18:00 and you would need the redo generated during the backup to do that.
So, from the house of the hard core, sad depressing, that's the way it works answers, there you go...
BUT.... What if you had your RMAN backup AND you had flashback database enabled AND you had backups of the flash recovery logs ... hmmmm, then you might be able to work something out.Depending on a number of things it's possible that you could flashback the database after restoring it via RMAN. I can't say that I've ever done this, but I think it should work.
So from the think out of the box side of the room.... there is a possibility. There are always possibilities... ;)
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 6:12 PM Subject: Re: RMAN - Rewind Backup to SCN/Point-in-Time
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 Tue Sep 27 2011 - 20:37:27 CDT