Thank you John.

So I can have following plan in which I don't need more than one day backup
for recovery.

Sunday: Full- Level 0 backup
Monday to Saturday: Cumulative Incremental Backups - level 1 backup.

Since level1 is cumulative backup so it should always back up all the data
block from level0 backup. Correct?

Also can someone please send me a sample script to take these backups.

Thank you so much.

Puneet

> ----- Original Message -----
> From: John Watcher
> To: LazyDBA.com Discussion
> Sent: Monday, September 29, 2003 4:36 PM
> Subject: Re: Question on Rman Backup
>
>
> You need to apply all the incremental backups unless they are cumulative
>incremental backups. Incase of cumulative incremental backup you need to
>only last cumulative backup.
>
> -John
>
>
> Puneet Sharma <[Email Address Removed] wrote:
> Hi Everybody,
>
> I am implementing new backup and recovery process using RMAN on oracle
>8.1.7 and wanted to verify few things from you. Below is the plan that I
>would like to use.
>
> Sunday: Full- Level 0 backup
> Monday to Saturday: Incremental - level 0 backup.
>
> Now my question is:
> If I need to recover database say on Friday then would I need full
>backup level0 (Sunday) and only last night level1 (Thursday) backup or all
>level1 backups since Monday.
>
> Can you please advise?
>
> Thanks,
> Puneet
>
>
>
>
>
>
>
>
>
>
>
>------------------------------------------------------------------------------
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product search

_________________________________________________________________
Frustrated with dial-up? Get high-speed for as low as $29.95/month
(depending on the local service providers in your area).
https://broadband.msn.com

Oracle LazyDBA home page