date >> $log_file
# RMAN备份SHELL脚本(rman_backup.sh)
#===========================================================================
# 实现指定级别的增量备份，由用户传入备份级别参数，如果不指参数则进行0级备份
#===========================================================================
#! /bin/bash
. /home/oracle/.bash_profile
if [ $1 ];then
backup_level=$1
else
backup_level=0
fi
backup_user=sys
backup_user_pw=oracle
#catalog_user=rman
#catalog_user_pw=rman
log_file=/home/oracle/rman_backup.log
echo 'Begining rman backup >>>>>>>>>>>>>>>>>>>>>>>>>>' >> $log_file
date >> $log_file
su - oracle >> $log_file << EOF
rman target $backup_user/$backup_user_pw
# catalog $catalog_user/$catalog_user_pw
backup incremental level = $backup_level database;
EOF
echo 'rman backup finished >>>>>>>>>>>>>>>>>>>>>>>>>' >> $log_file
date >> $log_file
# 逻辑备份SHELL脚本(schema_exp.sh)
#=========================================================================
# EXP对数据库schema对象进行备份，用户可以将需要备份的用户名做为参数传入SHELL脚本
#=========================================================================
#! /bin/bash
BAK_DIR=/disk01/backup/logical_bak/
log_file=/disk01/backup/logical_bak/user_full_bak.log
exp_par="userid=system/oracle buffer=10485760 owner=$1"
if [ $2 ];then
exp_par="$exp_par file=$2"
else
exp_par="$exp_par file="$BAK_DIR/$1_`date +%Y%m%d%H%M`.dmp""
fi
echo "Begining User $1 Export ---------------------" >> $log_file
echo "Export with following parameters: $exp_par" >> $log_file
date >> $log_file
su - oracle -c "exp $exp_par" >> $log_file 2>&1
echo "Backup Finished ---------------------" >> $log_file
date >> $log_file