RE: RMAN incomplete recovery environment setup?

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Wed, 1 Jun 2005 15:10:45 -0400
Message-ID: <00b701c566dd$9d174280$8459000a@vttaxnet.tax.state.vt.us>

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_at_labor.state.ny.us] Sent: Wednesday, June 01, 2005 3:05 PM
To: rgramolini_at_tax.state.vt.us; mccdba1_at_yahoo.com; oracle-l_at_freelists.org
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_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:

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'
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.
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

Received on Wed Jun 01 2005 - 15:16:38 CDT