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

["Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>]

As far as I'm concerned, you don't need either of these things set.
NLS_LANG is already defaulted to your Oracle installation (and the
database when you created it).  Likewise with NLS_DATE_FORMAT.

Rman runs under the Oracle installation on your database server.  The
only time you need to worry about environmentals is when you have
multiple oracle homes installed on your server - you just need to make
sure your oracle home matches the database you are running against.

To answer your question - no.  Rman recovery will work fine.

-----Original Message-----
From: dba1 mcc [mailto:mccdba1@xxxxxxxxx]=20
Sent: Thursday, June 02, 2005 9:20 AM
To: Mercadante, Thomas F (LABOR); rgramolini@xxxxxxxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
Subject: RE: RMAN incomplete recovery environment setup?

Thanks.

Now I understand what "NLS_DATE_FORMAT" doing, but I
still don't understand why "NLS_LANG" require? =20

If I don't put "NLS_LANG", will RMAN recovery mess up
my data?

Anyone have ideal?

--- "Mercadante, Thomas F (LABOR)"
<Thomas.Mercadante@xxxxxxxxxxxxxxxxx> wrote:

> Ruth,
>=20
> In 9i, these environmental variables are not
> required.  You can do the
> same thing with an Rman command in the recovery
> script:
>=20
>    set until time
>
"to_date('2001-06-22:13:25:00','yyyy-mm-dd:hh24:mi:ss')";
>=20
> Tom
>=20
>=20
> -----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?
>=20
> I will make an attempt to give some answers to your
> questions.  See them
> inline.
>=20
> HTH,
> Ruth
>=20
> -----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?
>=20
>=20
> I am study on ORACLE 9i RMAN "incomplete recovery"
> document and it mention:
>=20
>   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'
>=20
> My question are:
>=20
> 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'
>=20
> 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.
>=20
> 3. How about "hot backup/recovery"?
>=20
> 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.=20
> 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.
>=20
> Thanks
>=20
>=20
>=20
> __________________________________
> 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
>=20
> --
> http://www.freelists.org/webpage/oracle-l
>=20



        =09
__________________________________=20
Discover Yahoo!=20
Have fun online with music videos, cool games, IM and more. Check it
out!=20
http://discover.yahoo.com/online.html
--
http://www.freelists.org/webpage/oracle-l