#!/bin/ksh
set -xv
. $HOME/.bash_profile

exp_dir=/u09/backup/exp; export exp_dir
log_dir=/u09/backup/exp/logs;export log_dir
cd $exp_dir
export ORACLE_SID=XXPRD
export DTE=`date +'%m%d%y'`
export STARTTIME=`date`
rm -Rf ${exp_dir}/prod_p
mkfifo ${exp_dir}/prod_p
gzip  < ${exp_dir}/prod_p > ${exp_dir}/XXPRD.$DTE.full.dmp.gz &
$ORACLE_HOME/bin/exp "'/ as sysdba'"  compress=y \
file=${exp_dir}/prod_p direct=y full=y  feedback=0 statistics=NONE buffer=61440 indexes=y \
log=${log_dir}/prod.$DTE.full.log
export ENDTIME=`date`
echo "Export Start Time: ${STARTTIME}" >> ${log_dir}/prod.$DTE.full.log
echo "Export Ebd   Time: ${ENDTIME}"   >> ${log_dir}/prod.$DTE.full.log
cat ${log_dir}/prod.$DTE.full.log |tail -30  | mailx -s "Export log for prod on ${DTE}" youremail@abc.com
gzip ${log_dir}/prod.$DTE.full.log
rm -Rf ${exp_dir}/prod_p