#按照策略进行备份，这里设置一个星期中的每一天的备份级别
#!/bin/bash
# rman.sh:
# This program is used to backup database ,carrying out backup's strategy.
#
# How to use this shell script
# cd /home/orapord/scripts/DB;sh rman.sh 2>/home/oraprod/output/rman_`date +%m%d%y`.error.log
#
#
# Authors:
#
# History:
#

. /u01/prod/oraprod/proddb/9.2.0/PROD_erp.env
PATH=$PATH:/home/oraprod/proddb/9.2.0/appsutil/scripts/PROD_erp
export PATH;
weekN=`date |awk '{print $1}'`
dateN=`date +\%m\%d\%y`
pathN=/home/oraprod
retain=/u02/retain
prodrman=/u02/prodrman
export weekN dateN pathN retain prodrman

cd $pathN/scripts/DB

case $weekN in

"Sun")
echo "Starting Incremental Level 0 Backup"
sh dbL0.sh 2>$pathN/output/dbL0_$dateN.error.log
sh movebackupset.sh
;;

"Mon")
echo "Starting Incremental Level 2 Backup"
sh dbL2.sh 2>$pathN/output/dbL2_$dateN.error.log
sh movebackupset.sh
;;

"Tue")
echo "Starting Incremental Level 2 Cumulative Backup"
sh dbL2C.sh 2>$pathN/output/dbL2C_$dateN.error.log
sh movebackupset.sh
;;

"Wed")
echo "Starting Incremental Level 1 Backup"
sh dbL1.sh 2>$pathN/output/dbL1_$dateN.error.log
sh movebackupset.sh
;;

"Thu")
echo "Starting Incremental Level 2 Backup"
sh dbL2.sh 2>$pathN/output/dbL2_$dateN.error.log
sh movebackupset.sh
;;

"Fri")
echo "Starting Incremental Level 2 Cumulative Backup"
sh dbL2C.sh 2>$pathN/output/dbL2C_$dateN.error.log
sh movebackupset.sh
;;

"Sat")
echo "Starting Incremental Level 2 Cumulative Backup"
sh dbL2C.sh 2>$pathN/output/dbL2C_$dateN.error.log
sh movebackupset.sh
;;

*)
echo "This script run failure"
;;

esac
exit 0

再写几个按照备份级别备份数据库的简单脚本，例如：

# Database Incremental Level 0 Backup

rman target / log $pathN/output/dbL0_$dateN.log<<EOF
run
{
backup incremental level 0 tag 'dbL0' database;
sql 'alter system archive log current';
backup archivelog all tag 'dblog' delete all input;
}
exit
EOF

再写一个脚本或者用备份软件把备份集移动到你的存储上就OK了！

这么做确实简单吧！呵呵，

不过很多公司还是使用专业的备份软件来备份数据库，我个人觉得这样做对了解数据库是有好处的。有机会用到的朋友可以效仿一下！

ice feng

2007-07-17 上午11时38分