传了这个脚本得休息了,继续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

#SSH='rman@{$RMAN_IP}'
#SSH_STR='rman@{$RMAN_IP} 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 rman@172.20.10.8 ls /home/rman/bak_ftp_tmp |wc -l)
#BAK_CNT=$(LOC_WC)
BAK_CNT=$(ls /home/bak/bak |wc -l)
REM_SIZE=$(ssh rman@172.20.10.8 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 rman@172.20.10.8 </home/rman/bak_ftp/ftp_8_bak.sh
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 rman@172.20.10.8 ls /home/rman/bak_ftp_tmp |wc -l)
#BAK_CNT=$(LOC_WC)
BAK_CNT=$(ls /home/bak/bak |wc -l)
REM_SIZE=$(ssh rman@172.20.10.8 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') rman@172.20.10.8:/share/ftp_sev_log
    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 rman@172.20.10.223 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 rman@172.20.10.223 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放备份软件下也能实现对数据库的异地备份,因为该脚本有很多重传以及校验功能,花了俺几天时间呢合乎

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