Rman备份的shell脚本

mkdir ${BACKUP_TARGET}
fi
#if ! test -d ${TABLESPACE_TARGET}
#then
# echo "-----没有备份目录，自动创建-----" >>${LOG_TARGET}/${LogDate}.log
# mkdir ${TABLESPACE_TARGET}
echo "Parameter - 2 （二级增量备份）"
echo "Parameter - 3 （三级增量备份）"
echo "Parameter - 4 （四级增量备份）"
echo "------------------------------------------------"
echo "Command : full （备份整个数据库）"
export ORACLE_BASE=/opt/oracle9i
export ORACLE_HOME=$ORACLE_BASE/product/9.2.0
export ORACLE_SID=back1
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
Psw=sys
DataBase=back2
#恢复目录用户，表空间与数据库名
RmanTs=rman_ts
RmanUser=rman
RmanPsw=rman
RmanDB=test2
#echo "-----------备份服务器设置完成-------------"
#参数校验
if [ "p"$1 = "p/?" ]
echo "Command : listdb （显示数据库备份历史记录）"
echo "------------------------------------------------"
# echo "Command : arclog （备份归档日志并删除）"
# echo "------------------------------------------------"
#then
# echo "-----没有备份目录，自动创建-----" >>${LOG_TARGET}/${LogDate}.log
# mkdir ${CTRFILE_TARGET}
#fi
#if ! test -d ${ARCLOG_TARGET}
#then
echo "Command : full （备份整个数据库）"
echo "------------------------------------------------"
echo "Command : listts （显示表空间备份历史记录）"
echo "------------------------------------------------"
Rman备份的shell脚本
#Set oracle path
#source $HOME/.keychain/${HOSTNAME}-sh
export SSH_AUTH_SOCK
echo $SSH_AUTH_SOCK
export PATH
unset USERNAME
export LD_ASSUME_KERNEL=2.4.1
export CTRFILE_TARGET=${BACKUP_TARGET}/ctrfile
#export ARCLOG_TARGET=${BACKUP_TARGET}/arclog
export LOG_TARGET=${BACKUP_BASE}/log
#echo "--------备份脚本环境变量设置完成---------"
tห้องสมุดไป่ตู้en
echo "Usage:rman_db.sh Command"
echo "------------------------------------------------"
echo "Command : backup (0,1,2,3,4)（备份数据库）"
echo "Parameter - 0 （增量备份的基础策略备份）"
#当前时间
CurDate=`date +%Y-%m-%d_%H:%M:%S`
LogDate=`date +%Y-%m-%d`
#ORACLE用户的用户名
OraUser=oracle
#要备份的表空间变量与登陆数据库的用户
#TableSpace=shiyihai #只在备份表空间时需要
User=sys
echo "------------------------------------------------"
echo "Command : listts （显示表空间备份历史记录）"
echo "------------------------------------------------"
echo "Parameter - 1 （一级增量备份）"
echo "Parameter - 2 （二级增量备份）"
echo "Parameter - 3 （三级增量备份）"
echo "Parameter - 4 （四级增量备份）"
echo "------------------------------------------------"
echo "Command : listdb （显示数据库备份历史记录）"
echo "------------------------------------------------"
#echo "Command : arclog （备份归档日志并删除）"
#echo "------------------------------------------------"
# echo "Command : recoverts （恢复表空间）"
exit
fi
echo "HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH" >>${LOG_TARGET}/${LogDate}.log
exit 1
fi
#------------------------------------------------------------------------------------
#检查文件夹是否存在
if ! test -d ${BACKUP_TARGET}
then
echo "-----没有备份目录，自动创建-----" >>${LOG_TARGET}/${LogDate}.log
#fi
#if ! test -d ${DATABASE_TARGET}
#then
# echo "-----没有备份目录，自动创建-----" >>${LOG_TARGET}/${LogDate}.log
# mkdir ${DATABASE_TARGET}
#fi
#if ! test -d ${CTRFILE_TARGET}
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
#echo "----------脚本搜索环境设置完成----------"
# set the backup script enviroment variable.
#export USERPASS=/nolog
echo "Parameter - 1 （一级增量备份）"
echo "Parameter - 2 （二级增量备份）"
echo "Parameter - 3 （三级增量备份）"
echo "Parameter - 4 （四级增量备份）"
echo "------------------------------------------------"
export BACKUP_BASE=/home/oracle/backup
export BACKUP_TARGET=${BACKUP_BASE}/data
#export TABLESPACE_TARGET=${BACKUP_TARGET}/tablespace
export DATABASE_TARGET=${BACKUP_TARGET}/database
then
echo "Usage:rman_db.sh Command"
echo "------------------------------------------------"
echo "Command : backup (0,1,2,3,4) （增量备份的基础策略备份）"