FreeLists / oracle-l / RE: RMAN incomplete recovery environment setup?

["Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>]

I know, but they do have to be set somewhere to do certain things.  Thanks
for clarifying this for the questioner.  Ruth

-----Original Message-----
From: Mercadante, Thomas F (LABOR)
[mailto:Thomas.Mercadante@xxxxxxxxxxxxxxxxx]
Sent: Wednesday, June 01, 2005 3:05 PM
To: rgramolini@xxxxxxxxxxxxxxx; mccdba1@xxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
Subject: RE: RMAN incomplete recovery environment setup?


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=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/
--
http://www.freelists.org/webpage/oracle-l

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

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