Oracle expdp 指令碼

fjzcau發表於2015-12-22
Oracle指令碼

  1. [oracle@yhbd08 scripts]$ crontab -l |tail -3
  2. #每天expdp備份資料庫,Add by fjzcau 2015-12-22
  3. 10 15 * * * /yohodata/fjzcau/scripts/yhbd08_orcl_expdp.sh > /dev/null 2>&1

  1. #---------------------------------------------------------------------------#
  2. # Scripts : /yohodata/fjzcau/scripts/yhbd08_orcl_expdp.sh
  3. # Author : fangjz/
  4. # Date : 2015/12/22
  5. # Purpose : Expdp Oracle data
  6. # Notes : This script can be run in crontab or in other shell script.
  7. # Parameters :
  8. #---------------------------------------------------------------------------#

  10. # Oracle Env
  11. if [ -f /home/oracle/.bash_profile ]
  12. then
  13.    . /home/oracle/.bash_profile
  14. fi

  16. bakdate=`date '+%Y%m%d%H'`
  17. cd /yohodata/expdp_orcl

  19. i_pre="`hostname`_orcl"

  21. log=${i_pre}_${bakdate}.log

  23. file1=${i_pre}_${bakdate}_expdp_01.dmp
  24. file2=${i_pre}_${bakdate}_expdp_02.dmp
  25. file3=${i_pre}_${bakdate}_expdp_03.dmp
  26. file4=${i_pre}_${bakdate}_expdp_04.dmp

  28. expdp system/Yoho_bi123 directory=expdp_orcl parallel=4 full=y \
  29. dumpfile=$file1,$file2,$file3,$file4 logfile=$log

  31. #version=10

  33. nohup gzip $file1 &
  34. nohup gzip $file2 &
  35. nohup gzip $file3 &
  36. nohup gzip $file4 &

  38. sleep 5

  40. now_time=`date +"%Y%m%d %H:%M:%S"`
  41. echo "-->$now_time gzip ${i_pre} start ..." >> $log

  43. i_cnt=0
  44. while [ 1 = 1 ]
  45. do
  46.   i_gzip_count=`ps -ef | grep gzip | grep -v grep | grep ${i_pre}_${bakdate}_expdp |wc -l`

  48.   if [ ${i_gzip_count} -eq 0 ]
  49.   then
  50.     now_time=`date +"%Y%m%d %H:%M:%S"`
  51.     echo "-->$now_time gzip ${i_pre} ok!" >> $log
  52.     break
  53.   fi
  54.   i_cnt=`expr $i_cnt + 1`
  55.   echo " ${i_cnt}:${i_gzip_count} gzip process running,sleep 60 seconds..." >> $log
  56.   sleep 60
  57. done

  59. now_time=`date +"%Y%m%d %H:%M:%S"`
  60. echo "-->$now_time gzip ${i_pre} end ." >> $log

  62. #ftp -i -n 123.57.245.98 <<!
  63. #user u1 u1
  64. #bin
  65. #put $file1.gz
  66. #put $log
  67. #put $0
  68. #by
  69. #!

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

相關文章