Re: How to restore only archives from RMAN catalog
- From: "Syed Jaffar Hussain" <sjaffarhussain@xxxxxxxxx>
- To: guillermo.bort@xxxxxxx
- Date: Mon, 27 Oct 2008 15:36:29 +0300
>>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@xxxxxxx>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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Martin Klier
> Sent: Monday, October 27, 2008 10:22 AM
> To: shastry17@xxxxxxxxx
> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
> --
> //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."
Other related posts:
