linux下自动备份db2脚本。把数据库备份到指定的目录下面并执行压缩,然后删除早期的备份,可以把这个脚本
设置在一个定式任务里面,每天晚上执行一次。
#
!/bin/bash
hostName = `hostname`
MAX_BAKFILE_NUM = 4
db_bak_dir = " /home/db2inst1/data "
if [ ! - d " $db_bak_dir " ] ; then
mkdir $db_bak_dir
fi
su - db2inst1 << eof
db2 force applications all
db2 backup db sino to $db_bak_dir
eof
cd / home / db2inst1 / data
ls - l | sort + 5 - 7 - r |
awk ' $8 ~ /^(SINO)/
{cmd = "tar zcvf " ;
cmd = cmd"B_" ;
cmd = cmd" ' $hostName ' _" ;
cmd = cmd$8".tar.gz" ;
cmd = cmd" "$8;
del_file_cmd = "rm "$8
print cmd ;
system(cmd);
system(del_file_cmd)} ' ;
ls - l | grep ' B_ ' | sort + 5 - 7 - r |
awk ' NR > " ' $MAX_BAKFILE_NUM ' "{ del_cmd = "rm "$8 ;system(del_cmd) } '
hostName = `hostname`
MAX_BAKFILE_NUM = 4
db_bak_dir = " /home/db2inst1/data "
if [ ! - d " $db_bak_dir " ] ; then
mkdir $db_bak_dir
fi
su - db2inst1 << eof
db2 force applications all
db2 backup db sino to $db_bak_dir
eof
cd / home / db2inst1 / data
ls - l | sort + 5 - 7 - r |
awk ' $8 ~ /^(SINO)/
{cmd = "tar zcvf " ;
cmd = cmd"B_" ;
cmd = cmd" ' $hostName ' _" ;
cmd = cmd$8".tar.gz" ;
cmd = cmd" "$8;
del_file_cmd = "rm "$8
print cmd ;
system(cmd);
system(del_file_cmd)} ' ;
ls - l | grep ' B_ ' | sort + 5 - 7 - r |
awk ' NR > " ' $MAX_BAKFILE_NUM ' "{ del_cmd = "rm "$8 ;system(del_cmd) } '