Linux/Unix shell 自动导入Oracle数据库(三)

2014-11-24 18:13:03 · 作者: · 浏览: 3
at `date`...\n" >>${LOG_FILE}
MAIL_SUB="Import data to ${ORACLE_SID} completed with some errors on `hostname`"
echo "--------------------------- End of the log file ---------------------------">>${LOG_FILE}
mail -s $MAIL_SUB dba@trade.com <${LOG_FILE}
fi


# ------------------------------------------------
# Removing files older than $RETENTION parameter
# ------------------------------------------------


find ${LOG_DIR} -name "impdb*.*" -mtime +$RETENTION -exec rm {} \;
find ${DUMP_DIR} -name "IMP*.*" -mtime +$RETENTION -exec rm {} \;
find ${DUMP_DIR} -name "${DUMP_DIR}/EXP_${SRC_ORA_SID}*.gz" -exec rm {} \;


exit