oracle 定时expdp/impdp数据库schema

来源:这里教程网 时间:2026-03-03 16:37:22 作者:

环境: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

相关推荐