每天定时进行expdp的脚本

郑全

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
export ORACLE_SID=orcl
export NLS_LANG=american_america.ZHS16GBK
export PATH=$ORACLE_HOME/bin:$PATH
export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"
DATE=`date +%m%d%y`
expdp \'/ as sysdba\' directory=imp_dir dumpfile=dpfull_${DATE}.dmp full=y log=dpfull_${DATE}.log
cd /oracle
/usr/bin/gzip /oracle/dpfull_${DATE}.dmp
DATE=`date +%m%d%y`
mv dpfull_${DATE}.dmp.gz bak
cd /oracle/bak
find /oracle/bak  -name "dpfull*.gz" -mtime +7 -exec rm {} \;

Alexander

先顶一个啦！～学习中～

nifelight

谢谢分享！