RE: RMAN madness !!

Set the environment variables for your shell. You don't have to change your database settings.

e.g. (in ksh)

NLS_DATE_FORMAT=YYYYMMDDHH24MISS
export NLS_DATE_FORMAT
NLS_LANG=AMERICAN_AMERICA.WE8DEC
export NLS_LANG

Jay

>>> "SARKAR, Samir" <Samir.SARKAR_at_nottingham.sema.slb.com> 04/08/02 01:44PM >>>
Jay,

Thanks so much for ur help. Could u please tell me whether I shall have to set the NLS_DATE_FORMAT and NLS_LANG in the parameter file of the auxiliary db alone or on
the target db (the main prod db) as well ???

Regards,
Samir

Samir Sarkar
Oracle DBA
SchlumbergerSema
Email : samir.sarkar_at_nottingham.sema.slb.com

            ssarkar2_at_slb.com
Phone : +44 (0) 115 - 957 6028
EPABX : +44 (0) 115 - 957 6418 Ext. 76028 Fax : +44 (0) 115 - 957 6018

-----Original Message-----
Sent: 08 April 2002 18:28
To: ORACLE-L_at_fatcity.com; SARKAR, Samir

You need to change this line

set until time 'to_date(''20-MAR-2002
20:00:00'',''DD-MON-YYYYHH24:MI:SS'')'; to

set until time '20020320200000';

This is bug 1887009. This isn't fixed until 9.0.2.

You must set
NLS_DATE_FORMAT=YYYYMMDDHH24MISS (or your favorite date format) and
NLS_LANG= (whatever your nls lang is for the database)

I learned the hard way, that if you don't set NLS_LANG, then NLS_DATE_FORMAT is ignored (at least in 8.1.7 on Tru64).

Don't forget to shutdown your auxiliary db, delete it's files, then start it up again, NOMOUNT.

Jay

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jay Hostetter
  INET: jhostetter_at_decommunications.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).