Guest User

Untitled

a guest
Mar 22nd, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. * expdp をcron 登録する
  2.  
  3. ```expdp_oracle.sh
  4. #!/bin/sh
  5.  
  6. export LANG=ja_JP.UTF-8
  7. export NLS_LANG=Japanese_Japan.AL32UTF8
  8.  
  9. FILENM="expdp.dmp"
  10. LOG="expdp.log"
  11.  
  12. DMP=$FILENM
  13. LOG=$LOG
  14.  
  15. # expdp
  16. export ORACLE_BASE=/opt/oracle
  17. export ORACLE_HOME=/opt/oracle/product/12.1.0
  18. export ORACLE_SID=xxxx
  19.  
  20. $ORACLE_HOME/bin/expdp xxxx/xxxx DIRECTORY=xxxx SCHEMAS=xxxx DUMPFILE=$DMP LOGFILE=$LOG
  21. ```
  22.  
  23. ```
  24. $ crontab -l
  25. 8 12 * * * /home/oracle/expdp_oracle.sh >/tmp/analog.log 2>/tmp/analog-err.log
  26. ```
Add Comment
Please, Sign In to add comment