求助：用rman备份时，alert.log报错

lau1984

我写了一个脚本，用rman在凌晨做数据库全备，alert.log报错如下，但是有没有错误代码，请大家帮忙分析一吧！
Wed Mar 17 00:52:45 2010
Starting control autobackup
Wed Mar 17 00:52:46 2010
Errors in file /oracle/app/product/10.2.0/db_1/admin/tom/udump/tom_ora_10452.trc:
Wed Mar 17 00:52:46 2010
Errors in file /oracle/app/product/10.2.0/db_1/admin/tom/udump/tom_ora_10452.trc:
Wed Mar 17 00:52:46 2010
Errors in file /oracle/app/product/10.2.0/db_1/admin/tom/udump/tom_ora_10452.trc:
Control autobackup written to DISK device
        handle '/oracle/rmanbackup/ctlfile/20100317_c-1858817530-20100317-00'
Wed Mar 17 00:52:50 2010
Thread 1 advanced to log sequence 176
  Current log# 2 seq# 176 mem# 0: /oracle/app/product/10.2.0/db_1/oradata/tom/redo02.log
Thread 1 advanced to log sequence 177
  Current log# 3 seq# 177 mem# 0: /oracle/app/product/10.2.0/db_1/oradata/tom/redo03.log
Wed Mar 17 00:52:57 2010
Starting control autobackup
Wed Mar 17 00:52:58 2010
Errors in file /oracle/app/product/10.2.0/db_1/admin/tom/udump/tom_ora_10452.trc:
Wed Mar 17 00:52:58 2010
Errors in file /oracle/app/product/10.2.0/db_1/admin/tom/udump/tom_ora_10452.trc:
Wed Mar 17 00:52:58 2010
Errors in file /oracle/app/product/10.2.0/db_1/admin/tom/udump/tom_ora_10452.trc:
Control autobackup written to DISK device
        handle '/oracle/rmanbackup/ctlfile/20100317_c-1858817530-20100317-01'
在贴上上面红色字体的trace文件的内容
/oracle/app/product/10.2.0/db_1/admin/tom/udump/tom_ora_10452.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /oracle/app/product/10.2.0/db_1
System name:    Linux
Node name:      tom-host
Release:        2.6.9-42.ELsmp
Version:        #1 SMP Wed Jul 12 23:27:17 EDT 2006
Machine:        i686
Instance name: tom
Redo thread mounted by this instance: 1
Oracle process number: 21
Unix process pid: 10452, image: [email=oracle@tom-host]oracle@tom-host[/email] (TNS V1-V3)
*** 2010-03-17 00:52:46.852
*** ACTION NAME0000021 STARTED111) 2010-03-17 00:52:46.822
*** MODULE NAMEbackup full datafile) 2010-03-17 00:52:46.822
*** SERVICE NAMESYS$USERS) 2010-03-17 00:52:46.822
*** SESSION ID1071.201) 2010-03-17 00:52:46.822
*** 2010-03-17 00:52:58.819
*** ACTION NAME0000042 STARTED111) 2010-03-17 00:52:58.819
*** MODULE NAMEbackup archivelog) 2010-03-17 00:52:58.819

我这是测试库，大家帮帮忙吧！

lau1984

补充上rman脚本和cmdfile的内容

rman 脚本
#!/bin/sh
        export ORACLE_HOME=/oracle/app/product/10.2.0/db_1
        export ORACLE_SID=tom
        LOGFILE="/home/oracle/shell/"
        CMDFILE="/home/oracle/shell/rman_cmd.txt"
        /oracle/app/product/10.2.0/db_1/bin/rman target */* log=$LOGFILE`date +"%Y-%m-%d"`.log cmdfile=$CMDFILE;
cmdfile的内容（就是/home/oracle/shell/rman_cmd.txt）
        run{
        allocate channel c1 device type disk;
        allocate channel c2 device type disk;
        allocate channel c3 device type disk;
        allocate channel c4 device type disk;
        backup as compressed backupset database format '/oracle/rmanbackup/datafile/%T_%U';
        sql 'alter system archive log current';
        backup archivelog all format '/oracle/rmanbackup/arclogfile/%T_%U' delete all input;
        release channel c1;
        release channel c2;
        release channel c3;
        release channel c4;
        }

managergh

There seems to be apparently no problem with the trace file that is getting generated.

However is it the full trace file or have you just pasted the heading of the trace file.

You are correct in interpreting that this is related to the backup.

If this is not the full tracefile you can update the thread with some more information or atleast the call stack part of the trace file.

If this is the full file, then there is nothing much that can be inferred from it, and can be ignored.


应该没什么事 我备份的时候也经常出这东西  

lau1984

thanks managergh，我也刚刚查到了，这是oracle本身的一个bug，bug：4596065。感谢帮忙！

fixlee

学习了