传了这个脚本得休息了,继续Oracle internal研究,希望能与大家分享交流

hand_ftp.sh

#!/bin/bash

#

#SCRIPT.:FTP_BAK

#AUTHOR:LENG BO

#DATE

#PLATFORM.:LINUX AS4.6

#PURPOSE

#

#REV LIST:

#        DATE:2009-12-03

#        BY:lengbo

#        USAGE:FTP oracle backup to remote backup server

#

BAK='/home/bak/bak'

LOC='/home/bak'

ERR_LOG='/home/bak/err_log'

LOG='/home/bak/log'

LOST='/home/bak/lost'

RMAN_IP='172.20.10.8'

RMAN_SH_LOC='/home/rman/bak_ftp'

RMAN_SH_NAME='ftp_8_bak.sh'

RMAN_BAK_TMP='home/rman/bak_ftp_tmp'

SEV_LOG_TMP='/home/bak/ftp_ser_log_tmp'

if [ ! -d $LOG ];

then mkdir -p $LOG

fi

if [ ! -d $ERR_LOG ];

then mkdir -p $ERR_LOG

fi

#######Make Director of lost files

if [ ! -d $LOST ];

then mkdir -p $LOST

fi

if [ ! -d $SEV_LOG_TMP ];

then mkdir -p $SEV_LOG_TMP

fi

} sh ${RMAN_SH_LOC}/${RMAN_SH_NAME}'

#SSH_WC='ls ${RMAN_BAK_TMP} |wc -l'

#LOC_WC='ls ${BAK} |wc -l'

#REM_CNT=$(SSH_WC)

REM_CNT=$(ssh ls /home/rman/bak_ftp_tmp |wc -l)

#BAK_CNT=$(LOC_WC)

BAK_CNT=$(ls /home/bak/bak |wc -l)

REM_SIZE=$(ssh du -h /home/rman/bak_ftp_tmp |awk ' {print $1}' |sed 's/[A-Z]//')

BAK_SIZE=$(du -h /home/bak/bak/ |awk ' {print $1}' |sed 's/M//')

#echo $REM_CNT

#echo $BAK_CNT

#echo $REM_SIZE

#echo $BAK_SIZE

f_ssh()

{

LOG='/home/bak/log'

SEV_LOG_TMP='/home/bak/ftp_ser_log_tmp'

echo "========This rman client script. logs Details!=======">>$LOG/log

if [ $BAK_CNT -ne 0 ];

then

cd $BAK

mv * $LOST

if [ $? -ne 0 ];

then rm -rf *

fi

fi

ssh

EOF

if [ $? -ne 0 ];

then echo "========This rman client script. executed with errors,Please check it!=======">>$LOG/log

exit 1

else echo "=======This rman client script. executed Succesfully!!!========">>$LOG/log

fi

#mv $LOG/log $LOG/log_$(date +'%F-%H-%M-%S')

}

f_ssh

########Not format '%F-%X',otherwise may occue errors!

#REM_CNT=$(SSH_WC)

REM_CNT=$(ssh ls /home/rman/bak_ftp_tmp |wc -l)

#BAK_CNT=$(LOC_WC)

BAK_CNT=$(ls /home/bak/bak |wc -l)

REM_SIZE=$(ssh du -h /home/rman/bak_ftp_tmp |awk ' {print $1}' |sed 's/[A-Z]//')

BAK_SIZE=$(du -h /home/bak/bak/ |awk ' {print $1}' |sed 's/M//')

#echo $REM_CNT

#echo $BAK_CNT

#echo $REM_SIZE

#echo $BAK_SIZE

f_ser()

