DB2歸檔備份實現方式cv_db2arch.sh

fjzcau發表於2015-05-18
DB2

  1. #!/bin/sh

  3. i_host=`hostname`

  5. i_log=/cvbak/scripts/cv_db2arch_${i_host}.log
  6. echo " " >> $i_log

  8. if [ $# -lt 3 ]
  9. then
  10.   now_time=`date +"%Y%m%d %H:%M:%S"`
  11.   echo "-->0 $now_time" >> $i_log
  12.   echo "Usage: $0 /db2archlog /db2archlog/cv_db2arch flag=1,2" >> $i_log
  13.   exit 1
  14. fi

  16. i_db2arch=$1
  17. i_cv_arch=$2
  18. i_flag=$3

  20. if [ "$i_flag" = "1" -o "$i_flag" = "2" ]
  21. then
  22.   echo "-->1 flag=$i_flag" >> /dev/null
  23. else
  24.   now_time=`date +"%Y%m%d %H:%M:%S"`
  25.   echo "-->2 $now_time" >> $i_log
  26.   echo "-->2 flag=$i_flag" >> $i_log
  27.   exit 2
  28. fi

  30. if [ -d $i_db2arch -a -d $i_cv_arch ]
  31. then
  32.   echo " " > /dev/null
  33. else
  34.   now_time=`date +"%Y%m%d %H:%M:%S"`
  35.   echo "-->flag=$i_flag" >> $i_log
  36.   echo "-->$now_time" >> $i_log
  37.   echo "-->$i_db2arch not exist OR $i_cv_arch not exist !!" >> $i_log
  38.   exit 3
  39. fi

  41. if [ $i_flag -eq 1 ]
  42. then
  43.   now_time=`date +"%Y%m%d %H:%M:%S"`
  44.   echo "-->flag=$i_flag,mv archive log to $i_cv_arch for cv soft backup to tape!" >> $i_log
  45.   echo "-->$now_time" >> $i_log
  46.   echo "-->db2arch=$i_db2arch" >> $i_log
  47.   echo "-->cv_db2arch=$i_cv_arch" >> $i_log
  48.   find $i_db2arch -name "S*.LOG" -type f -mmin +5 |sort >> $i_log
  49.   echo " " >> $i_log
  50.   find $i_db2arch -name "S*.LOG" -type f -mmin +5 | xargs -i /bin/mv {} $i_cv_arch
  51. elif [ $i_flag -eq 2 ]
  52. then
  53.   now_time=`date +"%Y%m%d %H:%M:%S"`
  54.   echo "-->flag=$i_flag,after backup to tape,rm archive log!" >> $i_log
  55.   echo "-->$now_time" >> $i_log
  56.   echo "-->db2arch=$i_db2arch" >> $i_log
  57.   echo "-->cv_db2arch=$i_cv_arch" >> $i_log
  58.   rm $i_cv_arch/*
  59. fi

  61. exit 0

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/22661144/viewspace-1660177/，如需轉載，請註明出處，否則將追究法律責任。

相關文章