Re: Backup & Restore

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Tue, 18 Sep 2007 09:43:13 -0500
Message-ID: <46efd80b$0$16311$88260bb3@free.teranews.com>

Cristian Cudizio wrote:
> Ravip via DBMonster.com wrote:

>> Hi
>>
>> If i have the backup of the database (RMAN incremental backup) for a
>> particular date, eg: till yesterday I have the backup. Due to some 
>> reason ,
>> if restore needs, from which time onwards the archive redolog needs to 
>> apply ?
>>
>>
>> 16-09-2007 3:00 AM: Backup incremental level 1 - finished successfully
>> 17-09-2007 11:00 AM: DB down to HDD controller failure.
>>
>> Need to restore from the 16th backup - and how about the archive redolog
>> files ? Please clarify.
>>
>>
>> Thank You.
>>

>
> I'm not confortable with incremental backups, however i think you have to
> restore first your level 0 backup, then all level 1 backups and then apply
> redo logs from last backup op 16-09-2007. This is why i don't like
> incremental backups....
>
>
>
> regards,
>
>

Christian,

Have you looked at Incrementally Updated Backups in 10g? With IUB, you only have to restore the level 0 and then *one* level 1 backup and the redo logs.

There is more information in the RMAN docs.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com

Received on Tue Sep 18 2007 - 09:43:13 CDT