Oracle expdp 脚本

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. #---------------------------------------------------------------------------#
   
9. 
   
10. # Oracle Env
    
11. if [ -f /home/oracle/.bash_profile ]
    
12. then
    
13.    . /home/oracle/.bash_profile
    
14. fi
    
15. 
    
16. bakdate=`date '+%Y%m%d%H'`
    
17. cd /yohodata/expdp_orcl
    
18. 
    
19. i_pre="`hostname`_orcl"
    
20. 
    
21. log=${i_pre}_${bakdate}.log
    
22. 
    
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
    
27. 
    
28. expdp system/Yoho_bi123 directory=expdp_orcl parallel=4 full=y \
    
29. dumpfile=$file1,$file2,$file3,$file4 logfile=$log
    
30. 
    
31. #version=10
    
32. 
    
33. nohup gzip $file1 &
    
34. nohup gzip $file2 &
    
35. nohup gzip $file3 &
    
36. nohup gzip $file4 &
    
37. 
    
38. sleep 5
    
39. 
    
40. now_time=`date +"%Y%m%d %H:%M:%S"`
    
41. echo "-->$now_time gzip ${i_pre} start ..." >> $log
    
42. 
    
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`
    
47. 
    
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
    
58. 
    
59. now_time=`date +"%Y%m%d %H:%M:%S"`
    
60. echo "-->$now_time gzip ${i_pre} end ." >> $log
    
61. 
    
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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22661144/viewspace-1876876/