RMAN Failures

From: E_T <ecstatic_troll_at_yahoo.com>
Date: 14 Mar 2004 13:19:09 -0800
Message-ID: <47f47291.0403141319.4c977bf4@posting.google.com>

Hello all,

We recently moved our RMAN catalog from one dying server to another machine. I did a full cold backup and restore, copied all the datafiles, controlfiles, etc.

Now, when we're trying to run RMAN backup, we get the following errors:

/********* ERROR MESSAGES

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS

RMAN-00571: ===========================================================
RMAN-03015: error occurred in stored script backup_db_full
RMAN-03015: error occurred in stored script backup_al_all
RMAN-03002: failure during compilation of command

RMAN-03013: command type: backup
RMAN-06004: ORACLE error from recovery catalog database: ORA-00600: internal error code, arguments: [15419], [severe error during PL/SQL execution], [], [], [], [], [], []
ORA-06544: PL/SQL: internal error, arguments: [77303], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [77303] RMAN-06097: text of failing SQL statement: declare thread number ; sequence number ; recid number ; alRec dbms_rcvman . alRec_t ; begin dbms_rcvman . getArchivedLog ( alRec => alRec ) ; if ( :stopthr = alRec . thread and alRec . sequence >= to_number ( :stopseq ) ) then
:flag := 1 ; else :flag := 0 ; :key:key_i := alRec . key ;
:recid:recid_i := alRec . recid ; :stamp:stamp_i := alRec . stamp ;
:thread := alRec . thread ; :sequence := alRec . sequence ;
:fileName:fileName_i := alRec . fileName ; :lowSCN := alRec . lowSCN ;
:lowTime := alRec . lowTime

RMAN-06099: error occurred in source file: krmk.pc, line: 22632

END ERROR MESSAGES ***********/ I'm not quite sure what's going on... The backup seems to go alright. The whole backup log is posted at the end of this message.

Has anyone seen this before, or have any ideas as to what it (or me) is doing wrong? Should I just go and recreate a new catalogue?

Thanks!
E_T

Full Backup Log:

Recovery Manager: Release 8.1.7.4.0 - Production

RMAN-06005: connected to target database: DBH0H0 (DBID=3754273486) RMAN-06008: connected to recovery catalog database

RMAN> run {

2> execute script backup_db_full;
3> }
4>

RMAN-03021: executing script: backup_db_full

RMAN-03021: executing script: alloc_1_tape

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=18 devtype=SBT_TAPE
RMAN-08526: channel t1: MMS Version 2.2.0.1

RMAN-03022: compiling command: set limit RMAN-03023: executing command: set limit

RMAN-03021: executing script: set_maxcorrupt

RMAN-03022: compiling command: set

RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel t1: starting full datafile backupset
RMAN-08502: set_count=1406 set_stamp=520779414 creation_time=14-MAR-04
RMAN-08010: channel t1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00001

name=/u01/data/oradata/dbh0h0/system01.dbf RMAN-08011: including current controlfile in backupset RMAN-08522: input datafile fno=00005
name=/u01/data/oradata/dbh0h0/dbh0h0tbl.dbf RMAN-08522: input datafile fno=00003
name=/u01/data/oradata/dbh0h0/dr01.dbf
RMAN-08522: input datafile fno=00004
name=/u01/data/oradata/dbh0h0/indx01.dbf RMAN-08522: input datafile fno=00007
name=/u01/data/oradata/dbh0h0/temp01.dbf RMAN-08013: channel t1: piece 1 created
RMAN-08503: piece handle=df_t520779414_s1406_p1 comment=API Version 1.1,MMS Version 2.2.0.1

RMAN-08525: backup set complete, elapsed time: 00:00:46
RMAN-08008: channel t1: starting full datafile backupset
RMAN-08502: set_count=1407 set_stamp=520779460 creation_time=14-MAR-04
RMAN-08010: channel t1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00009

name=/u01/data/oradata/dbh0h0/users01.dbf RMAN-08522: input datafile fno=00002
name=/u01/data/oradata/dbh0h0/budbh0h0.dbf RMAN-08522: input datafile fno=00006
name=/u01/data/oradata/dbh0h0/rbs01.dbf
RMAN-08522: input datafile fno=00008
name=/u01/data/oradata/dbh0h0/tools01.dbf RMAN-08013: channel t1: piece 1 created
RMAN-08503: piece handle=df_t520779460_s1407_p1 comment=API Version 1.1,MMS Version 2.2.0.1

RMAN-08525: backup set complete, elapsed time: 00:00:25
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete

RMAN-03021: executing script: rel_1_tape

RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: t1

RMAN-03021: executing script: archive_log_current

RMAN-03022: compiling command: sql
RMAN-06162: sql statement: alter system archive log current
RMAN-03023: executing command: sql

RMAN-03021: executing script: backup_al_all

RMAN-03021: executing script: alloc_1_tape

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=18 devtype=SBT_TAPE
RMAN-08526: channel t1: MMS Version 2.2.0.1

RMAN-03022: compiling command: set limit RMAN-03023: executing command: set limit

RMAN-03022: compiling command: backup
RMAN-03025: performing implicit partial resync of recovery catalog
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS

RMAN-00571: ===========================================================
RMAN-03015: error occurred in stored script backup_db_full
RMAN-03015: error occurred in stored script backup_al_all
RMAN-03002: failure during compilation of command

Recovery Manager complete. Received on Sun Mar 14 2004 - 15:19:09 CST