#!/bin/sh
#su - oracle
export ORACLE_BASE=/u01/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export ORACLE_SID=orcl
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH PATH
export DUMP_DIR=/home/oracle/dump
export DEL_TIME=`date -d "5 days ago" +%Y%m%d`
export TIME=`date +%Y%m%d%H%M`
expdp 'ENSURE/ENSURE@localhost/orcl' schemas=ENSURE directory=DUMP dumpfile=ENSURE_$TIME.DMP reuse_dumpfiles=y logfile=expdp_ENSURE_$TIME.log
echo "Delete the file backup before 5 days..."
rm -rf $DUMP_DIR/*$DEL_TIME*.DMP
echo "Delete the file backup successfully"