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
>>> pbaumgartel_at_mortgagesight.com 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,
LLCpbaumgartel_at_mortgagesight.comRMAN> 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:
pbaumgartel_at_mortgagesight.comFat City Network Services
-- (858) 538-5051 FAX: (858) 538-5051San Diego,
California -- Public Internet access /
Mailing
Lists--------------------------------------------------------------------To
REMOVE yourself from this mailing list, send an E-Mail messageto:
ListGuru_at_fatcity.com (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).
Received on Wed Aug 15 2001 - 09:54:34 CDT
