RE: RMAN madness.....Sanity at last !!!!

From: SARKAR, Samir <Samir.SARKAR_at_nottingham.sema.slb.com>
Date: Tue, 09 Apr 2002 02:18:22 -0800
Message-ID: <F001.0043F405.20020409021822@fatcity.com>

Jay and Jack,

Thanks a trillion for ur help.....it WORKED !!!!

I have learnt so much from this.

Cheers,
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 20:42
To: ORACLE-L_at_fatcity.com; SARKAR, Samir

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

---

This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema.
If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited.

If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.

---

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: SARKAR, Samir
  INET: Samir.SARKAR_at_nottingham.sema.slb.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).

Received on Tue Apr 09 2002 - 05:18:22 CDT