论坛徽章:: 0

电梯直达

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

发表于 2010-10-19 23:48 |只看该作者 |倒序浏览

本帖最后由 justme_cxq 于 2010-10-21 15:14 编辑

现象：
NBU备份DB2数据库时，数据文件备份正常，但是备份日志文件时报告6号错误。
（1）将client的bp.conf中日志级别设置为VERBOSE=5
（2）在/usr/openv/netbackup/logs目录下创建bpdb2以及bphdb文件夹，并修改权限为777
（3）查看bphdb文件夹下的log文件，发现如下输出：
tk_smscsrv2:/usr/openv/netbackup/logs/bphdb # tail -f log.101910
14:28:21.166 [4726] <4> bphdb do_backup: INF - Keepalives will be sent every 150 seconds.
14:28:21.166 [4726] <4> bphdb do_backup: INF - Waiting for the child status.
14:28:21.167 [4727] <4> bphdb do_backup: INF - Child executing /usr/openv/db2_backup
14:30:43.648 [4726] <16> bphdb do_backup: ERR - Script exited with status = 4 <archive file removal failed>
14:30:43.648 [4726] <8> delete_old_files: WRN - Directory /usr/openv/netbackup/logs/bpdbsbdb2 does not exist
14:30:43.648 [4726] <8> delete_old_files: WRN - Directory /usr/openv/netbackup/logs/bpubsdb2 does not exist
14:30:43.648 [4726] <16> bphdb Exit: ERR - bphdb exit status = 6: the backup failed to back up the requested files

14:30:43.648 [4726] <4> bphdb Exit: INF - EXIT STATUS 6: the backup failed to back up the requested files
（4）查看bphdb文件下的out文件，发现如下输出：
DB2_CLIENT = VAS_SMSC
DB2_SERVER = NBUMASTER
DB2_POLICY = VAS_SMSC_DB2
DB2_SCHED = VAS_SMSC_DB2
DB2_FULL = 1
DB2_CINC = 0
DB2_INCR = 0
Executing: db2 BACKUP DATABASE smcdb  online LOAD /usr/openv/netbackup/bin/nbdb2.so OPEN 4 SESSIONS BUFFER 1024
SQL0911N  The current transaction has been rolled back because of a deadlock
or timeout.  Reason code "68".  SQLSTATE=40001