From pbaumgartel@mortgagesight.com Wed, 15 Aug 2001 07:15:10 -0700 From: Paul Baumgartel Date: Wed, 15 Aug 2001 07:15:10 -0700 Subject: RE: RMAN cold backups continued Message-ID: MIME-Version: 1.0 Content-Type: text/plain I found the problem--O/S enviroment variable NLS_LANG must be set. Thanks. Paul Baumgartel MortgageSight Holdings, LLC pbaumgartel@mortgagesight.com -----Original Message----- Sent: Wednesday, August 15, 2001 9:10 AM To: 'ORACLE-L@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@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@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@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).