RE: How to restore only archives from RMAN catalog

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 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-l


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