{

#if [ $BAK_CNT -ne 0 ];

#   then

#   cd $BAK

#   mv * $LOST

#      if [ $? -ne 0 ];

#         then rm -rf *

#      fi

#fi

if [ $BAK_CNT -ne $REM_CNT ];

then echo "********Check number of between backups succesfully!Remote backups and lock backups is different,whic is expected********">>$LOG/log

if [ $BAK_CNT -eq 0 ];

then echo "********$BAK have one null backups Now to recreate it and ftping it!!!********">>$LOG/log

#                       cd $BAK

#                       mv *  $LOST

#                           if [ $? -ne 0 ];

#                              then echo "********Warnings!Move backups from $BAK to $LOST Failed,Remov it********">>$LOG/log

#                                   rm -rf *

#

#                           else echo "********Congratulations!Move backups from $BAK to $LOST Done!*******">>$LOG/log

#                                   mv $LOG/* $ERR_LOG

#                                   echo "********This is Log of ReExecute $RMAN_SH_NAME,If you see this,That means the quality of Local Ftp server and Rman backups is is OK ********">>$LOG/log

#

cd $LOG

mv * $ERR_LOG

f_ssh

if [ $? -eq 0 ];

then echo "********If you see this,That means the quality of Local Ftp server and Rman backups is is OK ********">>$LOG/log

else echo "********Error to Reexecute $RMAN_SH_NAME.Please check it.Now exiting!!!!!!!!********">>$LOG/log                                                 exit 1

fi

fi

else

echo "********Congratulations!Ready:Remote Rman backups is:$REM_CNT and backup Server is:$BAK_CNT.Redy to check the size between Remote and Local backups!!!********">>$LOG/log

fi

}

f_ser

#############Create f_comp function

f_comp()

{

if [ $REM_SIZE -ne $BAK_SIZE ];

then echo "********Errors!!!Size of Rman backups and Ftp bakckups is not equal!!!Now to hand it ...********">>$LOG/log

echo "*******Wating,Now move bad temp backups from $BAK to $LOST!!!********">>$LOG/log

cd $BAK

mv * $LOST

if [ $? -ne 0 ];

then echo "********Move bad temp backups from $BAK to $LOST Failed!!!Remove bad backups...*********">>$LOG/log

cd $BAK

rm -Rf *

if [ $? -ne 0 ];

then echo "*******Rmove bad temp backups failed,Please check it.Read to exiting!!!*********">>$LOG/log

exit 1

fi

else echo "********Move bad temp backups from $BAK to $LOST Successfully!!!Now follow next f_all to do the next work...********">>$LOG/log

fi

else echo "********OK!The size of rman backups is:$REM_SIZE(M) and Ftp backup Server is:$BAK_SIZE (M).Now to handing the Good backups to its own dir...*********">>$LOG/log

fi

}

f_comp

########Create f_all function

f_all()

