| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN incomplete recovery environment setup?
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_at_yahoo.com]
Sent: Thursday, June 02, 2005 9:20 AM
To: Mercadante, Thomas F (LABOR); rgramolini_at_tax.state.vt.us;
oracle-l_at_freelists.org
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?
> 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
> Ruth Gramolini
> Sent: Wednesday, June 01, 2005 2:50 PM
> To: mccdba1_at_yahoo.com; oracle-l_at_freelists.org
> 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of
> dba1 mcc
> Sent: Wednesday, June 01, 2005 2:24 PM
> To: oracle-l_at_freelists.org
> 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-lReceived on Thu Jun 02 2005 - 09:46:03 CDT
 |
 |