RE: rman incomplete recovery

  • From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
  • To: <sundarmahadevan82@xxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
  • Date: Fri, 7 Aug 2009 13:56:24 -0400

    My gut tells me you will need archive logs, at least for the
duration that the backup ran.

Dick Goulet 
Senior Oracle DBA 
PAREXEL International 



From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of sundar mahadevan
Sent: Friday, August 07, 2009 1:31 PM
To: Oracle-L@xxxxxxxxxxxxx
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.

Other related posts: