Re: rman incomplete recovery

From: sundar mahadevan <sundarmahadevan82_at_gmail.com>
Date: Fri, 7 Aug 2009 13:59:57 -0400
Message-ID: <7d81ec570908071059x6ac85309w5a4f38782fe7f373_at_mail.gmail.com>

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:

> 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_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
> 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.
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Aug 07 2009 - 12:59:57 CDT