Re: rman incomplete recovery
Date: Fri, 7 Aug 2009 13:59:57 -0400
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_at_parexel.com>wrote:
> 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_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *sundar mahadevan
> *Sent:* Friday, August 07, 2009 1:31 PM
> *To:* Oracle-L_at_freelists.org
> *Subject:* rman incomplete recovery
> Hi All,
> I would like to know if an incomplete recovery is possible in the following
> 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.