Linux Oracle DB backup

#!/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