Re: Backup & Restore

From: Cristian Cudizio <cristian.cudizio_at_yahoo.it>
Date: Tue, 18 Sep 2007 17:55:42 +0200
Message-ID: <fcoron$1b5h$2@sxnews1.qg.com>

DA Morgan wrote:

> 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,

> 
> What vitalisman said plus ... you can dislike level 1 backups all you
> want if you have a very small database. Move into the tens of TB or
> above and you will quickly discover level 0 is a luxury.

there's no doubt, however the question is about time to make full backup, not space. However you pay a price in the unpleasant situation you have to restore the backup

regards

-- 
Cristian Cudizio

http://oracledb.wordpress.com
http://cristiancudizio.wordpress.com

Received on Tue Sep 18 2007 - 10:55:42 CDT