expdp crontab 설정

- expdp 스크립트 작성

[test11]dbtest:/oracle/app/oracle/product/11.2.0.4/truin> :vi crontab.sh
#!/bin/bash

export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4
export ORACLE_SID=test11
export ORACLE_TERM=xterm
export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH

# backup date
DATE=`date '+%Y%m%d'`

# backup destination
DMPFILE=${DATE}_table.dmp
LOGFILE=${DATE}_table.log

expdp scott/1234 directory=datapump dumpfile=${DMPFILE} logfile=${LOGFILE} tables=emp

 

2. 스크립트 권한 부여

[test11]dbtest:/oracle/app/oracle/product/11.2.0.4/truin> :chmod 775 crontab.sh

 

3-1. crontab 설정 (oracle os 유저) - 새벽 1시 수행

[test11]dbtest:/oracle/app/oracle/product/11.2.0.4/truin> :crontab -e

0 1 * * * /oracle/app/oracle/product/11.2.0.4/truin/crontab.sh

 

3-2. crontab 설정 (root os 유저) - 새벽 1시 수행

0 1 * * * su - oracle -c /oracle/app/oracle/product/11.2.0.4/truin/crontab.sh