Re: How to restore only archives from RMAN catalog
From: Martin Klier <usn_at_usn-it.de>
Date: Mon, 27 Oct 2008 13:21:44 +0100
Message-ID: <4905B258.4010006@usn-it.de>
Date: Mon, 27 Oct 2008 13:21:44 +0100
Message-ID: <4905B258.4010006@usn-it.de>
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 documentation.
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-lReceived on Mon Oct 27 2008 - 07:21:44 CDT