WG: How to restore only archives from RMAN catalog

There is no need to use the to_date() function as the date-format has been exported.  

Von: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] Im Auftrag von Syed Jaffar Hussain
Gesendet: Montag, 27. Oktober 2008 13:36 An: guillermo.bort_at_eds.com
Cc: usn_at_usn-it.de; shastry17_at_gmail.com; oracle-l Betreff: Re: How to restore only archives from RMAN catalog

>>Set until time '17-10-2008 00:00:00';"
I doubt it will work correctly.
If I am not wrong, you should use "to_date('17-10-2008 00:00:00', 'DD-MM-YYYY HH:MI:SS')" On Mon, Oct 27, 2008 at 3:30 PM, Bort, Guillermo <guillermo.bort_at_eds.com> wrote:

        Something like         

	Export NLS_DATE='dd-mm-yyyy hh24:mi:ss'
	Rman target /
	Run {
	Set until time '17-10-2008 00:00:00';
	Restore database;
	Recover database;
	Alter database open resetlogs;
	}
	
	*Should* work
	
	Guillermo Alan Bort
	DBA / DBA Main Team
	
	EDS, an HP company
	

	-----Original Message-----
	From: oracle-l-bounce_at_freelists.org
	[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Martin Klier
	Sent: Monday, October 27, 2008 10:22 AM
	To: shastry17_at_gmail.com
	Cc: oracle-l
	Subject: Re: How to restore only archives from RMAN catalog
	
	Hi,
	
	you can give RMAN a regular date/time point-in-time for
recovery, or a
	SCN, or a log sequence number, just look up the RMAN

	Example:
	RMAN> recover database until time 'sysdate -3';
	
	Regards
	Martin Klier
	
	Shastry(DBA) schrieb:
	> 2PM(in my case) in test environment. Please advice if there is
a
	chance
	> to restore only archives to the test server on some mount and
then
	apply
	> archives manually till the requested time, if suppose it is
possible
	can
	> we mention the specific location to restore the required
archives ( i
	> believe we need to mention the SCN number to restore).
	--
	Usn's IT Blog for Linux, Oracle, Asterisk
	http://www.usn-it.de
	
	--
	http://www.freelists.org/webpage/oracle-l
	
	
	--
	http://www.freelists.org/webpage/oracle-l
	
	
	

-- 
Best Regards,

Syed Jaffar Hussain
Oracle Certified Master (10g)
http://www.oracle.com/technology/ocm/shussain.html
Oracle ACE
http://apex.oracle.com/pls/otn/f?p=19297:4:1579866181463918::NO:4:P4_ID:
126
OCP 8i,9i & 10g DBA
RAC Certified Expert
Official Oracle RAC SIG Representative for Saudi Arabian region
(http://www.oracleracsig.org/)
I blog at
http://jaffardba.blogspot.com/
--------------------
"Winners don't do different things. They do things differently."


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