I do have all the archived logs and redo logs after the backup but none before the backup. But I 'm not sure if rman would do an incomplete recovery till Jul 21, 2009 10 AM. On Fri, Aug 7, 2009 at 1:56 PM, Goulet, Richard <Richard.Goulet@xxxxxxxxxxx>wrote: > Sundar, > > 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. >