DB2自动备份，并上传到ftp

##在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