Re: Backup & Restore

From: Cristian Cudizio <cristian.cudizio_at_yahoo.it>
Date: Tue, 18 Sep 2007 12:35:35 +0200
Message-ID: <fco90i$162n$1@sxnews1.qg.com>

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,

-- 
Cristian Cudizio

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

Received on Tue Sep 18 2007 - 05:35:35 CDT