环境：

oracle 11.2.0.4 本地服务器存在两个实例，分别是QH、QHUAT

定时任务配置如下

25 20 * * * /home/oracle/exp_imp.sh > /home/oracle/expimp.log 2>&1

具体的脚本内容如下：

cat /home/oracle/exp_imp.sh

source /home/oracle/.bash_profile

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1

export ORACLE_BASE=/u01/app/oracle

export ORACLE_SID=QH

export PATH=$ORACLE_HOME/bin:$PATH

cd /u01/app/exp && find . -name 'jf*' -mtime +3 -exec rm -rf {} \;

expdp \"/ as sysdba\" schemas=jf directory=EXP dumpfile=jf`date +%Y%m%d`_%U.dmp logfile=expdp`date +%Y%m%d`.log parallel=1 cluster=N

export ORACLE_SID=QHUAT

sqlplus / as sysdba << EOF

show parameter name;

drop user jf cascade;

!impdp \'/ as sysdba\' directory=EXP dumpfile=jf`date +%Y%m%d`_%U.dmp logfile=impdp`date +%Y%m%d`.log parallel=1

exit

EOF

ITPub博客

oracle 定时expdp/impdp数据库schema