shell - ORACLE自动备份并且自动FTP到备份机的SHELL脚本

小咪咪 2022-08-14 03:47 229阅读 0赞

第一个文件：INIT.TXT这是脚本INI初始化文件：  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
\#This is a system ini file :  
\# CopyRight By WangZuXiang 2002  
\# the '\#' is ingnor :  
\#the format style is xxxx=value  
\#  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
  
\#Oracle cionfig  
\[oracle\]  
username=ydyx  
password=ydyx  
con\_alias=MISDB  
  
\#the main machine config  
\[mainhost\]  
myhost\_ip=10.232.193.2  
myhost\_username=oracle  
myhost\_password=oracle  
dump\_dir=/u2/oracleback  
  
\#the backup machine config  
\[backuphost\]  
backhost\_ip=10.232.193.5  
backhost\_username=oracle  
backhost\_password=oracleydyx  
backup\_dir=/u2/oracleshaoshanback  
  
\#delete the dump file x days ago?!!!  
\[deletedumpfile\]  
delete\_days=2  
  
\#the Oracle database's back method  
\#如果start\_tactic=Y 则采用策略备份，否则按每天完全到出  
\#如果采用策略备份，则必须给SYSTEM用户的口令  
\[backmethod\]  
start\_tactic=N  
system\_password=manager11  
  
\#the recode the system execute's log!  
\[systemlog\]  
sys\_log=/home/oracle/wzx/x.log  
\#end  
  
