Re: rman incomplete recovery

From: Robert Freeman <>
Date: Fri, 7 Aug 2009 12:37:25 -0700 (PDT)
Message-ID: <>

Was the Level 0 backup done with the plus archivelog option? If so then the level 0 backup should backup all archived redo logs required to restore the database to at least the point of the level 0 backup.

If you did not use the plus archivelog option and If there are no archived redo logs, then your backup is not adequate to do a restore of even the level 0 backup.


 Robert G. Freeman
Oracle ACE
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON IT'S WAY SOON! OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex) Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Features (Oracle Press)
Other various titles out of print now... Blog: The LDS Church is looking for DBA's. You do have to be a Church member in good standing. A lot of kind people write me, concerned I may be breaking the law by saying you have to be a Church member. It's legal I promise! :-)

From: [] On Behalf Of sundar mahadevan

Sent: Friday, August 07, 2009 1:31 PM
Subject: rman incomplete recovery  

Hi All,
I would like to know if an incomplete recovery is possible in the following scenario:

control file back up from May 05, 2009.
Incremental level 0 backup taken on Jul 21, 2009 that completed 8 AM Is it possible to do an incomplete recovery till Jul 21, 2009 10 AM. There are no archivelogs between May 05, 2009 and Jul 21, 2009.

The back up is the only back up and there are no archivelogs. Thanks in advance. Would RMAN use this control file and apply the changes from backup. To my knowledge, RMAN would need archive logs to apply redo. Would appreciate if someone could reply at the earliest as I need to try it out right away.

Received on Fri Aug 07 2009 - 14:37:25 CDT

Original text of this message