Oracle通用导出脚本

#!/bin/bash
source ~/.profile
export DMP_ROOT=/u03/dbdump
export EXP_DATE=`date +%Y%m%d-%H%M`
export SCHEMA_NAME=ITS_WXL1
export SCHEMA_PASS=ITS_WXL1
export TNSNAME=TRANSACT1
export DMP_FILENAME_SUFFIX=$SCHEMA_NAME-$TNSNAME-$EXP_DATE
export DMP_FILENAME=$DMP_FILENAME_SUFFIX.dmp
export DMP_LOG_FILENAME=$DMP_FILENAME_SUFFIX.log
export DMP_ARCHIVED_NAME=$DMP_FILENAME_SUFFIX.tar

expdp $SCHEMA_NAME/$SCHEMA_PASS@$TNSNAME directory=DATA_PUMP_DIR dumpfile=$DMP_FILENAME logfile=$DMP_LOG_FILENAME

cd $DMP_ROOT
#tar -cvef $DMP_ARCHIVED_NAME $DMP_FILENAME
#gzip $DMP_ARCHIVED_NAME
gzip $DMP_FILENAME
#rm $DMP_FILENAME