{

echo "========This is Server script. logs========">>$LOG/log

echo "********Now Creating backup directory $LOC/bak_$(date +'%F')********">>$LOG/log

DB='/home/bak/bak_db'

echo "********Now Recreate dir $DB/bak in $(date +'%F-%H-%M-%S')!!!********">>$LOG/log

if [ ! -d $DB/bak ];

then mkdir -p $DB/bak

if [ $? -ne 0 ];

then echo "********Create dir $DB/bak in $(date +'%F-%H-%M-%S') Failed.Now Recreate it...********">>$LOG/log

mkdir -p mkdir -p $DB/bak

if [ $? -ne 0 ];

then echo "********Recreate dir $DB/bak in $(date +'%F-%H-%M-%S') Failed.Exiting...********">>/$LOG/log

exit 1

else echo "********Recreate dir $DB/bak in $(date +'%F-%H-%M-%S') Successfully!********">>$LOG/log

fi

else echo "********Create backup directory $DB/bak in $(date +'%F-%H-%M-%S') Successfully!********">>$LOG/log

fi

fi

echo "********Now move $BAK temp backup to DB backup dir $DB/bak_$(date +'%F-%H-%M-%S')!!!...********">>$LOG/log

cd $BAK

mv *  $DB/bak

if [ $? -ne 0 ];

then echo "********Errors when moving $BAK temp_backup dir to DB_backup dir $DB/bak_$(date +'%F-%H-%M-%S'),Now hand it...*********">>$LOG/log

cd $BAK

mv * $DB

if [ $? -ne 0 ];

then rm -rf *

if [ $? -ne 0 ];

then echo "********Remove bad temp bakcups in Ftp Server  at $BAK,Now to Exsiting...*********">>$LOG/log

exit 1

fi

else

echo "********Successfully Move bad temp backups in Ftp Server to $DB ,Now to recreate rman backups and Ftping...*********">>$LOG/log

f_ser

if [ $? -ne 0 ];

then echo "*********Recreate Rman backups Filed!!!Existing...********">>$LOG/log

exit 1

fi

f_comp

if [ $? -ne 0 ];

then echo "*********Recreate Rman backups Filed!!!Existing...********">>$LOG/log

exit 1

fi

fi

fi

mv $DB/bak $DB/bak_$(date +'%F-%H-%M-%S')

if [ $? -eq 0 ];

then echo "********Rename $DB/bak to $DB/bak_$(date +'%F-%H-%M-%S') Successfully!!!">>$LOG/log

else echo "********Rename $DB/bak to $DB/bak_$(date +'%F-%H-%M-%S') Failed.Now handing it...Please waiting..........">>$LOG/log

cd $DB/bak

mv * $DB

if [ $? -ne 0 ];

then echo "********Handing backup from $DB/bak to $DB Done!!!Now to next step........">>$LOG/log

else echo "********Handing backup from $DB/bak to $DB Failed!!!Now to Clear $DB/bak and Recreate rman backup and FTping.........">>$LOG/log

f_ssh

f_comp

fi

fi

echo "********Now to move $LOG/log_$(date +'%F-%H-%M-%S') to Remote log Server!!!...********">>$LOG/log

cd $LOG

echo "========Script. end without error...!!!========">>$LOG/log

mv log log_$(date +'%F-%H-%M-%S')

scp $LOG/log_$(date +'%F-%H-%M-%S')

if [ $? -ne 0 ];

then echo "********Error when moving /share/ftp_sev_log to Remote log Server!!!,Saving it as error_log">>$LOG/log_$(date +'%F-%H-%M-%S')

cd $LOG

mv * $ERR_LOG

else

cd $LOG

mv * $ERR_LOG

fi

}

f_all

#######Ssh to rman to ftp backups

#if [ ! -d $LOC/ftp_up_log ];

#   then mkdir -p /$LOC/ftp_up_log

#fi

#

#ssh sh /home/oracle/ftp_shell/ftp_223_bak.sh

#

#if [ $? -eq 0 ];

#   then move $LOC/ftp_up_log/ftp_up.log $LOC/ftp_up_log/ftp_up.log_$(date +'%F-%X')

#   more $LOC/ftp_up_log/ftp_up.log_$(date +'%F-%X')>>$LOG_LOC/log_$(date +'%F-%X')

#

#else echo "********Ftp_up.sh Failed!,Please check it quickly!********">>$LOG_LOC/log_$(date +'%F-%X')

#fi

#

########Check the number of backups between Oracle and Ftp Server

#

#RMAN_CNT='$(ssh ls /rman/ora_rman |wc -l)'

#if [ $RMAN_CNT -ne $BAK_CNT ];

#   then echo "********Warnings!Rman backups is not the same as Backup Server backups,Please Check it!">>$LOG_LOC/log_$(date +'%F-%X')

#   exit 1

#

#fi

#

#

#

#

######Move new backups to its own directory

#mv $LOC/bak/*  $LOC/bak_$(date +'%F')

#

#if [ $? -ne 0 ];

#   then echo "********Warings!Move backups to $LOC/bak_$(date +'%F') Failed,Please check it!********">>$ERR_LOC/err_log_$(date +'%F-%X')

#

#else echo "********Congratualations!Move all backups to $LOC/bak_$(date +'%F' Done!********">>$LOG_LOC/log_$(date +'%F-%X')

#fi

#

#   more $LOC/ftp_up_log/ftp_up.log_$(date +'%F-%X')>>$

#

#echo "********Ftp and move new backups to its own directory Done!">>$LOG_LOC/log_$(date +'%F-%X')

通过这个脚本可以实现在无须第3放备份软件下也能实现对数据库的异地备份,因为该脚本有很多重传以及校验功能,花了俺几天时间呢合乎

优秀是种习惯,习惯也是一种优秀