RE: RMAN incomplete recovery environment setup?
- From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
- To: <mccdba1@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 1 Jun 2005 14:49:43 -0400
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=AMERICAN_AMERICA.WE8MSWIN1252
$NLS_DATE_FORMAT='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
Other related posts:
