#!/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 - RW - Removed 28.04.2017.
#                               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.
#	RW	28.04.2017	Modified for tst-02
#	RW	28.04.2017	Added Database Sizing function.
#	RW	07.06.2017	Modified for Weekly backups.
#	RW	04.07.2017	Changed DB size structure.
#	RW	04.07.2017	Added DEBUG method. 
#	RW	05.07.2017	Added asmcmd file deletion.
#
# ============================================================================================================
# OWNER      DIRECTORY_NAME  DIRECTORY_PATH
# ---------- --------------  ---------------------------------------------------------------------------------
# SYS        DUMPSET_LOGS	/home/oracle/Scripts/DP/logs
# SYS	     EXP_DIR		+DATA/<${ORACLE_SID}>/DUMPSET
# ------------------------------------------------------------------------------------------------------------

function is_sid_valid
{
if [ `ps -ef | grep -v grep | grep "ora_pmon_${ORACLE_SID}$" | wc -l 2> /dev/null` -eq 0 ]
then
        return 1
else
        return 0
fi
}

# ------------------------------------------------------------------------------------------------------------
export DEBUG="N"  # "Y"||"N"
export ORACLE_SID=`echo ${1} | tr "[a-z]" "[A-Z]"`
export DB_SID=${ORACLE_SID}
export ORACLE_HOME="/u01/app/oracle/product/11.2.0/dbhome_1"
export SCRIPTS_DIR="/home/oracle/Scripts/DP"
export PARFILE="${SCRIPTS_DIR}/expdp_${ORACLE_SID}.par"
export ASM_CMD_FILE="${SCRIPTS_DIR}/${DB_SID}_asmcmd.txt"

[ "${DEBUG}" == "Y" ] && cmd="echo" || cmd="eval"

if [ "$#" -eq 1 ]
then
	if is_sid_valid
	then
                res=`${ORACLE_HOME}/bin/sqlplus -s expman/expdp@${ORACLE_SID} <<-EOF
                SET ECHO OFF NEWP 0 SPA 0 PAGES 0 FEED OFF HEAD OFF TRIMS ON TAB OFF
                column bytes format 99999
                select trim(round(sum(bytes)/1024/1024/1024)) from dba_extents;
                exit;
EOF`

		echo "userid=expman/expdp@${ORACLE_SID}"				 > ${PARFILE}
		echo "dumpfile=EXP_DIR:${ORACLE_SID}_week_`date '+%V'`_expdp.dmp" 	>> ${PARFILE}
		echo "full=y" 								>> ${PARFILE}
		echo "logfile=DUMPSET_LOGS:${ORACLE_SID}_week_`date '+%V'`_expdp.log"	>> ${PARFILE}
		echo "reuse_dumpfiles=y"						>> ${PARFILE}
		if [[ ${res} -gt 10 ]]   # GB
                then
			echo "# ${ORACLE_SID} DB Size is ${res}GB excluding CCB & MDM."	>> ${PARFILE}
			echo  "exclude=SCHEMA:\"in ('MDMADM','CCBADM')\""		>> ${PARFILE}
		fi
		${cmd} ${ORACLE_HOME}/bin/expdp parfile=${PARFILE}

		# Purge from ASM..............
		if [ $? -eq 0 ]
		then
			[ -f ${SCRIPTS_DIR}/logs/${ORACLE_SID}_week_`date +%V --date='2 weeks ago'`_expdp.log ] && rm -f ${SCRIPTS_DIR}/logs/${ORACLE_SID}_week_`date +%V --date='2 weeks ago'`_expdp.log || :
 			export ORACLE_SID="+ASM"
         		export ORACLE_HOME="/u01/app/oracle/product/11.2.0/grid"
			echo "rm +DATA/${DB_SID}/dumpset/${DB_SID}_week_`date +%V --date='4 weeks ago'`_expdp.dmp" > ${ASM_CMD_FILE}
			${ORACLE_HOME}/bin/asmcmd < ${ASM_CMD_FILE}
	 	fi
	else
		echo -e "ERROR: Parameter 1: Database '${ORACLE_SID}' does not exist."
	fi
else
	echo -e "ERROR: Usage weekly_expdp_v?.ksh <ORACLE_SID>." 
fi

# =============================================================================================================