Unix shell 自动 FTP 备份档案

使用shell脚本实现对Oracle数据库的监控与管理将大大简化DBA的工作负担，如常见的对实例的监控，监听的监控，告警日志的监控，以及数据库的备份，AWR report的自动邮件等。本文给出Linux 下使用 shell 脚本来实现自动FTP备份档案。Linux Shell以及导入导出的相关参考：Linux/Unix shell 脚本中调用SQL,RMAN脚本 http://www.linuxidc.com/Linux/2012-09/70310.htmLinux/Unix shell sql 之间传递变量 http://www.linuxidc.com/Linux/2013-01/78811.htmLinux Unix shell 调用 PL/SQL http://www.linuxidc.com/Linux/2013-01/78810.htm1、Linux/Unix shell 自动 FTP 脚本robin@SZDB:~/dba_scripts/custom/bin> more auto_ftp_dump.sh
# +---------------------------------------------------+
# + Filename: ftp_dump_auto.sh |
# + Desc: Ftp the dump file automatically |
# + Usage: |
# + ./auto_ftp_dump.sh $ORACLE_SID |
# + Author: Robinson |
# + Blog : http://blog.csdn.net.robinson-0612 |
# +---------------------------------------------------+
#
#！/bin/bash
#
# -----------------------------
# Define environment variable
# -----------------------------
#if [ -f ~/.bash_profile ];
then
. ~/.bash_profile
fi# --------------------------
# Check SID
# --------------------------if [ -z "${1}" ];then
echo "Usage: "
echo " `basename $0` ORACLE_SID"
exit 1
fiORACLE_SID=${1}; export ORACLE_SID
TARGET_SID=SY0755BK
TIMESTAMP=`date +%Y%m%d%H%M`;
DT=`date +%Y%m%d`;
RETENTION=1DUMP_DIR=/u01/oracle/admin/SY0755/BNR/dump
DUMP_FILE=${DUMP_DIR}/EXP_${ORACLE_SID}_${DT}.dmp
LAST_EXP_DUMP_LOG=${DUMP_DIR}/EXP_${ORACLE_SID}_${DT}.logFTP_LOG=${DUMP_DIR}/ftp_${ORACLE_SID}_${TIMESTAMP}.log
FTP_ERR_LOG=${DUMP_DIR}/ftp_${ORACLE_SID}_${TIMESTAMP}_err.logdate >>${FTP_LOG}
echo "FTP source : ${ORACLE_SID}" >>${FTP_LOG}
echo "FTP target : ${TARGET_SID}" >>${FTP_LOG}
echo "Staring tar the dump file " >>${FTP_LOG}# -------------------------
# tar the dump file
# -------------------------if [ -s "${DUMP_FILE}" ] && [ -s "${LAST_EXP_DUMP_LOG}" ];then
cd ${DUMP_DIR}
tar -czvf EXP_${ORACLE_SID}_${DT}.tar.gz ./EXP_${ORACLE_SID}_${DT}.？？？
else
echo "Dump file does not exist for ${ORACLE_SID}" >>${FTP_LOG}
MAIL_SUB="Dump files were not found for ${ORACLE_SID} on `hostname` before start to tar the dump file"
mail -s $MAIL_SUB dba@trade.com <${FTP_LOG}
exit 1
fi# --------------------------------------------
# config ftp parameter and ftp the dump file
# --------------------------------------------if [ ！ -s "${DUMP_DIR}/EXP_${ORACLE_SID}_${DT}.tar.gz" ];then
echo "The dump files were not compressed before start ftp">>${FTP_LOG}
MAIL_SUB=" The dump files were not compressed for ${ORACLE_SID} on `hostname` before start ftp, exit！"
mail -s $MAIL_SUB dba@trade.com <${FTP_LOG}
exit 1
fiecho "Start copy tar file to ${TARGET_SID} ...." >>${FTP_LOG}
echo "--------------------------------------------------">>${FTP_LOG}FTP_SRV=10.200.48.21
FTP_USR=oracle
FTP_PWD=oracle
FTP_LOCAL_PATH=${DUMP_DIR}
FTP_REMOTE_PATH=/u02/database/${TARGET_SID}/BNR/dumpftp -nv >> $FTP_LOG <<EOF
open ${FTP_SRV}
user ${FTP_USR} ${FTP_PWD}
binary
cd ${FTP_REMOTE_PATH}
lcd ${FTP_LOCAL_PATH}
prompt
mput EXP_${ORACLE_SID}_${DT}.tar.gz
close
bye
EOFRC=$？
flag=`cat ${FTP_LOG} | grep -i "receive OK" | grep -v grep`
if [ -z "${flag}" ] || [ "${RC}" -ne 0 ] ; then
echo "FTP tar file to ${TARGET_SID} failed" >>${FTP_LOG}
MAIL_SUB="FTP dump file from ${ORACLE_SID} to ${TARGET_SID} failed, please check ！"
mail -s $MAIL_SUB dba@trade.com <${FTP_LOG}
exit 1
else
echo "End ftp dump file to ${TARGET_SID} ...." >> ${FTP_LOG}
echo "End ftp time at:" `date` --`date +%Y%m%d%H%M` >>${FTP_LOG}
echo "">>${FTP_LOG}
echo "-------------------------- End of the log file -----------------------">>${FTP_LOG}
MAIL_SUB="FTP the dump file from ${ORACLE_SID} to ${TARGET_SID} completed successful."
mail -s $MAIL_SUB dba@trade.com <${FTP_LOG}
fifind ${DUMP_DIR} -name "*ftp*" -mtime +$RETENTION -exec rm {} ;
find ${DUMP_DIR} -name "EXP_${ORACLE_SID}*.gz" -mtime +$RETENTION -exec rm {} ;exit

Linux/Unix shell 自动导入Oracle数据库Oracle 11g导出空表方法相关资讯 LinuxShell Unix shell

UNIX shell获取IP和修改IP （08/07/2014 07:04:13）
Unix Shell脚本编程知识点总结及范（05/27/2013 13:13:34）
HP UNIX shell得到5分钟前的时间（03/30/2013 08:58:19）

Unix考古记:一个“遗失”的shell （06/08/2013 11:39:56）
Linux/Unix shell 脚本监控磁盘可（05/08/2013 06:19:39）
Linux/Unix shell 自动发送AWR （03/10/2013 19:40:50）

本文评论查看全部评论（0）