Re: RMAN - Rewind Backup to SCN/Point-in-Time
- From: Alan Sterger <asterger@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 28 Sep 2011 13:34:40 -0400
Hello List,
Let's take a slightly different tack: I use RMAN Duplication to create
test databases. Backups execute at 5AM, I create the clone at 9PM. I
copy just the RMAN backup pieces to the Aux server, no archivelogs. On
RMAN's first pass, receive:
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq nnnn scn nnnnnnnnn found to
restore.
For the next pass, add UNTIL SCN clause of nnnnnnnnn-1 and the
duplication succeeds. This led me to think if SCN can be manipulated
for duplication, why can't it be manipulated for restore?
Your thoughts?
Cheers,
-- Alan Sterger
On 9/27/2011 10:53 PM, Alan Sterger wrote:
> 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:
