Help - Search - Members - Calendar
Full Version: Rman Restore on 11g
Oracle DBA Forums > Oracle > Oracle Forum
Jerald Praveen

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

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

Restore from an older backup.
More information on RMAN incremental backups is available here:

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2015 Invision Power Services, Inc.