2 自动恢复到测试数据库中
3 星期7停数据完整备份
4 每天自动把备份文件转到其它机器上
步骤
1在/APP/SCRIPTS/建立PROBACKUP文件内容作用再线备份数据库
cd /backup/db
mkdir -m 777 ol`date +%y%m%d`
cd ol`date +%y%m%d`
mk -m 777 `date +%y%m%d`backuplist
echo `date +%y%m%d`02 >> `date +%y%m%d`backuplist
echo `date +%y%m%d`03 >> `date +%y%m%d`backuplist
echo `date +%y%m%d`04 >> `date +%y%m%d`backuplist
echo `date +%y%m%d`05 >> `date +%y%m%d`backuplist
echo `date +%y%m%d`06 >> `date +%y%m%d`backuplist
echo `date +%y%m%d`07 >> `date +%y%m%d`backuplist
echo `date +%y%m%d`08 >> `date +%y%m%d`backuplist
echo `date +%y%m%d`09 >> `date +%y%m%d`backuplist
echo `date +%y%m%d`10 >> `date +%y%m%d`backuplist
date >> /app/scripts/logs/probkup.log
/app/progress/91e/bin/probkup online /app/mfgpro/eb21/db/(数据库名称) `date +%y%m%d`0
1 < `date +%y%m%d`backuplist -vs 200000 >> /app/scripts/logs/probkup.log
2 在/APP/SCRIPTS/建立PROREST(作用恢复到BUFF数据库)
cd /app/mfgpro/eb21/dbbuff
rm -rf /app/mfgpro/eb21/dbbuff/mfgbuff*.b*
rm -rf /app/mfgpro/eb21/dbbuff/mfgbuff*.d*
rm -rf /app/mfgpro/eb21/dbbuff/mfgbuff*.l*
echo /backup/db/ol`date +%y%m%d`/`date +%y%m%d`02 >> restlist
echo /backup/db/ol`date +%y%m%d`/`date +%y%m%d`03 >> restlist
echo /backup/db/ol`date +%y%m%d`/`date +%y%m%d`04 >> restlist
echo /backup/db/ol`date +%y%m%d`/`date +%y%m%d`05 >> restlist
echo /backup/db/ol`date +%y%m%d`/`date +%y%m%d`06 >> restlist
echo /backup/db/ol`date +%y%m%d`/`date +%y%m%d`07 >> restlist
echo /backup/db/ol`date +%y%m%d`/`date +%y%m%d`08 >> restlist
echo /backup/db/ol`date +%y%m%d`/`date +%y%m%d`09 >> restlist
echo /backup/db/ol`date +%y%m%d`/`date +%y%m%d`10 >> restlist
date >> /app/scripts/logs/prorestbuff.log
/app/progress/91e/bin/prorest /app/mfgpro/eb21/dbbuff/mfgbuff /backup/db/ol`date
+%y%m%d`/`date +%y%m%d`01 <>> /app/scripts/logs/prorestbuff.log
3 在/APP/SCRIPTS/建立PROCOPYDB(作用全备数据库)
/app/progress/91e/bin/procopy /app/mfgpro/eb21/db/mfgprod /backup/db/mfgprod > /backup/db/procopy`date +%y%m%d`.log/app/progress/91e/bin/procopy /app/mfgpro/eb21/db/admprod /backup/db/admprod >>/backup/db/procopy`date +%y%m%d`.log/app/progress/91e/bin/procopy /app/mfgpro/eb21/db/hlpprod /backup/db/admprod >>/backup/db/procopy`date +%y%m%d`.log
4在/APP/SCRIPTS/建立truncatebi(作用全备后truncatebi数据库)
/app/progress/91e/bin/proutil /app/mfgpro/eb21/db/mfgprod -C truncate bi >> /app/scripts/logs/prodtruncate.log
5在/APP/SCRIPTS/建立probackup(作用转存)
ftp -n <
user 用户 密码
bin
prompt
mput *
bye
EOF
6输入CRONTAB -E 加入执行时间
05 00 * * 1-6 /app/scripts/PROBACKUP
25 01 * * 1-6 /app/mfgpro/eb21/stop.buff
30 01 * * 1-6 /app/scripts/PROREST
25 04 * * 1-6 /app/mfgpro/eb21/start.buff
05 01 * * 0 /app/mfgpro/eb21/stop.buff
15 01 * * 0 /app/mfgpro/eb21/stop.buff
30 01 * * 0 /app/scripts/PROCOPYDB
15 05 * * 0 /app/scripts/truncatebi
05 06 * * 0 /app/mfgpro/eb21/start.buff
15 06 * * 0 /app/mfgpro/eb21/start.buff
00 07 * * * /app/scripts/probackup