#!/bin/bash
echo "*****setting the env*****"
export NLS_LANG=American_America.ZHS16GBK
export ORACLE_OWNER=DBschema
export ORACLE_SID=ProdDB
export ORACLE_BASE=/home/oracle
export ORACLE_HOME=/home/oracle/11.2.4
echo "*****start deleting data *****"
find $HOME/backup/expdpdata/ -mtime +7 -type f | xargs rm -rf
for username in DBschema
do
export DATE=`date +%Y%m%d%H%M`
echo "*****start exporting ${username}'s object*****"
/home/oracle/11.2.4/bin/expdp \'/ as sysdba\' directory=D1 dumpfile=${username}\_$DATE\_%U.dmp SCHEMAS=${username} logfile=expdp_${username}_$DATE.log cluster=no parallel=4
echo "*****start compressing ${username}'s object*****"
gzip /home/11.2.4/oracle/backup/expdpda:ta/${username}_$DATE_*.dmp
done