Rman Restore on 11g Options

[Jerald Praveen]

Hi,

I have some problem while restore the database in separate environment.

This My backup policy and retention

I have monthly full database backup on march the backup started 2nd march 15:31 and completed at 03 march 11:12 AM retention period 3 years

We have ADHOC ARCHIVE backup which will run for certain conditions if the file system threshold reach 80%

In between the monthly backup the ADHOC ARCHIVE jobs has executed from 03Mar2011 00:00 to 03Mar2011 05:14 this retention period is 30 days

So while restore the database with the help of monthly backup i can't able to recover the the datafiles due to adhoc archive files are missing.

If there is any way to rectify this situation

Regards
Jerry

[SteveC]

If you backed up the archived redo logs, then restore them.

[Jerald Praveen]

Hi steve

its not in the tape because of retention period ,its 30 days only

Regards
Jerald

[SteveC]

Restore from an older backup.

[RHR]

More information on RMAN incremental backups is available here:

http://www.dba-oracle.com/t_incr_different...ive_backups.htm

RHR