oracle-backup-expdp

#!/usr/bin/bsh
. /oracle/.bash_profile

###############################################################################
#   Name : exp_ACEM05.sh
#   Description : Schema Export Backup Shell
#   Author : zuo qi
#   Date : 2014.04.
#   Executed at 01:00 daily
###############################################################################

CURR_TIME=`date +"%y%m%d"`
HOST_NAME=`echo $ORACLE_SID`
EXPORT_DIR='/dbbackup'

echo
echo
echo "----------------------------------"
echo " Start Script exp_ACEM05.sh  "
echo "----------------------------------"
echo "Start Time :"
date +%y/%m/%d-%H:%M:%S

sqlplus -s "/as sysdba" <

alter system checkpoint;

quit
EOF

cd  $EXPORT_DIR
find $EXPORT_DIR -name '*.log' -mtime +1 -exec rm -f {} \;
find $EXPORT_DIR -name '*.dmp' -mtime +1 -exec rm -f {} \;

expdp system/XXXX SCHEMAS=SLMS,NEXCORE,IF_SLMS,IF_ERUM,IF_SKIITS directory=EXP_BAK dumpfile=exp_${HOST_NAME}_${CURR_TIME}_SLMS.dmp logfile=exp_${HOST_NAME}_${CURR_TIME}_SLMS.log

echo "End Time :"
date +%y/%m/%d-%H:%M:%S
echo "----------------------------------"
echo " END Script exp_daily_SLMS.sh    "
echo "----------------------------------"

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22193071/viewspace-1134800/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22193071/viewspace-1134800/