RE: RMAN incomplete recovery environment setup?
- From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
- To: "dba1 mcc" <mccdba1@xxxxxxxxx>, "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 2 Jun 2005 09:36:46 -0400
No, rman will not mess up your data. It will probably tell you that the
backup was done in one NLS_LANG and the database you are restoring too has
another NLS_LANG. That is why they tell you to set it just in case.
Regards,
Ruth
-----Original Message-----
From: dba1 mcc [mailto:mccdba1@xxxxxxxxx]
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?
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,
>
> 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/
> --
> //www.freelists.org/webpage/oracle-l
>
> --
> //www.freelists.org/webpage/oracle-l
>
__________________________________
Discover Yahoo!
Have fun online with music videos, cool games, IM and more. Check it out!
http://discover.yahoo.com/online.html
--
//www.freelists.org/webpage/oracle-l
Other related posts:
