RE: RMAN cold backups continued

From: Paul Baumgartel <pbaumgartel_at_mortgagesight.com>
Date: Wed, 15 Aug 2001 07:15:10 -0700
Message-ID: <F001.0036B145.20010815061139@fatcity.com>

I found the problem--O/S enviroment variable NLS_LANG must be set. Thanks.

Paul Baumgartel
MortgageSight Holdings, LLC
pbaumgartel_at_mortgagesight.com

-----Original Message-----
Sent: Wednesday, August 15, 2001 9:10 AM To: 'ORACLE-L_at_fatcity.com'

Thanks to everyone who replied yesterday. It appears I had already been on the right track, as I did attempt backups with the database in noarchivelog mode and mounted but not open.

Hot backups, with DB in archivelog mode, worked fine. However, cold backups, performed in the manner stated above, fail (see below) with errors mentioning "database keyword" and "character set". This is Oracle 9.0.1 on Solaris. I'll appreciate any ideas; thanks!

Paul Baumgartel
MortgageSight Holdings, LLC
pbaumgartel_at_mortgagesight.com

RMAN> shutdown immediate

2> startup mount
3> run {
4>             allocate channel t1 type disk;
5>             backup incremental level 0
6>                format '/dbbackup/%d/t%t_s%s_p%p'
7>                database
8>                ;
9>             release channel t1;

10> }
11> exit
database closed
database dismounted
Oracle instance shut down

connected to target database (not started) Oracle instance started
database mounted

Total System Global Area 235701300 bytes

Fixed Size                      279604 bytes
Variable Size                167772160 bytes
Database Buffers              67108864 bytes
Redo Buffers                    540672 bytes

using target database controlfile instead of recovery catalog allocated channel: t1
channel t1: sid=10 devtype=DISK

Starting backup at 15-AUG-01
released channel: t1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00579: the following error occurred at 08/15/2001 08:57:33
RMAN-03002: failure during compilation of command

RMAN-03013: command type: backup
RMAN-06003: ORACLE error from target database: ORA-06550: line 1, column 166:
PLS-00553: character set name is not recognized ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated RMAN-06031: could not translate database keyword

Recovery Manager complete.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Paul Baumgartel
INET: pbaumgartel_at_mortgagesight.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 Wed Aug 15 2001 - 09:15:10 CDT