2008年10月23日星期四

AIX下一个完整的QAD备份方案

目标:1 星期1-6再线备份 并按日期生成备份文件
   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 <open 192.168.1.16 (IP)
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

AIX 下动态扩展空间

chfs -a size=+*G 扩充路径

2008年10月22日星期三

AIX下把每天备份的程序自动转存到其它机器

1目标机器上开启FTP及用户名

2 在AIX的SCRIPTS先建立个文件如BACK内容如下
cd /backup/db/ol`date +%y%m%d` /进入备份文件目录/
ftp -n <open IP /输入备份文件目标的机器IP就是你要转存的机器/
user 用户 密码 /输入用户名密码/
bin /使用二进制文件传输方式/
prompt
mput *
bye
EOF

3 输入CRONTAB -E 加入行如
00 06 * * * /app/scripts/BACK /每天6点自动执行/