[数据泵]数据泵导出脚本

userid=system/dw123directory=data_pump_dirparallel=4

compression=all

schemas=(bill_ods,bill_dm,ETL_PLATFORM,dap_ods,dap_dw,dap_report)----------------------------------------------------#!/bin/bash

# User specific environment and startup programssource /home/oracle/.bash_profile# default retetionif [ $# == 1 ];then DATE=${1}else

DATE=`date +%Y%m%d`;fi

DATA_PUMP_DIR=/data/oracle/u02/dpdump;PAR_FILE=bak_src.exp.par

TODAY_FILE=bak_src_dap_${DATE};

# pump data using data pumpcd ${DATA_PUMP_DIR}

rm -f ${TODAY_FILE}_*.dmp ${TODAY_FILE}.exp.log ${TODAY_FILE}.finish

${ORACLE_HOME}/bin/expdp parfile=${PAR_FILE} dumpfile=${TODAY_FILE}_%U.dmp logfile=${TODAY_FILE}.exp.logtar zcvf ${TODAY_FILE}.tar.gz ${TODAY_FILE}_*.dmp ${TODAY_FILE}.exp.logrm -f ${TODAY_FILE}_*.dmp ${TODAY_FILE}.exp.log# generate the flag file

touch ${TODAY_FILE}.finish# delete old dump file

find ${DATA_PUMP_DIR} -daystart -mtime +5 -type f -name \"bak_src_*.tar.gz\"|xargs rm -rf