Re: RMAN cold backups continued
living on the bleeding edge are we?,
let me try it on my 9.0.1 and let you know.
joe
[EMAIL PROTECTED] 08/15/01 10:07AM
Thanks to everyone who replied yesterday. It appears I had
already been onthe right track, as I did attempt backups with the database
in noarchivelogmode and mounted but not open.Hot backups, with DB in
archivelog mode, worked fine. However, coldbackups, performed in the
manner stated above, fail (see below) with errorsmentioning "database
keyword" and "character set". This is Oracle 9.0.1 onSolaris.
I'll appreciate any ideas; thanks! Paul
BaumgartelMortgageSight Holdings,
LLC[EMAIL PROTECTED]RMAN shutdown
immediate2 startup mount3 run
{4
allocate channel t1 type
disk;5
backup incremental level
06
format
'/dbbackup/%d/t%t_s%s_p%p'7
database8
;9
release channel t1;10 }11 exitdatabase closeddatabase
dismountedOracle instance shut downconnected to target database (not
started)Oracle instance starteddatabase mountedTotal System
Global Area 235701300 bytesFixed
Size
279604 bytesVariable
Size
167772160 bytesDatabase
Buffers
67108864 bytesRedo
Buffers
540672 bytesusing target database controlfile instead of recovery
catalogallocated channel: t1channel t1: sid=10
devtype=DISKStarting backup at 15-AUG-01released channel:
t1RMAN-00571:
===RMAN-00569:
=== ERROR MESSAGE STACK FOLLOWS ===RMAN-00571:
===RMAN-00579: the
following error occurred at 08/15/2001 08:57:33RMAN-03002: failure during
compilation of commandRMAN-03013: command type: backupRMAN-06003: ORACLE
error from target database: ORA-06550: line 1, column166:PLS-00553:
character set name is not recognizedORA-06550: line 0, column 0:PL/SQL:
Compilation unit analysis terminatedRMAN-06031: could not translate database
keywordRecovery Manager complete.-- Please see the official
ORACLE-L FAQ: http://www.orafaq.com--
Author: Paul Baumgartel INET:
[EMAIL PROTECTED]Fat City Network Services
-- (858) 538-5051 FAX: (858) 538-5051San Diego,
California -- Public Internet access /
Mailing
ListsTo
REMOVE yourself from this mailing list, send an E-Mail messageto:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
you want to be removed from). You mayalso send the HELP command for
other information (like subscribing).
RE: RMAN cold backups continued
I found the problem--O/S enviroment variable NLS_LANG must be set. Thanks.
Paul Baumgartel
MortgageSight Holdings, LLC
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, August 15, 2001 9:10 AM
To: '[EMAIL PROTECTED]'
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
[EMAIL PROTECTED]
RMAN shutdown immediate
2 startup mount
3 run {
4 allocate channel t1 type disk;
5 backup incremental level 0
6format '/dbbackup/%d/t%t_s%s_p%p'
7database
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 Size167772160 bytes
Database Buffers 67108864 bytes
Redo Buffers540672 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
Re: RMAN cold backups continued
running it on 9.0.1 on linux no problems, only change to your
script was location of where to put the files.
i've not doing the controlfile thing, i've got a
repository.
joe
[EMAIL PROTECTED] 08/15/01 10:07AM
Thanks to everyone who replied yesterday. It appears I had
already been onthe right track, as I did attempt backups with the database
in noarchivelogmode and mounted but not open.Hot backups, with DB in
archivelog mode, worked fine. However, coldbackups, performed in the
manner stated above, fail (see below) with errorsmentioning "database
keyword" and "character set". This is Oracle 9.0.1 onSolaris.
I'll appreciate any ideas; thanks! Paul
BaumgartelMortgageSight Holdings,
LLC[EMAIL PROTECTED]RMAN shutdown
immediate2 startup mount3 run
{4
allocate channel t1 type
disk;5
backup incremental level
06
format
'/dbbackup/%d/t%t_s%s_p%p'7
database8
;9
release channel t1;10 }11 exitdatabase closeddatabase
dismountedOracle instance shut downconnected to target database (not
started)Oracle instance starteddatabase mountedTotal System
Global Area 235701300 bytesFixed
Size
279604 bytesVariable
Size
167772160 bytesDatabase
Buffers
67108864 bytesRedo
Buffers
540672 bytesusing target database controlfile instead of recovery
catalogallocated channel: t1channel t1: sid=10
devtype=DISKStarting backup at 15-AUG-01released channel:
t1RMAN-00571:
===RMAN-00569:
=== ERROR MESSAGE STACK FOLLOWS ===RMAN-00571:
===RMAN-00579: the
following error occurred at 08/15/2001 08:57:33RMAN-03002: failure during
compilation of commandRMAN-03013: command type: backupRMAN-06003: ORACLE
error from target database: ORA-06550: line 1, column166:PLS-00553:
character set name is not recognizedORA-06550: line 0, column 0:PL/SQL:
Compilation unit analysis terminatedRMAN-06031: could not translate database
keywordRecovery Manager complete.-- Please see the official
ORACLE-L FAQ: http://www.orafaq.com--
Author: Paul Baumgartel INET:
[EMAIL PROTECTED]Fat City Network Services
-- (858) 538-5051 FAX: (858) 538-5051San Diego,
California -- Public Internet access /
Mailing
ListsTo
REMOVE yourself from this mailing list, send an E-Mail messageto:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
you want to be removed from). You mayalso send the HELP command for
other information (like subscribing).
