Help - Search - Members - Calendar
Full Version: Rman Restore on 11g
Oracle DBA Forums > Oracle > Oracle Forum
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
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-2014 Invision Power Services, Inc.