Re: RMAN - Rewind Backup to SCN/Point-in-Time
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 27 Sep 2011 18:37:27 -0700 (PDT)
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@xxxxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
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
>
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
