中小型数据库RMAN CATALOG备份恢复方案(二)(二)
tal=`cat ${REV_DIR}/ck_restore.log |wc -l`
suc=`grep SUCCEED ${REV_DIR}/ck_restore.log |wc -l`
fail=`grep FAILED ${REV_DIR}/ck_restore.log |wc -l`
echo "">>ck_restore.log
echo -e "The total DB of current recovery is $total in `hostname` \n">>${REV_DIR}/ck_restore.log
echo -e "The number of succee is : ${suc} \n">>${REV_DIR}/ck_restore.log
echo -e "The number of fail is : ${fail} \n">>${REV_DIR}/ck_restore.log
mail -s "RMAN restore summary for `hostname` at `date +'%a %b %d %Y'`" dba@12306.com <${REV_DIR}/ck_restore.log
3、部署还原shell脚本到crontab
[python] --首先将多个需要自动restore的DB封装到一个单独的文件，如下： --最后调用ck_restore.sh 脚步检测所有DB restore状态并发送RMAN summary report邮件 $ more full_resotre_by_rman.sh #!/bin/bash /u01/comm_scripts/db_restore_rman_catalog.sh BC1200 /u01/comm_scripts/db_restore_rman_catalog.sh AF2630 /u01/comm_scripts/ck_restore.sh --部署到crontab --注，无论是备份还是恢复脚本，我们都是通过Bak server的crontab来部署以减轻Prod的压力 #Rman restore database 0 3 * * 1-6 /u01/comm_scripts/full_resotre_by_rman.sh