第二个文件：主程序文件：MY.SH：  
\#!/bin/sh  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
\#  
\#Get the all ini file config  
\#CopyRight By WangZuXiang 2002-2005?  
\#版权所有(C) 2002-2005? WangZuXiang .  
\#All Rights Reserved.  
\#program date 2002-10-22  
\#usage: main  
\#This script is used to start oracle dump database .  
\#It should ONLY be executed as part of the crontabs.  
\#function content is:  
\#1:自动检查是否能连上Oracle!  
\#2:通过初始化文本来解析各种需要的参数!  
\#3:自动完全到出ORACLE数据库(每天)!,以后将增加相关的增量备份等!  
\#4:自动删除配置文件中规定的前X天的备份文件!  
\#5:自动将到出文件打包并转存到其他的备份机器上!  
\#6:自动记录程序执行过程中的所有日期信息!  
\#if you find some bugs please send it to my mailpost :  
\#e-mail:wzxherry@sina.com !  
\#new function:增加了对ORACLE数据库备份策略的方法!2002-10-31  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
mypwd=\`pwd\`  
inifile=/home/oracle/wzx/init.txt  
oratab=/etc/oratab  
TEMP=temp.$$  
DUMP\_FILE=\`date +'%Y%m%d\`  
  
initme ()  
\{   
\#read from the config file 'ini.txt'  
  
\#oracle config  
USERNAME=\`cat $\{inifile:-"init.txt"\} | grep -i '^username' | awk -F = '\{print $2\}'\`  
PASSWORD=\`cat $\{inifile:-"init.txt"\} | grep -i '^password' | awk -F = '\{print $2\}'\`  
MY\_ALIAS=\`cat $\{inifile:-"init.txt"\} | grep -i '^con\_alias' | awk -F = '\{print $2\}'\`  
  
\#the main host config  
MYHOST\_IP=\`cat $\{inifile:-"init.txt"\} | grep -i '^myhost\_ip' | awk -F = '\{print $2\}'\`  
MYHOST\_USERNAME=\`cat $\{inifile:-"init.txt"\} | grep -i '^myhost\_username' | awk -F = '\{print $2\}'\`  
MYHOST\_PASSWORD=\`cat $\{inifile:-"init.txt"\} | grep -i '^myhost\_password' | awk -F = '\{print $2\}'\`  
DUMP\_DIR=\`cat $\{inifile:-"init.txt"\} | grep -i '^dump\_dir' | awk -F = '\{print $2\}'\`  
  
\#the backup host config  
BACKHOST\_IP=\`cat $\{inifile:-"init.txt"\} | grep -i '^backhost\_ip' | awk -F = '\{print $2\}'\`  
BACKHOST\_USERNAME=\`cat $\{inifile:-"init.txt"\} | grep -i '^backhost\_username' | awk -F = '\{print $2\}'\`  
BACKHOST\_PASSWORD=\`cat $\{inifile:-"init.txt"\} | grep -i '^backhost\_password' | awk -F = '\{print $2\}'\`  
BACKUP\_DIR=\`cat $\{inifile:-"init.txt"\} | grep -i '^backup\_dir' | awk -F = '\{print $2\}'\`  
  
\#the define's delete dump file days!  
DAYS=\`cat $\{inifile:-"init.txt"\} | grep -i '^delete\_days' | awk -F = '\{print $2\}'\`  
\#to get the system log  
LOGS=\`cat $\{inifile:-"init.txt"\} | grep -i '^sys\_log' | awk -F = '\{print $2\}'\`  
TACTIC=\`cat $\{inifile:-"init.txt"\} | grep -i '^start\_tactic' | awk -F = '\{print $2\}'\`  
SYSTEMPASS=\`cat $\{inifile:-"init.txt"\} | grep -i '^system\_password' | awk -F = '\{print $2\}'\`  
  
\#read the config file end.  
\}  
  
\#WHOAMI=\`id | awk '/uid=\[0-9\]\*(oracle)/ \{print $1\}'\`  
\#WHOAMI=\`id | awk '\{print $1\}' | sed 's/uid=\[0-9\]\*(.\*).\*/1/'\`  
WHOAMI=\`id | sed 's/uid=\[0-9\]\*(.\*) gid.\*/1/'\`  
\#if test "$WHOAMI" = "" ; then  
if test "$WHOAMI" != "(oracle)" ; then  
echo " "  
echo "=============================================================="  
echo "=========you must use oracle user to run this script!========="  
echo "=============================================================="  
echo " "  
exit 0  
fi  
  
\#run the init parameter  
test ! -e $inifile && echo "not find the init file:"$inifile"!" && exit 0  
  
initme  
  
if \[ -z $LOGS \]; then  
echo "<<can not to find the define of system log...!!!>>"  
fi  
  
\#LOG = $\{LOGS:-"x.log"\}  
LOGME="tee -a $\{LOGS:-"x.log"\}"  
  
if \[ -e $LOGS -a -f $LOGS \]; then  
if test ! -w $LOGS; then  
echo "<<the log file:"$LOGS" can not to write!....................>>"  
exit  
fi  
fi  
  
echo " " | $LOGME  
echo "-----------------------------------------------------------------" | $LOGME  
echo "<<system now is initing ..............!>>" | $LOGME  
  
\#check the parameter value  
if \[ -z $USERNAME \]; then  
echo "<<the oracle database's username is null..............!>>" | $LOGME  
exit 1  
fi  
  
if \[ -z $PASSWORD \]; then  
echo "<<the oracle database's password is null..............!>>" | $LOGME  
exit 2  
fi  
  
if \[ -z $MY\_ALIAS \]; then  
echo "<the oracle connect alias is null!..............>>" | $LOGME  
exit 0  
fi  
  
if \[ -z $MYHOST\_IP \]; then  
echo "<<the oracle's host ip is null..............!>>" | $LOGME  
exit 3  
fi  
  
if \[ ! -d $DUMP\_DIR \]; then  
echo "<the oracle's dump dir is not exist..............!>>" | $LOGME  
exit 0  
fi  
  
if \[ -z $MYHOST\_USERNAME \]; then  
echo "<<then oracle host username is null..............!>>" | $LOGME  
exit 4  
fi  
  
if \[ -z $MYHOST\_PASSWORD \]; then  
echo "<<the oracle host password is null..............!>>" | $LOGME  
exit 5  
fi  
  
if \[ -z $BACKHOST\_IP \]; then  
echo "<<the backup host's ip is null..............!>>" | $LOGME  
exit 6  
fi  
  
if \[ -z $BACKHOST\_USERNAME \]; then  
echo "<<the backup host's uesername is null..............!>>" | $LOGME  
exit 7  
fi  
  
if \[ -z $BACKHOST\_PASSWORD \]; then  
echo "<<the backup host's password is null..............!>>" | $LOGME  
exit 8  
fi  
  
if \[ -z $BACKUP\_DIR \]; then  
echo "<<the backup host's backup dir is null..............!>>" | $LOGME  
exit 9  
fi  
\#elif \[ ! -e $BACKUP\_DIR -o ! -d $BACKUP\_DIR \]; then  
\#echo "<<the backup dir "$BACKUP\_DIR" is not exist or is not directory..............!>>" | $LOGME  
\#exit 0  
\#fi  
  
\#if \[ ! -O $BACKUP\_DIR \]; then  
\#echo "<<the backup host's backup dir is not owner to oracle..............!>>" | $LOGME  
\#exit 0  
\#fi  
  
if \[ -z $DAYS \]; then  
echo "<<the delete file define days is null so not to delete...............!>>" | $LOGME  
fi  
  
if test $TACTIC = "Y" ; then  
if test -z $SYSTEMPASS ; then  
echo "<<if you use TACTIC back,then you must give the oracle system password!...............!>>" | $LOGME  
exit 0  
fi  
fi  
  
if test $? -eq 0 ; then  
echo "<<system init is OK............................!>>" | $LOGME  
fi  
  
\#check end.  
\#  
\#main  
\#  
  
if \[ ! -f $oratab -o ! -e $oratab \]; then  
echo "<<the oracle define's oratab file is not normal file or is not exist..............!>>" | $LOGME  
exit 0  
fi  
  
ORACLE\_SID=\`cat $oratab | grep -v "^\#" | grep "Y$" | awk -F : '\{print $1\}' \`  
if \[ -z $ORACLE\_SID \]; then  
echo "<<the ORACLE\_SID is not find ..............!>>" | $LOGME  
exit -1  
fi  
export ORACLE\_SID  
ORACLE\_HOME=\`cat $oratab | grep -v "^\#" | grep "Y$" | awk -F : '\{print $2\}' \`  
if \[ ! -d $ORACLE\_HOME \]; then  
echo "the oracle's home directory "$ORACLE\_HOME" is not exist..............!>>" | $LOGME  
exit -1  
fi  
export ORACLE\_HOME  
PATH=$PATH:$ORACLE\_HOME/bin:/usr/lib:/bin:$HOME/bin:.  
ORACLE\_BASE=/u1/app/oracle  
export ORACLE\_BASE  
ORACLE\_SID=misdb  
export ORACLE\_SID  
ORACLE\_HOME=$ORACLE\_BASE/product/8.1.6  
export ORACLE\_HOME  
PATH=$PATH:$ORACLE\_HOME/bin  
export PATH  
LIBPATH=$LIBPATH:$ORACLE\_HOME/lib  
export LIBPATH  
ORA\_NLS33=$ORACLE\_HOME/ocommon/nls/admin/data  
export ORA\_NLS33  
export PATH  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
\#\# begin to dump the database  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
  
\#trying to connect oracle .....  
if \[ -e $TEMP \]; then  
rm -f $TEMP  
if \[ ! $? -eq 0 \]; then  
echo "<<delete the file: "$TEMP" is fail..............!!!!>>" | $LOGME  
exit -1  
fi  
fi  
  
if \[ -x $ORACLE\_HOME/bin/tnsping \]; then  
\#$ORACLE\_HOME/bin/tnsping $MY\_ALIAS > $TEMP  
tnsping $MY\_ALIAS > $TEMP  
ME=\`cat $TEMP | grep "OK" | awk '\{print $1\}'\`  
if \[ "$ME" != "OK" \]; then  
echo "<<can not to connect oracle by tnsping:"$MY\_ALIAS"..............!>>" | $LOGME  
rm -f $TEMP  
exit $?  
else  
echo "<<connect oracle is ok!...............................!>>" | $LOGME  
fi  
fi  
  
rm -f $TEMP  
  
if \[ -x $ORACLE\_HOME/bin/exp \]; then  
\#MY\_ALIAS  
\#cd $ORACLE\_HOME/bin  
\#if \[ ! $? -eq 0 \]; then  
\#echo "error "  
\#exit 0  
\#fi  
  
trap "" 1 2 3 15  
  
\#如果不用策略备份,则采用倒用户的方式,到出!!!!  
\#echo $TACTIC  
\#  
\#if \[ "$TACTIC" = "Y" \]; then  
\#if \[ -x $ORACLE\_HOME/bin/svrmgrl \]; then  
\#svrmgrl <<EOF  
\#connect $USERNAME/$SYSTEMPASS@$MY\_ALIAS  
\#exit  
\#EOF  
\#if test $? -ne 0 ; then  
\#echo "<<SYSTEM user password is error!.................>>" | $LOGME  
\#exit $?  
\#fi  
\#fi  
\#fi  
\#  
  
if \[ "$TACTIC" != "Y" -o "$TACTIC" != "y" \]; then  
echo "<<系统将按倒出用户方式进行!..............................>>" | $LOGME  
$ORACLE\_HOME/bin/exp $USERNAME/$PASSWORD@$MY\_ALIAS buffer=40960 file=$DUMP\_DIR/$DUMP\_FILE.dmp owner=$USERNAME grants=Y rows=Y compress=Y indexes=Y log=$DUMP\_DIR/$DUMP\_FILE.log  
  
\#采用策略备份,则对整个数据库进行策略备份!  
  
else  
echo "<<系统将按策略备份用户方式进行!..............................>>" | $LOGME  
MYWEEK=\`date | awk '\{print $1\}'\`  
case $MYWEEK in  
\#星期一完全导出  
Mon)exp system/$SYSTEMPASS@$MY\_ALIAS inctype=complete buffer=40960 file=$DUMP\_DIR/$DUMP\_FILE.dmp grants=Y rows=Y compress=Y indexes=Y log=$DUMP\_DIR/$DUMP\_FILE.log  
echo "<<Mon is complete dump the db,file:"$DUMP\_FILE.dmp"...............!>>" | $LOGME  
;;  
\#星期二增量导出  
Tue)exp system/$SYSTEMPASS@$MY\_ALIAS inctype=incremental buffer=40960 file=$DUMP\_DIR/$DUMP\_FILE.dmp grants=Y rows=Y compress=Y indexes=Y log=$DUMP\_DIR/$DUMP\_FILE.log  
echo "<<Tue is incremental dump the db,file:"$DUMP\_FILE.dmp"...............!>>" | $LOGME  
;;  
\#星期三增量导出  
Wed)exp system/$SYSTEMPASS@$MY\_ALIAS inctype=incremental buffer=40960 file=$DUMP\_DIR/$DUMP\_FILE.dmp grants=Y rows=Y compress=Y indexes=Y log=$DUMP\_DIR/$DUMP\_FILE.log  
echo "<<Wed is incremental dump the db,file:"$DUMP\_FILE.dmp"...............!>>" | $LOGME  
;;  
\#星期四增量导出  
Thu)exp system/$SYSTEMPASS@$MY\_ALIAS inctype=incremental buffer=40960 file=$DUMP\_DIR/$DUMP\_FILE.dmp grants=Y rows=Y compress=Y indexes=Y log=$DUMP\_DIR/$DUMP\_FILE.log  
echo "<<Thu is incremental dump the db,file:"$DUMP\_FILE.dmp"...............!>>" | $LOGME  
;;  
\#星期五累计导出  
Fri)exp system/$SYSTEMPASS@$MY\_ALIAS inctype=cumulative buffer=40960 file=$DUMP\_DIR/$DUMP\_FILE.dmp grants=Y rows=Y compress=Y indexes=Y log=$DUMP\_DIR/$DUMP\_FILE.log  
echo "<<Fri is cumulative dump the db,file:"$DUMP\_FILE.dmp"...............!>>" | $LOGME  
;;  
\#星期六增量导出  
Sat)exp system/$SYSTEMPASS@$MY\_ALIAS inctype=incremental buffer=40960 file=$DUMP\_DIR/$DUMP\_FILE.dmp grants=Y rows=Y compress=Y indexes=Y log=$DUMP\_DIR/$DUMP\_FILE.log  
echo "<<Sat is incremental dump the db,file:"$DUMP\_FILE.dmp"...............!>>" | $LOGME  
;;  
\#星期日增量导出  
Sun)exp system/$SYSTEMPASS@$MY\_ALIAS inctype=incremental buffer=40960 file=$DUMP\_DIR/$DUMP\_FILE.dmp grants=Y rows=Y compress=Y indexes=Y log=$DUMP\_DIR/$DUMP\_FILE.log  
echo "<<Sun is incremental dump the db,file:"$DUMP\_FILE.dmp"...............!>>" | $LOGME  
;;  
\*)  
;;  
esac   
fi  
  
if test $? -eq 0 -a -s $DUMP\_DIR/$DUMP\_FILE.dmp  
then  
echo "<<dump the oracle database success at: "$DUMP\_FILE"..............!>>" | $LOGME  
else  
echo "<<dump the oracle database fail at: "$DUMP\_FILE"..............!>>" | $LOGME  
exit $?  
fi  
else  
echo "<<sorry!,the exp not to find or not execute,please check it..............!>>" | $LOGME  
exit $?  
fi  
  
\#其实可以用find . -atime -days -exec rm \{\} 删除前DAYS天的备份文件，但查找不是很精确!  
\#if define the days then to execute delete the dump file $DAYS ago!  
if \[ -n $DAYS -a $DAYS -gt 0 \]; then  
echo "<<system will to remove the dump file $DAYS days ago..............!>>" | $LOGME  
if \[ -x $ORACLE\_HOME/bin/svrmgrl \]; then  
svrmgrl <<EOF  
connect $USERNAME/$PASSWORD@$MY\_ALIAS  
spool $TEMP  
select to\_char(sysdate-$DAYS,'yyyymmdd') mydate from dual;  
spool off  
exit  
EOF  
if test $? -eq 0 -a -f $TEMP -a -s $TEMP ; then  
echo "<<get the $DAYS days ago's date is ok..............!>>" | $LOGME  
else  
echo "<<to get $DAYS days ago's date is fail(connect oracle is fail---------)..............!>>" | $LOGME  
\#exit $?  
fi  
else  
echo "<<not find the oracle's svrmgrl program or cant not execute and get the days is fail..............!>>" | $LOGME  
exit $?  
fi  
  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
\#\#  
\#\# Gegin to remove the dump file  
\#\#  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
  
\#TEMPDATE=\`cat $TEMP | sed '1d' | sed '$d' | grep -v '^--\*'\`  
TEMPDATE=\`cat $TEMP | sed '1d' | sed '$d' | sed '/^--\*/d'\`  
\#echo "$TEMPDATE"  
rm -f $TEMP  
if test ! $? -eq 0 ; then  
echo "<<can not to remove the temp file:"$TEMP"..............!>>" | $LOGME  
fi  
\#echo "$\{DUMP\_DIR\}/$\{TEMPDATE\}.dmp"  
if test -e $DUMP\_DIR/$TEMPDATE.dmp -a -f $DUMP\_DIR/$TEMPDATE.dmp -a -n $TEMPDATE; then  
rm -f $DUMP\_DIR/$TEMPDATE.dmp  
rm -f $DUMP\_DIR/$TEMPDATE.log  
rm -f $DUMP\_DIR/$TEMPDATE.tar.Z  
if test $? -eq 0 ; then  
echo "<<remove the "$DUMP\_DIR/$TEMPDATE.dmp" is ok..............!>>" | $LOGME  
else  
echo "<<remove the "$DUMP\_DIR/$TEMPDATE.dmp" is fail..............!>>" | $LOGME  
\#exit $?  
fi  
else  
echo "<<can not to find the file: "$DUMP\_DIR/$TEMPDATE.dmp" ..............!>>" |  
$LOGME  
\#exit $?  
fi  
fi  
  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
\#  
\#to transfer the dump file to other's host user ftp  
\#  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
  
if \[ -e $DUMP\_DIR/$DUMP\_FILE.dmp -a -e $DUMP\_DIR/$DUMP\_FILE.log \]; then  
tar -cvf $DUMP\_DIR/$DUMP\_FILE.tar $DUMP\_DIR/$DUMP\_FILE.dmp $DUMP\_DIR/$DUMP\_FILE.log && compress $DUMP\_DIR/$DUMP\_FILE.tar | $LOGME  
if test $? -eq 0 -a -e $DUMP\_DIR/$DUMP\_FILE.tar.Z ; then  
echo "<<the dump file "$DUMP\_FILE.tar.Z" is archive ok.........!>>" | $LOGME  
rm -f $DUMP\_DIR/$DUMP\_FILE.tar  
rm -f $DUMP\_DIR/$DUMP\_FILE.log  
rm -f $DUMP\_DIR/$DUMP\_FILE.dmp  
if test ! $? -eq 0 ; then  
echo "<<delete the dump file is fail!.........................!>>" | $LOGME  
else  
echo "<<delete the dump file is ok!.........................!>>" | $LOGME  
fi  
else  
echo "<<the dump file "$DUMP\_FILE.tar.Z" is archive fail..........!>>" | $LOGME  
exit $?  
fi  
fi  
  
echo "<<system now is transfering file to $\{BACKHOST\_IP\}..............!>>" | $LOGME  
  
ftp -n $BACKHOST\_IP <<! | $LOGME  
user $BACKHOST\_USERNAME $BACKHOST\_PASSWORD  
bin  
prompt  
put $DUMP\_DIR/$DUMP\_FILE.tar.Z $BACKUP\_DIR/$DUMP\_FILE.tar.Z  
close  
bye  
!  
  
if test $? -eq 0 ; then  
echo "<<Transfer the file:"$DUMP\_DIR/$DUMP\_FILE.tar.Z" to "$BACKHOST\_IP"$BACKUP\_DIR is OK.................! >>" | $LOGME  
else  
echo "<<Transfer the file:"$DUMP\_DIR/$DUMP\_FILE.tar.Z" to "$BACKHOST\_IP"$BACKUP\_DIR is fail..................! >>" | $LOGME  
exit $?  
fi  
  
if test $? -eq 0 ; then  
echo "<<the script is execute finish!,please check it!.......................................!>>" | $LOGME  
echo "-----------------------------------------------------------------" | $LOGME  
exit 0  
fi