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.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Sep 18 2007 - 10:13:58 CDT
