Oracle/DB2/Postgresql/Mysql/Hadoop/Greenplum/Postgres-xl/Mongodb
分类：
2009-08-13 15:10:42
DB2.9 linux备份脚本(全备)
每天晚上3点执行一次全备,保留一个星期.
备份目录: /mnt/backup/webdb/
0 1 2 3 4 5 6
######### webbackupscripts ###
week=`date +"%w"`
rm -rf /mnt/backup/webdb/$week/*
su - db2inst1 -c "db2stop force"
sleep 3
su - db2inst1 -c "db2start"
su - db2inst1 -c "db2 backup database dbname to /mnt/backup/webdb/$week"
gzip /mnt/backup/webdb/$week/*
