论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2012-06-20 10:12 |只看该作者 |倒序浏览

本帖最后由 xc5sm 于 2012-06-20 10:14 编辑

Master:win 2008 R2 +NBU7.0
Client: Esxi4.0下的Linux 5.X+Oracle 10g+nbu7.0（rac）
备的是第一个节点。
之前几个月一直能正常备份，前一段时间突然出现备份时，客户端系统就会自动重启，在客户端测试rman备份到本地硬盘能正常备份。切换到备第二个节点rman备到存储上也会自动重启。
数据库平时能正常使用。

hot_database_backup.sh.out 内容如下：

Script /oracle/hot_database_backup.sh
Recovery Manager: Release 10.2.0.5.0 - Production on Sun May 6 22:23:10 2012

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: orc (DBID=4178690871)
using target database control file instead of recovery catalog

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38>
allocated channel: ch00
channel ch00: sid=123 instance=orc1 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.0 (2010010419)

allocated channel: ch01
channel ch01: sid=144 instance=orc1 devtype=SBT_TAPE
channel ch01: Veritas NetBackup for Oracle - Release 7.0 (2010010419)

Starting backup at 06-MAY-12
channel ch00: starting incremental level 1 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00012 name=/oradata/orc/ASIT/TBS_SHSJ.dbf
input datafile fno=00005 name=/oradata/orc/undotbs02.dbf
input datafile fno=00004 name=/oradata/orc/users01.dbf
channel ch00: starting piece 1 at 06-MAY-12
channel ch01: starting incremental level 1 datafile backupset
channel ch01: specifying datafile(s) in backupset
input datafile fno=00013 name=/oradata/orc/ASIT/TBS_SHSJ_INDEX.dbf
input datafile fno=00008 name=/oradata/orc/ASIT/TBS_MH_BASE.dbf
input datafile fno=00010 name=/oradata/orc/ASIT/TBS_ASIT_BASE.dbf
input datafile fno=00003 name=/oradata/orc/sysaux01.dbf
input datafile fno=00002 name=/oradata/orc/undotbs01.dbf
channel ch01: starting piece 1 at 06-MAY-12
channel ch01: finished piece 1 at 06-MAY-12
piece handle=bk_1168_1_782605397 tag=HOT_DB_BK_LEVEL0 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch01: backup set complete, elapsed time: 00:01:25
channel ch01: starting incremental level 1 datafile backupset
channel ch01: specifying datafile(s) in backupset
input datafile fno=00006 name=/oradata/orc/ASIT/TBS_MH_DATA.dbf
input datafile fno=00007 name=/oradata/orc/ASIT/TBS_MH_INDEX.dbf
input datafile fno=00009 name=/oradata/orc/ASIT/TBS_ASIT_DIC.dbf
input datafile fno=00011 name=/oradata/orc/ASIT/TBS_ASIT_INDEX.dbf
input datafile fno=00001 name=/oradata/orc/system01.dbf
channel ch01: starting piece 1 at 06-MAY-12

报800二个月还没有分析出原因，系统重启没有core文件生成。但是用 echo "c" > /proc/sysrq-trigger故意让系统崩溃会产生core文件。

oracle日志中有报错信息，但好像不影响oracle使用，很多这样的报错信息：
Wed May 09 00:49:19 CST 2012
Error 2068 trapped in 2PC on transaction 9.39.52357. Cleaning up.
Error stack returned to user:
ORA-02068: following severe error from IIMSDBLINK
ORA-03135: connection lost contact
Wed May 09 00:49:40 CST 2012
Error 2068 trapped in 2PC on transaction 4.26.50770. Cleaning up.
Error stack returned to user:
ORA-02068: following severe error from LLSMSDBLINK
ORA-03135: connection lost contact

这个帖子发了二遍了，还请有经验的帮帮忙