scripts/LJCOPY/RMAN/RMAN_DB_Backup_v14.ksh

#!/bin/ksh
# ====================================================================================================
# Title:  RMAN_DB_Backup.ksh
# Author: Richard Wilson
# Date:   03.04.2014
# Description: Uses RMAN to backup Oracle databases.
# Usage:  Usage: RMAN_DB_backup.ksh <ORACLE_SID> <RETENTION_PERIOD> <ARCH|INCR>
#
# History:
#	17.04.2014	RW	Added %d%m%Y to Tag.
#	24.07.2014	RW	Added email notification.
#	29.07.2014	RW	Added more logic - email after 'backup backup'.
#	26.09.2014	RW	Included parameter Retention Period.
#	03.12.2014	RW	Changed to use R5DISK for UAT, SIT & TRAIN.
#	11.05.2015	RW	Removed Full backups, added Incremental backups.
#	09.02.2016	RW	Added function 'is_RMAN_running'.
#	09.02.2016	RW	Added backup 'NOT BACKED UP 2 TIMES' to capture any missed backupsets.
#
# -----------------------------------------------------------------------------------------------------

function is_fs_mounted
{
mount | grep "${BACKUP_FS}" > /dev/null && return 0 || return 1
}

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
}

function is_RMAN_running
{
return `${ORACLE_HOME}/bin/sqlplus -S / "as sysdba" <<-EOF
        set pagesize 0 feedback off verify off heading off termout off echo off
        select  count(1) from sys.v\\$RMAN_STATUS where status like 'RUNNING%';
EOF`
}

build_cmdfile()
{
# Build RMAN command file.
echo "connect target / "        	                                        		>  ${RMAN_CMD_FILE}
echo ""                                                                         		>> ${RMAN_CMD_FILE}
echo "run {"                                                                    		>> ${RMAN_CMD_FILE}
echo "sql 'ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=60 SCOPE=BOTH';"			>> ${RMAN_CMD_FILE}
echo "CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF ${SAVE_DAYS} DAYS;"             		>> ${RMAN_CMD_FILE}
echo "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK APPLIED ON ALL STANDBY;" >> ${RMAN_CMD_FILE}
echo "CONFIGURE CONTROLFILE AUTOBACKUP ON;"                                     		>> ${RMAN_CMD_FILE}
echo "CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_${ORACLE_SID}.f';"    >> ${RMAN_CMD_FILE}
echo "CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 4;"    	>> ${RMAN_CMD_FILE}
echo "CROSSCHECK backup of database;" 								>> ${RMAN_CMD_FILE}
echo "CROSSCHECK backup of controlfile;" 							>> ${RMAN_CMD_FILE}
echo "CROSSCHECK backup of spfile;"                                                             >> ${RMAN_CMD_FILE}
echo "CROSSCHECK backup of archivelog all;"                                                     >> ${RMAN_CMD_FILE}
echo "sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';" 							>> ${RMAN_CMD_FILE}

case ${BACKUP_TYPE} in
	"INCR") 
		case `date +%a` in
        		"Mon")  echo "BACKUP as compressed backupset SECTION SIZE 20G INCREMENTAL LEVEL 0 TAG='L0_${ORACLE_SID}_`date +%d%m%YT%H%M%S`' DATABASE include current CONTROLFILE plus ARCHIVELOG;" >> ${RMAN_CMD_FILE}
                		;;
        		    *)  echo "BACKUP as compressed backupset INCREMENTAL LEVEL 1 TAG='L1_${ORACLE_SID}_`date +%d%m%YT%H%M%S`' DATABASE include current CONTROLFILE plus ARCHIVELOG;" >> ${RMAN_CMD_FILE}
                		;;
		esac;;
	"ARCH")
		echo "backup as compressed backupset TAG='Arch_${ORACLE_SID}_`date +%d%m%YT%H%M%S`' archivelog all;" >> ${RMAN_CMD_FILE} 
		;;
esac

echo "delete noprompt archivelog all backed up 2 times to DEVICE TYPE disk completed before 'sysdate-1';" >> ${RMAN_CMD_FILE}

if is_fs_mounted
then
        /bin/find ${BACKUP_FS}/${ORACLE_SID} -type f -empty -delete
        echo "backup backupset all NOT BACKED UP 2 TIMES format '${BACKUP_FS}/${ORACLE_SID}/%U';" >> ${RMAN_CMD_FILE}
else
        echo -e "WARNING: Backup filesystem not mounted....."
fi

echo "}"                                                                                        >> ${RMAN_CMD_FILE}
echo "exit"                                                                                     >> ${RMAN_CMD_FILE}
}

# ==================================================================================================================================================================================================================
export ORACLE_SID=${1}
export SAVE_DAYS=${2}
export BACKUP_TYPE=${3}
export ORACLE_HOME="/u01/app/oracle/product/11.2.0/dbhome_1"
export SCRIPT_DIR="/home/oracle/Scripts/RMAN"
export RMAN_CMD_FILE=${SCRIPT_DIR}/${ORACLE_SID}_rman_cmds.rman
export BACKUP_FS="/backups"
export BACKUP_LOG=${SCRIPT_DIR}/logs/${ORACLE_SID}_backup_log.txt

is_RMAN_running
result=$?
result1=`echo ${result} | sed 's/[[:space:]]//g'`
if [ ${result1} -eq 0 ]
then
	if [ ${#} -eq 3 ]
	then
		ORACLE_SID=`echo ${ORACLE_SID} | tr "[a-z]" "[A-Z]"`
		if is_sid_valid
		then
			if [[ "${2}" = +([0-9]) ]]
			then
				if [ "${3}" == "ARCH" -o "${3}" == "INCR" ]
				then
					build_cmdfile
					${ORACLE_HOME}/bin/rman cmdfile=${RMAN_CMD_FILE} log=${SCRIPT_DIR}/logs/${ORACLE_SID}_RMAN_${BACKUP_TYPE}_backup.log
					if [ $? = 0 ]
                                        then
                                                echo -e "INFO: ${ORACLE_SID} Database Backup Successful." >>  ${BACKUP_LOG}
                                        else
                                                echo -e "ERROR: ${ORACLE_SID} Database Backup Failed." >>  ${BACKUP_LOG}
                                        fi
				else
					echo "ERROR: Parameter 3: Backup Type must be INCR or ARCH."
                                fi
			else
				echo "ERROR: Parameter 2: Retention Period must be numeric, in days!"
			fi 
		else
		 	echo "ERROR: Parameter 1: Database '${ORACLE_SID}' does not exist."
		fi
	else
		echo -e "\nUsage: RMAN_DB_backup.ksh <ORACLE_SID> <RETENTION_PERIOD> <ARCH|INCR>\n"
	fi
else
       	echo -e "\nINFO: RMAN is already running\n"
fi

# End of File