##在root用户中执行下面脚本,把当天的备份和归档日志上传到ftp,并删除本地过期的日志和备份
#!/bin/sh
su - dbname -c "db2 backup db dbname online to /home/dbname/dbname_bak compress" #备份数据库
#清除10天以前的归档日志和备份文件
su - dbname -c "sh /home/dbname/script/dbname_log_bak_del.sh" #清理过期备份(引用上一篇文章中的脚本)
sleep 90
#把昨天的dbname备份放到创建的/bak_script/dbname_tmp中
mkdir /bak_script/dbname_tmp
sleep 5
find /home/dbname/dbname_bak -name "*" -type f -mtime -1 -exec cp {} /bak_script/dbname_tmp \;
#把dbname备份上传到/DB2_BAK/dbname/dbname_bak
sleep 5
ftp -i -n -v << FTPIT
open 192.168.11.66
user ftp_name ftp_passwd
binary
cd /DB2_BAK/dbname/dbname_bak
lcd /bak_script/dbname_tmp
mput *
by
FTPIT
#删除/bak_script/dbname_tmp
rm -rf /bak_script/dbname_tmp
################################################
#把昨天的dbname归档日志放到/bak_script/dbname_tmp中
mkdir /bak_script/dbname_tmp
sleep 5
find /home/dbname/dbname_archive_log/db2inst3/dbname/NODE0000/C0000000 -name "*" -type f -mtime -1 -exec cp {} /bak_script/dbname_tmp \;
#把dbname归档日志上传到/DB2_BAK/dbname/dbname_archive_log
sleep 5
ftp -i -n -v << FTPIT
open 192.168.11.66
user ftp_name ftp_passwd
binary
cd /DB2_BAK/dbname/dbname_archive_log
lcd /bak_script/dbname_tmp
mput *
by
FTPIT
#清空/bak_script/dbname_tmp
rm -rf /bak_script/dbname_tmp