Oracle自動(dòng)備份腳本

#!/bin/sh
#******************************************************************
# File: oraclebak.sh
# Creation Date: 2014/1/22 17:57:32
# Last Modified: 2014/1/22 17:57:34
# 腳本功能:oracle備份腳本
# 執(zhí)行方法:1、第一次執(zhí)行需要root用戶執(zhí)行，腳本會(huì)以詢問(wèn)的方式創(chuàng)建備份目錄和相關(guān)參數(shù)
# 2、腳本會(huì)自動(dòng)寫(xiě)入crontab調(diào)度里面定時(shí)執(zhí)行，crontab設(shè)置是在第一次執(zhí)行的時(shí)候自動(dòng)添加的
#******************************************************************
echo $USER
if [ $USER != root ]
then
echo "檢測(cè)到安裝用戶不是root用戶，請(qǐng)用root用戶登錄再執(zhí)行安裝文件"
exit 1
fi
echo "開(kāi)始安裝oracle數(shù)據(jù)庫(kù)備份工具.........................."
echo "請(qǐng)輸入備份程序的安裝目錄："
read installdir
mkdir -p $installdir
result=$?
while [ $result -ne 0 ]
do
echo "無(wú)法創(chuàng)建目錄，請(qǐng)重新輸入或退出安裝。輸入y重新輸入，輸入n退出安裝。"
read redo
if [ $redo != y ]
then
echo "用戶退出安裝。"
exit 0
fi
echo "請(qǐng)輸入備份程序的安裝目錄："
read installdir
mkdir $installdir
result=$?
done
echo "安裝目錄創(chuàng)建完成。"
echo "請(qǐng)輸入執(zhí)行備份用戶(一般為oracle用戶)："
read execuser
id $execuser
result=$?
while [ $result -ne 0 ]
do
echo "不存在該用戶，是否更換其它用戶或者退出安裝新建用戶，輸入y更換用戶，輸入n退出安裝"
read redo
if [ $redo != y ]
then
echo "用戶退出安裝"
exit 0
fi
echo "請(qǐng)輸入執(zhí)行備份的用戶(一般為tnmsdb2用戶)"
read execuser
id $execuser
result=$?
done
echo "你希望建立備份的數(shù)據(jù)庫(kù)數(shù)量(一般為1)"
read backnum
if [ $backnum -eq 0 ]
then
echo "無(wú)備份數(shù)據(jù)庫(kù)，退出安裝"
exit 0
fi
scount=0
while [ $scount -lt $backnum ]
do
echo "請(qǐng)輸入第"$(($scount+1))"個(gè)備份登錄登錄oracle數(shù)據(jù)庫(kù)的用戶名和密碼，以及本地服務(wù)名"
echo "用戶名"
read username[$scount]
echo "密碼"
read password[$scount]
echo "服務(wù)名"
read sname[$scount]
su -l -c"sqlplus /nolog" $execuserinsert
whenever sqlerror exit sql.sqlcode;
connect ${username[$scount]}/${password[$scount]}@${sname[$scount]}
exit
insert
result=$?
if [ $result -ne 0 ]
then
echo "輸入數(shù)據(jù)庫(kù)信息無(wú)法被連接，是否重新輸入？輸入y重新輸入，輸入n退出安裝。"
read redo
if [ $redo != y ]
then
echo "用戶退出安裝"
exit 0
fi
else
scount=$(($scount+1))
fi
done
echo "輸入值守時(shí)間，值守時(shí)間的格式為 mm hh dd MM E 。"
echo "m代表分鐘，h代表小時(shí)，d代表日期，M代表月份，E代表星期"
echo "不輸入則為任意時(shí)間"
scount=0
iscontinue=y
while [ $iscontinue == y ]
do
echo "輸入第$(($scount+1))個(gè)值守時(shí)間"
echo "分鐘"
read min
echo "小時(shí)"
read hour
echo "日期"
read day
if [ ! $day ]
then
day="*"
fi
echo "月份"
read mouth
if [ ! $mouth ]
then
mouth="*"
fi
week="*"
backtime[$scount]="$min $hour $day $mouth $week"
echo -e "${backtime[$scount]}"
echo "是否輸入更多值守時(shí)間？輸入y繼續(xù)，輸入n進(jìn)入下一步。"
read iscontinue
scount=$(($scount+1))
done
echo "是否要進(jìn)行遠(yuǎn)程備份？輸入y為進(jìn)行遠(yuǎn)程備份，輸入n進(jìn)入下一步"
scount=0
read iscontinue
while [ $iscontinue == y ]
do
echo "請(qǐng)選擇遠(yuǎn)程備份類(lèi)型，輸入s為sftp備份類(lèi)型，否則為ftp備份類(lèi)型"
read iss
if [ $iss == s ]
then
rtype[$scount]="sftp"
else
rtype[$scount]="ftp"
fi
echo "請(qǐng)輸入遠(yuǎn)程備份地址，可以為域名，計(jì)算機(jī)名或者ip地址"
read rurl[$scount]
echo "請(qǐng)輸入遠(yuǎn)程備份登錄名"
read rname[$scount]
echo "請(qǐng)輸入遠(yuǎn)程備份登錄密碼"
read rpass[$scount]
echo "是否輸入更多遠(yuǎn)程備份地址？輸入y重新輸入，n進(jìn)入下一步"
read iscontinue
scount=$(($scount+1))
done
# installdir
# execuser
# username password sname
# backtime
# rtype rurl rname rpass
echo "您所作的備份配置如下："
sresult=$(echo -n "$installdir" | grep '^/')
if [ ! $sresult ]
then
installdir="$PWD/$installdir"
else
installdir=$installdir
fi
echo "本地備份目錄為$installdir"
echo "執(zhí)行備份系統(tǒng)用戶為$execuser"
echo "系統(tǒng)備份數(shù)據(jù)庫(kù)："
allcount=${#username[@]}
scount=0
while [ $scount -lt $allcount ]
do
echo "${username[$scount]}/${password[$scount]}@${sname[$scount]}"
scount=$(($scount+1))
done
echo "執(zhí)行備份的值守時(shí)間表，*代表任意"
scount=0
backnum=${#backtime[@]}
while [ $scount -lt $backnum ]
do
echo "${backtime[$scount]}"
scount=$(($scount+1))
done
rnum=${#rtype[@]}
if [ $rnum -ne 0 ]
then
echo "遠(yuǎn)程備份的服務(wù)地址為:"
scount=0
while [ $scount -lt $rnum ]
do
echo "連接方式:${rtype[$scount]},連接地址:${rurl[$scount]},用戶名:${rname[$scount]},密碼:${rpass[$scount]}"
scount=$(($scount+1))
done
fi
echo "是否確認(rèn)安裝？輸入y繼續(xù)，輸入n退出安裝"
read isgoon
if [ $isgoon != y ]
then
exit 0;
fi
echo "正在生產(chǎn)目錄結(jié)構(gòu)................................";
mkdir -p $installdir/logs
mkdir -p $installdir/temp
mkdir -p $installdir/zip
chown -Rvf $execuser $installdir
echo "目錄結(jié)構(gòu)生成完成................................"
echo "生成備份執(zhí)行文件................................"
echo "#!/bin/bash">$installdir/runback.sh
echo "source ~/.bash_profile">>$installdir/runback.sh
echo "nowdate=\$(date +%Y-%m-%d_%k.%M.%S)">>$installdir/runback.sh
echo "nowmouth=\$(date +%Y-%m)">>$installdir/runback.sh
echo "echo \"\$nowdate開(kāi)始備份.......................................\">>$installdir/logs/\$nowmouth.log">>$installdir/runback.sh
scount=0
snum=${#username[@]}
while [ $scount -lt $snum ]
do
echo "exp ${username[$scount]}/${password[$scount]}@${sname[$scount]} file=$installdir/temp/${username[$scount]}_${sname[$scount]}\$nowdate.dmp compress=N>>$installdir/logs/\$nowmouth.log 2>1">>$installdir/runback.sh
scount=$(($scount+1))
done
echo "echo \"\$(date +%Y-%m-%d_%k.%M.%S)完成備份.......................................\">>$installdir/logs/\$nowmouth.log">>$installdir/runback.sh
echo "echo \"\$(date +%Y-%m-%d_%k.%M.%S)開(kāi)始打包.......................................\">>$installdir/logs/\$nowmouth.log">>$installdir/runback.sh
echo "gzip $installdir/zip/\$nowdate.zip $installdir/temp/>>$installdir/logs/\$nowmouth.log 2>1">>$installdir/runback.sh
echo "rm -Rvf $installdir/temp/*>>$installdir/logs/\$nowmouth.log 2>1">>$installdir/runback.sh
echo "echo \"\$(date +%Y-%m-%d_%k.%M.%S)打包完成.......................................\">>$installdir/logs/\$nowmouth.log">>$installdir/runback.sh
scount=0
if [ ${#rtype[@]} -ne 0 ]
then
echo "echo \"\$(date +%Y-%m-%d_%k.%M.%S)進(jìn)行遠(yuǎn)程備份.......................................\">>$installdir/logs/\$nowmouth.log">>$installdir/runback.sh
snum=${#rtype[@]}
while [ $scount -lt $snum ]
do
echo "lftp -u ${rname[$scount]},${rpass[$scount]} ${rtype[$scount]}://${rurl[$scount]}remote">>$installdir/runback.sh
echo "mkdir remotedbback">>$installdir/runback.sh
echo "cd remotedbback">>$installdir/runback.sh
echo "mput $installdir/zip/\$nowdate.zip">>$installdir/runback.sh
echo "exit">>$installdir/runback.sh
echo "remote">>$installdir/runback.sh
scount=$(($scount+1))
done
echo "echo \"\$(date +%Y-%m-%d_%k.%M.%S)完成遠(yuǎn)程備份.......................................\">>$installdir/logs/\$nowmouth.log">>$installdir/runback.sh
fi
echo "exit 0">>$installdir/runback.sh
chmod 775 $installdir/runback.sh
chown $execuser $installdir/runback.sh
echo "生成備份執(zhí)行文件完成............................"
echo "開(kāi)始定制值守時(shí)間................................"
scount=0
snum=${#backtime[@]}
while [ $scount -lt $snum ]
do
echo "${backtime[$scount]} $installdir/runback.sh">>$installdir/planlist
scount=$(($scount+1))
done
su -l -c"crontab $installdir/planlist" oracle
echo "完成值守時(shí)間定制................................"
exit 0

#!/bin/sh 
export ORACLE_BASE=/home/oracle 
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1 
export ORACLE_SID=orcl 
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin 
export DATA_DIR=/home/bakup/data 
export LOGS_DIR=/home/bakup/logs 
export DELTIME=`date -d "7 days ago" +%Y%m%d` 
export BAKUPTIME=`date +%Y%m%d%H%M%S` 
mkdir -p $DATA_DIR 
mkdir -p $LOGS_DIR 
echo "Starting bakup..." 
echo "Bakup file path $DATA_DIR/$BAKUPTIME.dmp" 
exp shop/lyisABC0987@orcl file=$DATA_DIR/$BAKUPTIME.dmp log=$LOGS_DIR/$BAKUPTIME.log 
echo "Delete the file bakup before 7 days..." 
rm -rf $DATA_DIR/$DELTIME*.dmp 
rm -rf $LOGS_DIR/$DELTIME*.log 
echo "Delete the file bakup successfully. " 
echo "Bakup completed."