中小型数据库备份恢复方案

欢迎进入Oracle社区论坛，与200万技术人员互动交流 >>进入 4、创建RMAN备份shell脚本 [python] oracle@BKDB01p:/u02/database/common/rman_scripts more db_bak_rman_catalog.sh ##=========================================================== ## File nam

欢迎进入Oracle社区论坛，与200万技术人员互动交流 >>进入

4、创建RMAN备份shell脚本
[python]
oracle@BKDB01p:/u02/database/common/rman_scripts> more db_bak_rman_catalog.sh
##===========================================================
## File name: db_bak_rman_catalog.sh
## Usage: db_bak_rman_catalog.sh <$ORACLE_SID>
## Desc:
## The script uses to backup database with level 0.
##============================================================
#!/bin/bash
# User specific environment and startup programs
if [ -f ~/.bash_profile ];
then
. ~/.bash_profile
fi
# --------------------------
# Check SID
# --------------------------
if [ -z "${1}" ];then
echo "Usage: "
echo " `basename $0` ORACLE_SID"
exit 1
fi
# -------------------------------
# Set environment here
# -------------------------------
ORACLE_SID=${1}; export ORACLE_SID
TIMESTAMP=`date +%Y%m%d%H%M`; export TIMESTAMP
LOG_DIR=/u02/database/${ORACLE_SID}/backup export LOG_DIR
RMAN_LOG=${LOG_DIR}/${ORACLE_SID}_bak_${TIMESTAMP}.log
SSH_LOG=${LOG_DIR}/${ORACLE_SID}_bak_full_${TIMESTAMP}.log
MAIL_DIR=/users/oracle/sendEmail-v1.56
MAIL_FM=oracle@BKDB01p
RETENTION=5
echo "----------------------------------------------------------------" 》${SSH_LOG}
echo "Step 1. Start rman to backup at `date`." 》${SSH_LOG}
echo "----------------------------------------------------------------" 》${SSH_LOG}
$ORACLE_HOME/bin/rman log=${RMAN_LOG} 《EOF
connect target sys/xxx@${ORACLE_SID}
connect catalog rman_user/xxx@CATADB
resync catalog;
run {execute global script global_inc0;}
exit;
EOF
RV=$?
cat ${RMAN_LOG}》${SSH_LOG}
echo "" 》${SSH_LOG}
echo "=====>MSG1: RMAN backup end at `date`." 》${SSH_LOG}
if [ $RV -ne "0" ]; then
echo "" 》${SSH_LOG}
echo "=====>MSG2: RMAN backup error at `date`." 》${SSH_LOG}
$MAIL_DIR/sendEmail -f $MAIL_FM -u "Failed RMAN backup for $ORACLE_SID on `hostname`." -t dba@12306.com -o message-file=${SSH_LOG}
exit
else
echo "" 》${SSH_LOG}
echo "=====>MSG2: No error found during RMAN backup peroid at `date`" 》${SSH_LOG}
rm -rf ${RMAN_LOG} 2>/dev/null
fi
echo "-------------------------------------------------------------------------" 》${SSH_LOG}
echo "Step 2. Start ftp backupset to backup server at `date`." 》${SSH_LOG}
echo "-------------------------------------------------------------------------" 》${SSH_LOG}
SRC_DB_BAK_DIR=/u02/database/${ORACLE_SID}/flash_recovery_area/${ORACLE_SID}
SRC_ADD=10.1.2.101
TARG_DB_BAK_DIR=/u02/database/${ORACLE_SID}/flash_recovery_area
RSYN_LOG=${LOG_DIR}/rsync_${TIMESTAMP}.log
# rsync is used to ftp backup set to bak server.
rsync -avzSH --progress --delete-after oracle@${SRC_ADD}:${SRC_DB_BAK_DIR} ${TARG_DB_BAK_DIR} >${RSYN_LOG} 2>&1
RV=$?
cat ${RSYN_LOG}》${SSH_LOG}
if [ $RV -ne "0" ]; then
echo "" 》${SSH_LOG}
echo "=====>MSG3: FTP backupset error at `date`." 》${SSH_LOG}
MAIL_SUB="Failed archive log sync for $ORACLE_SID on `hostname` at `date`."
$MAIL_DIR/sendEmail -f $MAIL_FM -u $MAIL_SUB -t dba@12306.com -o message-file=${SSH_LOG}
exit
else
echo "" 》${SSH_LOG}
echo -e "=====>MSG3: No error found during FTP peroid." 》${SSH_LOG}
rm -rf $FTP_LOG 2>/dev/null
fi
echo "-------------------------------------------------------------------------" 》${SSH_LOG}
echo "Step 3. RMAN backup and ftp backupset finished at `date`." 》${SSH_LOG}
echo "-------------------------------------------------------------------------" 》${SSH_LOG}
MAIL_SUB="Sucessful completed for ${ORACLE_SID} RMAN backup and ftp backupset at `date`."
$MAIL_DIR/sendEmail -f $MAIL_FM -u $MAIL_SUB -t dba@12306.com -o message-file=${SSH_LOG}
# ------------------------------------------------
# Removing files older than $RETENTION parameter
# ------------------------------------------------
find ${LOG_DIR} -name "*.*" -mtime +$RETENTION -exec rm {} \;
exit
5、自动FTP archivelog脚本
[python]
oracle@BKDB01p:/u02/database/common/rman_scripts> more autoftp_arch.sh
#!/bin/bash
ORACLE_SID=${1}; export ORACLE_SID
TIMESTAMP=`date +%Y%m%d%H%M`; export TIMESTAMP
LOG_DIR=/u02/database/${ORACLE_SID}/backup
#Define FTP variable
SRC_DB_BAK_DIR=/u02/database/${ORACLE_SID}/archive
SRC_ADD=10.1.2.101
TARG_DB_BAK_DIR=/u02/database/${ORACLE_SID}
RSYN_LOG=${LOG_DIR}/rsync_arc_${TIMESTAMP}.log
RSYN_ERR_LOG=${LOG_DIR}/rsync_arc_${TIMESTAMP}_err.log
rsync -avzSH --progress --delete-after oracle@${SRC_ADD}:${SRC_DB_BAK_DIR} ${TARG_DB_BAK_DIR} >${RSYN_LOG} 2>${RSYN_ERR_LOG}
RV=$?
if [ ! -s ${RSYN_ERR_LOG} ];then
rm -rf ${RSYN_ERR_LOG} 2>/dev/null
else
mail -s "Failed FTP archive log for $ORACLE_SID on `hostname`" dba@12306.com <${SYN_ERR_LOG}
fi
exit
6、部署备份脚本到crontab
如果你的数据库比较少，则直接将上面的备份脚本与自动FTP archivelog脚本部署到crontab.
如果你的数据库比较多，建议将上面的脚本封装到另外的一个文件，然后部署到crontab.
如下面的full_bak_by_rman.sh实际上是包含了多个db_bak_rman_catalog.sh <$ORACLE_SID> ,后面的多个full开头的使用类是的原理。
#Rman backup and restore database
0 1 * * 1-6 /u02/database/common/rman_scripts/full_bak_by_rman.sh
0 3 * * 1-6 /u02/database/common/rman_scripts/full_resotre_by_rman.sh #这个是用来还原的脚本
#Auto ftp archive log from prod to bak server
*/16 7-20 * * 1-6 /u02/database/common/rman_scripts/full_autoftp_arch.sh

[1] [2]