ORACLE_SID=<SERVER NAME>
export ORACLE_SID

#!/bin/ksh
# 

#--------------------------------------------------------------
# Export Oracle database shell script
#--------------------------------------------------------------
# Description: This shell script will export the database 
#              to a compressed file with the use of a
#              named pipe for maximum efficiency.
# Notes:       1. To uncompress the file use
#              gunzip <fileName.dmp.gz>
#              2. To import the file use the oracle 
#              import utility after uncompressing.
# License:     Free for all to use in commercial products, under
#              BSD, MIT, and Apache Opensource License
#--------------------------------------------------------------
# Usage:
#--------------------------------------------------------------
# Revision information
#--------------------------------------------------------------
# Mod Date  Who / What
#--------------------------------------------------------------
# 06/20/06  Britton LaRoche, Amped Labs LLC.
#           http://www.ampedlabs.com
#           Initial Version
#
#
#
#--------------------------------------------------------------

#echo on the same line function
echon () {
    if [ X"$ECHON" = X ]
    then
    # Determine how to "echo" without newline: "echo -n"
    # or "echo ...\c"
    if [ X`echo -n` = X-n ]
    then ECHON=echo; NNL="\c"
    else ECHON="echo -n"; NNL=""
    fi

    fi
    $ECHON "$*$NNL"
}

#Cancel Message
showCancelMessage() {
    echo ""
    echo ""
    echo "-------------------------------------------------------------------"
    echo "--  Usage: exportdb.sh (export file) (userid)"
    echo "--"
    echo "-------------------------------------------------------------------"
    echo '--  Example : exportdb.sh "prod20060620.dmp" "pin" '
    echo "--"
    echo "-------------------------------------------------------------------"
    echo ""
    echo "  Process Canceled."
    echo "  Exiting Process. "
    echo ""
    exit 1
}


if [ ! -n "$ORACLE_HOME" ]; then
        echo "ORACLE_HOME is not defined"
        exit 1
fi


#--------------------------------------------------------------
#-- 2. Verify input arguments 
#--------------------------------------------------------------
#echo "Number of arguments is: $#"
#echo "The entire list of arguments is: $*"

expFile="${1}.gz"
userName="${2}"
argCount="$#"
minCount="2"


totalCount="0"
totalFiles="0"

if [ "${argCount}" -lt "${minCount}" ]; then
    showCancelMessage
fi

#-----------------------------------------------------------
#--  3. Confirm Variables
#-----------------------------------------------------------
echo ""
echo "  ------------------------------------------------------------"
echo "  ${startTime} Run Parameters: "
echo "  ------------------------------------------------------------"
echo "    Export File         :    ${expFile} (auto gzip) "
echo "    User                :    ${userName} "
echo "    ORACLE_HOME         :    ${ORACLE_HOME} "
echo "    ORACLE_SID          :    ${ORACLE_SID} "
echo "  ------------------------------------------------------------"



# Confirm parameters
echo " "
echon "  ---> Are the parameters above correct? (y/n): "
read answer   
if [ "$answer" = "y" ] || [ "$answer" = "Y" ]
    then
        # -- Start 
        echo ""
        echo "  Starting Process."
        echo ""
    else 
        showCancelMessage
        exit 1
fi

#--------------------------------------------------------------
# Begin Processing
#--------------------------------------------------------------

echon "  ---> Enter the db password for ${userName}: "
read password   

# create a named pipe
mknod exp.pipe p

# read the pipe - output to zip file in the background
gzip < exp.pipe > ${expFile} &

echo "process running: "
ps -ef | grep exp.pipe

echo " "
echo "starting export "
echo "exp BUFFER=2048 RECORDLENGTH=65536 userid=${userName}/${password} file=exp.pipe "

# feed the pipe
exp BUFFER=2048000 RECORDLENGTH=64 userid=${userName}/${password} file=exp.pipe &

echo "Exporting data: "
echo "ps -ef | grep exp "
ps -ef | grep exp

echo "Outputting to file ${expFile} ... "
echo ""