Advertisement
Guest User

Untitled

a guest
Dec 1st, 2017
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 1.42 KB | None | 0 0
  1. export EDITOR=vi
  2. $ crontab -e
  3. 0 * * * * /u01/cron/file_backup.sh > /u01/cron/logs/fback.log 2>&1
  4. 0 * * * * /u01/cron/dpump.sh > /u01/cron/logs/dpump.log 2>&1
  5.  
  6. #!/bin/bash
  7. ORACLE_BASE=/u01/app/oracle
  8. export ORACLE_BASE
  9. ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
  10. export ORACLE_HOME
  11. ORACLE_SID=s193130
  12. export ORACLE_SID
  13. PATH=$PATH:$ORACLE_HOME/bin
  14. LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
  15. export LD_LIBRARY_PATH
  16. TMP=/tmp
  17. export TMP
  18. TMPDIR=$TMP
  19. export TMPDIR
  20. ORATAB=/etc/oratab
  21. export ORATAB
  22.  
  23. CURRDATE=$(date +%Y%m%d-%H.%M)
  24. export CURRDATE
  25.  
  26. exp system/admin
  27.     full=y
  28.     grants=y
  29.     indexes=y
  30.     consistent=y
  31.     rows=y
  32.     file=/u01/cron/backup/exp/$CURRDATE.dmp
  33.     log=/u01/cron/backup/exp/log/$CURRDATE.log statistics=none
  34.  
  35.  
  36. // Скрипт запуска резервного копирования с помощью Data Pump:
  37.  
  38.  
  39. #!/bin/bash
  40. ORACLE_BASE=/u01/app/oracle
  41. export ORACLE_BASE
  42. ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
  43. export ORACLE_HOME
  44. ORACLE_SID=s193130
  45. export ORACLE_SID
  46. PATH=$PATH:$ORACLE_HOME/bin
  47. EXPORT_FOLDER=/u01/app/oracle/admin/${ORACLE_SID}/datapump
  48. export EXPORT_FOLDER
  49. ORACLE_USER=SYSTEM
  50. ORACLE_PASSWORD=admin
  51. DATAPUMP_DIR=/u01/cron/backup/datapump
  52. export DATAPUMP_DIR
  53. DATE=(date +%Y%m%d.%H:%M)
  54. export DATE
  55. $ORACLE_HOME/bin/expdp $ORACLE_USER/$ORACLE_PASSWORD full=y dumpfile=$DATE.dmp logfile=$DATE.log flashback_time=SYSTIMESTAMP
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement