RE: RMAN incomplete recovery environment setup?
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <rgramolini@xxxxxxxxxxxxxxx>, <mccdba1@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 1 Jun 2005 15:05:23 -0400
Ruth,
In 9i, these environmental variables are not required. You can do the
same thing with an Rman command in the recovery script:
set until time
"to_date('2001-06-22:13:25:00','yyyy-mm-dd:hh24:mi:ss')";
Tom
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ruth Gramolini
Sent: Wednesday, June 01, 2005 2:50 PM
To: mccdba1@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: RMAN incomplete recovery environment setup?
I will make an attempt to give some answers to your questions. See them
inline.
HTH,
Ruth
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of dba1 mcc
Sent: Wednesday, June 01, 2005 2:24 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RMAN incomplete recovery environment setup?
I am study on ORACLE 9i RMAN "incomplete recovery"
document and it mention:
Insure that NLS_LANG and NLS_DATE_FORMAT environment
variables are set appropriately:
$NLS_LANG=3DAMERICAN_AMERICA.WE8MSWIN1252
$NLS_DATE_FORMAT=3D'YYYY-MM-DD:HH24:MI:SS'
My question are:
1. is it required?
If you are going to do a point in time recovery you need to set the
NLS_DATE_FORMAT. If you are going to do a complete recovery it is not
necessary but can't hurt. Here is what the case4.rcv demo script says:
Make sure to set your NLS_LANG and NLS_DATE_FORMAT environment
variables.
# You can set these values to whatever you wish. The UNIX example
# below keeps the date format to the standard date format used
# for recovery:
#
# %> setenv NLS_LANG AMERICAN
# %> setenv NLS_DATE_FORMAT 'YYYY-MM-DD:hh24:mi:ss'
2. on RMAN "Complete recovery", I did not see document
say that. Do I need also specify those variables on
"RMAN complete recovery"?
See above, please.
3. How about "hot backup/recovery"?
These variables are not necessary for backup but may be for recovery.
There is no such thing as a hot recovery. You can do a point in time
recovery to, for example, recover dropped items. This you would do to a
duplicate database and then export the dropped items and import them to
the
database in need of recovery. But there is no such thing as hot
recovery,
per se.
Thanks
__________________________________
Discover Yahoo!
Use Yahoo! to plan a weekend, have fun online and more. Check it out!
http://discover.yahoo.com/
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
