RE: rman incomplete recovery

From: Goulet, Richard <Richard.Goulet_at_parexel.com>
Date: Fri, 7 Aug 2009 14:05:15 -0400
Message-ID: <23C4836D8E9C5F4280A66C0C247BC16F2C24C4B6_at_US-BOS-MX011.na.pxl.int>

Then give it a try,. By all that I know about the internals Oracle should roll the control file scn up to the lowest one that's stored in the datafiles without problems. Course I can always be wrong.  

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 2:00 PM
To: Oracle-L_at_freelists.org
Subject: Re: rman incomplete recovery

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 - 13:05:15 CDT