Veritas Netbackup 增量备份DB2数据库故障的解决过程

caolifeng

环境:
Veritas Administration Console 5.0MP4 ,安装在Windows2000上;
DB2 8.1.1  FixPak 6 数据库安装在AIX5300-00-00 上;

故障现象:
数据库Online全备份策略执行正常,备份成功!
数据库Online累积增量备份失败,Vertias Nebackup  Status返回值6.

检查DB2 database configuration,设置正确:
trackmod=on
logretain=recovery
userexit=on

检查备份脚本:
#!/bin/sh
echo "DB2_CLIENT = $DB2_CLIENT"
echo "DB2_SERVER = $DB2_SERVER"
echo "DB2_POLICY = $DB2_POLICY"
echo "DB2_SCHED = $DB2_SCHED"
echo "DB2_FULL = $DB2_FULL"     # Is 1 if Full backup scheduled
echo "DB2_CINC = $DB2_CINC"     # Is 1 if Cumulative incremental scheduled
echo "DB2_INCR = $DB2_INCR"     # Is 1 if Differential incremental scheduled

# Change MY_LIB to the correct NetBackup library name for your host:
#       Solaris or Linux 32-bit  = nbdb2.so
#       Solaris 64-bit           = nbdb2.so64
#       AIX or HPUX 32-bit       = nbdb2.sl
#       AIX or HPUX 64-bit       = nbdb2.sl64
MY_LIB=/usr/openv/netbackup/bin/nbdb2.sl

# Change MY_DB2 to the correct DB2 instance name for your database.
MY_DB2=LM51R

# Use the NetBackup schedule type to set DB2 full or incremental options.
if [ "$DB2_FULL" = "1" ] ; then
        MY_SCHED=""
elif [ "$DB2_CINC" = "1" ] ; then
        MY_SCHED="INCREMENTAL"
elif [ "$DB2_INCR" = "1" ] ; then
        MY_SCHED="INCREMENTAL DELTA"
else
        MY_SCHED=""
fi

# Initialize the backup command line.
# Customize the number of sessions and buffer options for your environment.
CMD_LINE1="db2 BACKUP DATABASE MCSR  $MY_SCHED online  LOAD $MY_LIB OPEN 1  SESSIONS BUFFER 1024"

# Change MY_USER to the proper DB2 user for performing backups
MY_USER=db2inst2

echo "Executing: $CMD_LINE"
su - $MY_USER -c "$CMD_LINE1"

初看备份脚本没什么问题,通过试验,发现备份命令参数$MY_SCHED 和online的位置颠倒了,正确的命令是:
db2 BACKUP DATABASE MCSR  online $MY_SCHED   LOAD $MY_LIB OPEN 1  SESSIONS BUFFER 1024
更改后,增量备份测试,成功!

一点疑问:
我的操作系统是64位的,可是备份脚本中引用的Netbackup library 是nbdb2.sh,针对32位系统的,可是所有备份结果却是正常的,让人不可思议!

smithy

这和操作系统有关
64位的操作系统，是可以进行低版本的操作的