RE: How to restore only archives from RMAN catalog
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <guillermo.bort@xxxxxxx>, <Jan-Hendrik.Boll@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 27 Oct 2008 09:27:19 -0400
I think everybody is correct. Lots of ways to skin the cat.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bort, Guillermo
Sent: Monday, October 27, 2008 9:15 AM
To: Jan-Hendrik.Boll@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: How to restore only archives from RMAN catalog
I am not certain as to the exact name of the env variable, however an
alternative that works well is
Run {
Sql 'alter session set nls_date_formate '''dd-mm-yyyy hh24:mi:ss'''';
...
}
regards
Guillermo Alan Bort
DBA / DBA Main Team
EDS, an HP company
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
Jan-Hendrik.Boll@xxxxxxxxxxx
Sent: Monday, October 27, 2008 11:11 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: 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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] Im Auftrag von Syed Jaffar
Hussain
Gesendet: Montag, 27. Oktober 2008 13:36
An: guillermo.bort@xxxxxxx
Cc: usn@xxxxxxxxx; shastry17@xxxxxxxxx; 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@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:
