Data Pump export

Data Pump Export Implementation:

Create Directories and Grant permissions to the User.
SQL>Create or replace directory DATA_DUMP_DIR as '/u03/oracle/datapump/files';
SQL>Grant read, write on directory DATA_DUMP_DIR to xxxxx;

SQL>Create or replace directory DATA_LOG_DIR as '/u03/oracle/datapump/logs';
SQL>Grant read, write on directory DATA_LOG_DIR to xxxx;

full_expdp.sh

#!/bin/ksh
##################################################################
### This Script is used to Export FULL DATABASE using DATAPUMP.
### Author : ANBU SUBRAMANIAN
### Date : 10/11/2006
### $1 is the instance name passed as a parameter. #################################################
dba_team= 'anbus@1234.com'
. /u04/datapump/scripts/.$1
opwd=`cat /u04/datapump/scripts/.infodb.pw`
export opwd
dtstamp=`date +%m%d%Y`
expdp $opwd@$1 dumpfile=dmpdir:$1_expdp_%U_$dtstamp.dmp parallel=4 logfile=logdir:$1_expdp_$dtstamp.log full=y job_name=$1_export
/usr/bin/cat /u04/datapump/logs/$1_expdp_$dtstamp.log grep 'successfully completed' > /dev/null 2>&1
if [ $? != 0 ]
then
tail -10 $1_expdp_$dtstamp.log > /u04/datapump/scripts/dumperr
mailx -s "IMPORTANT - ERROR IN $1 DATA PUMP FULL EXPORT on $dtstamp " $dba_team
exit 1
else
echo "DataPump Start & End Time Details......." >/u04/datapump/scripts/dumpout
echo " " >> /u04/datapump/scripts/dumpout
/usr/bin/cat /u04/datapump/logs/$1_expdp_$dtstamp.log grep Export: >> /u04/datapump/scripts/dumpout
cat /u04/datapump/logs/$1_expdp_$dtstamp.log grep Job >> /u04/datapump/scripts/dumpout
echo " " >> /u04/datapump/scripts/dumpoutecho "Backup files are:" >> /u04/datapump/scripts/dumpout
/usr/bin/gzip /u04/datapump/files/$1_expdp_01_$dtstamp.dmp
/usr/bin/gzip /u04/datapump/files/$1_expdp_02_$dtstamp.dmp
/usr/bin/gzip /u04/datapump/files/$1_expdp_03_$dtstamp.dmp
/usr/bin/gzip /u04/datapump/files/$1_expdp_04_$dtstamp.dmp
/usr/bin/ls -lt /u04/datapump/files/$1*expdp*$dtstamp.dmp.gz >> /u04/datapump/scripts/dumpout
/usr/bin/gzip /u04/datapump/logs/$1_expdp_$dtstamp.log
mailx -s "$1 DATA PUMP FULL EXPORT IS SUCCESSFULL on $dtstamp" $dba_team < /u04/datapump/scripts/dumpout
exit 0
fi