Re: rman incomplete recovery

  • From: sundar mahadevan <sundarmahadevan82@xxxxxxxxx>
  • To: Oracle-L@xxxxxxxxxxxxx
  • 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@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.
>

Other related posts: