关于oracle 10g备份shell脚本求助

stevenzhen

#!/bin/bash
# Author: stevenluo(stevenzhen <at> gmail.com)
fulllog=/u01/fulllog
echo "1---Full backup database"
echo "2---Incremental backup database"
echo "3---Recover database"
echo "4---Backup list"
echo "5---Recover list"
echo -e "Input number 1-5: \c"
read number
case "$number" in
1)
rman target / >$fulllog<<EOF
backup database;
exit
EOF
;;
2)
./rman.sh
;;
3)
rman target / >>$fulllog<<EOF
shutdown immediate;
startup mount;
restore database;
recover database;
alter database open;
exit
EOF
;;
4)
rman target / <<EOF
list backup;
exit
EOF
;;
5)

esac
echo "Backup is Ok"
基本上可以了,具体怎么恢复以及备份在rman里设置
rman.sh
#/bin/bash
d=$(date | awk '{print $1}')
#week=(Mon,Tue,Sat)
log=/u01/rman.log
echo "Beginning rman backup ...." > $log
case "$d" in
Sun)
rman target / >$log <<EOF
backup incremental level 0 database;
exit
EOF
;;
Med)
rman target / >$log <<EOF
backup incremental level 1 database;
exit
EOF
;;
*)
rman target / >$log <<EOF
backup incremental level 2 database;
exit
EOF
;;
esac
echo "Backup is OK"

[ 本帖最后由 stevenzhen 于 2009-3-9 11:32 编辑 ]

stevenzhen

没有AIX环境测试,只在linux bash环境通过,希望能帮到楼主

stevenzhen

怎么备份要看楼主rman里的参数,参数设置好了,全备和增量,完全可以满足,但是恢复比较麻烦点,看楼主要实现那些功能了,这只是最简单的了.

stevenzhen

不是来要分的,我刚学SHELL不到一个月,增加练习而已