scripts/LJCOPY/DP/DEV/daily_expdp_v3.ksh

#!/bin/ksh
# ======================================================================
# Richard Wilson - 28.04.2017
# Backup the database using Data Pump.
# ----------------------------------------------------------------------
# History:
#       RW      02.06.2014      Minor modifications.
#       RW      24.06.2014      Parallelised.
#                               EXPDP to ASM only.
#       RW      26.06.2014      Added ASM dump file deletion.
#       RW      04.09.2014      Use dynamic date, changed ORACLE_HOME.
#                               Corrected errors in ASM purge.
#
# ======================================================================
# OWNER      DIRECTORY_NAME  DIRECTORY_PATH
# ---------- --------------  -------------------------------------------
# SYS        DUMPSET_LOGS	create or replace directory DUMPSET_LOGS as '/home/oracle/Scripts/DP/logs';
# SYS        DUMPSETS        	+R5DISK/CONV/dumpset
# ----------------------------------------------------------------------

export ORACLE_HOME="/u01/app/oracle/product/11.2.0/dbhome_1"
export ORACLE_SID="${1}"i
export SIZE_FLAG="${2}"
export SCRIPTS_DIR="/home/oracle/Scripts/DP"

case ${SIZE_FLAG} in
	F|f) SIZE_FLAG="exclude=SCHEMA:\"in \(\'MDMADM\',\'CCBADM\'\)\"";;
	S|s) SIZE_FLAG="";;
	*)  ;; 
esac

# Check for log file, and if exists, rename.
[ -f ${SCRIPTS_DIR}/logs/${ORACLE_SID}_`date '+%a'`_daily_expdp.log ] && mv -f ${SCRIPTS_DIR}/logs/${ORACLE_SID}_`date '+%a'`_daily_expdp.log ${SCRIPTS_DIR}/logs/old_${ORACLE_SID}_`date '+%a'`_daily_expdp.log || :

# Export the database.
echo ${ORACLE_HOME}/bin/expdp expman/expdp@${ORACLE_SID} dumpfile=EXP_DIR:${ORACLE_SID}_`date '+%a'`_daily_expdp_%U.dmp full=y exclude=SCHEMA:\"in \(\'MDMADM\',\'CCBADM\'\)\" logfile=DUMPSET_LOGS:${ORACLE_SID}_`date '+%a'`_daily_expdp.log reuse_dumpfiles=y #parallel#

# Purge old EXPDP files from ASM.
if [ $? -eq 0 ]
then
        export ORACLE_SID="+ASM"
        export ORACLE_HOME="/u01/app/oracle/product/11.2.0/grid"
#         last_day=`date +%a --date='3 days ago'`
#         ${ORACLE_HOME}/bin/asimcmd rm -f +R5DISK/CONV/dumpset/CONV_${last_day}_daily_expdp_*.dmp
fi
# =============================================================================================================