scripts/LJCOPY/RMAN/RMAN_DB_Backup_v103.ksh

#!/bin/ksh
# set -x
# ======================================================================================================================================
# Title:  	RMAN_DB_Backup.ksh
# Author: 	Richard Wilson
# Date:   	03.04.2014
# File Name: 	RMAN_DB_Backup_v???.ksh
# Description: 	Uses RMAN to backup Oracle databases.
# Usage: 	RMAN_DB_backup_v???.ksh <ORACLE_SID> <RETENTION_PERIOD> <ARCH|INCR> <LEVEL_0_DAY> <CAT|NOCAT>
# --------------------------------------------------------------------------------------------------------------------------------------
# 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.
#	25.04.2017	RW	Added 'Day' input parameter and 'is_day_valid' function.
#	10.05.2017	RW	Added Level-0 Backup Day input parameter.
#       10.05.2017      RW      Moved CROSSCHECKS into Level-0 only.
#	12.12.2017	RW	Added 'is_not_guarded' function to allow backup on STANDBY.
# 	21.12.2017	RW	Added dbhome_1/db_1 logic for ORACLE_HOME.
#	11.04.2018	RW	Added Data Guard function is_not_guarded.
#	16.05.2018	RW	Added get_db_role and get_DB_type procedures.
#	17.05.2018	RW 	Modifications for RMAN-05021: this configuration cannot be changed for a BACKUP or STANDBY control file.
#	18.05.2018	RW	Modified for Single Instance, Primary, and Standby backups.
# ---------------------------------------------------------------------------------------------------------------------------------------

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 -w "ora_pmon_${ORACLE_SID}$" | wc -l 2> /dev/null` -eq 0 ]
then
	return 1
else
	return 0
fi
}


function is_day_valid
{
	case "${LEVEL_0_DAY}" in
		MON|TUE|WED|THU|FRI|SAT|SUN|ZZZ) 
			return 0;;
	        *) 	return 1;;
	esac
}

	
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`
}


function is_not_guarded
{
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\\$archive_dest where status = 'VALID' and target = 'STANDBY';
EOF`
}


get_db_role()
{
db_role=`${ORACLE_HOME}/bin/sqlplus -S / "as sysdba" <<-EOF
        set pagesize 0 feedback off verify off heading off termout off echo off
        select  database_role from v\\$DATABASE;
EOF`
}


get_DB_type()
{
get_db_role
if is_not_guarded
then
        if [ "${db_role}" = "PHYSICAL STANDBY" ]; then
                [ "${DEBUG}" == "Y" ] && echo "${db_role}: Physical Standby"
                export DB_TYPE=3
        else
                [ "${DEBUG}" == "Y" ] && echo "${db_role}: Single Instance."
                export DB_TYPE=1
        fi
else
        [ "${DEBUG}" == "Y" ] && echo "${db_role}: Primary (Dataguarded)."
        export DB_TYPE=2
fi
}


set_cat()
{
	case ${#} in
        4) if [ "${3}" = "ARCH" ]
           then
           export USE_CAT=`echo ${4} | tr "[a-z]" "[A-Z]"`
           fi;;
        5) if [ "${3}" = "INCR" ]
           then
           export USE_CAT=`echo ${5} | tr "[a-z]" "[A-Z]"`
           fi;;
        *) export USE_CAT="NOCAT";;
esac
}


set_asm_dest()
{
        case "${ORACLE_SID}" in
                SIT2|DMSIT|IFCE|SYSTST|SYSTST2|GOLD|GOLD2|PACK|PACK2|UPK) asm_disk="+R5DISK";;
                *) asm_disk="+FRA";;
        esac
}


build_cmdfile()
{
echo "connect target sys/newr00t@${ORACLE_SID}"                                                                         >  ${RMAN_CMD_FILE}

[ "${DEBUG}" == "Y" ] && echo "DEBUG: Catalog is ${USE_CATALOG}."

if [[ "${USE_CATALOG}" == "CAT" ]]; then
	echo "connect catalog rcatadm/RCATADM@RCAT"                                                                     >> ${RMAN_CMD_FILE}
fi

echo "run {"                                                                                                            >> ${RMAN_CMD_FILE}
echo "sql 'alter session set optimizer_mode=RULE';"									>> ${RMAN_CMD_FILE}
echo "sql 'ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=60 SCOPE=BOTH';"						>> ${RMAN_CMD_FILE}

if [[ ${DB_TYPE} = 1 || ${DB_TYPE} = 2 ]]
then
	echo "CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF ${RETENTION_DAYS} DAYS;"       				>> ${RMAN_CMD_FILE}
	echo "sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';"                                                                  >> ${RMAN_CMD_FILE}
fi

echo "CONFIGURE CONTROLFILE AUTOBACKUP ON;"                                                                             >> ${RMAN_CMD_FILE}
echo "CONFIGURE SNAPSHOT CONTROLFILE NAME TO '${ORACLE_HOME}/dbs/snapcf_${ORACLE_SID}.f';"                              >> ${RMAN_CMD_FILE}

if [[ ${DB_TYPE} = 1 || ${DB_TYPE} = 3 ]]
then
	set_asm_dest
	echo "ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT '${asm_disk}';"                                            >> ${RMAN_CMD_FILE}
	echo "ALLOCATE CHANNEL disk2 DEVICE TYPE DISK FORMAT '${asm_disk}';"                                            >> ${RMAN_CMD_FILE}
	echo "ALLOCATE CHANNEL disk3 DEVICE TYPE DISK FORMAT '${asm_disk}';"                                            >> ${RMAN_CMD_FILE}
	echo "ALLOCATE CHANNEL disk4 DEVICE TYPE DISK FORMAT '${asm_disk}';"                                            >> ${RMAN_CMD_FILE}
fi

if [[ ${DB_TYPE} = 2 || ${DB_TYPE} = 3 ]]
then
	echo "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK APPLIED ON ALL STANDBY;"		>> ${RMAN_CMD_FILE}
else
#	echo "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK COMPLETED BEFORE 'SYSDATE-${RETENTION_DAYS}';"         >> ${RMAN_CMD_FILE}
	echo "CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;"         				>> ${RMAN_CMD_FILE}
fi

[ "${DEBUG}" == "Y" ] && echo "DEBUG: Backup Type is set to ${BACKUP_TYPE} - (L0 Backups on ${LEVEL_0_DAY})."

if [[ ${DB_TYPE} = 1 || ${DB_TYPE} = 3 ]]
then
	case ${BACKUP_TYPE} in
	"INCR") 
		echo "CROSSCHECK backup;"  				                                                 >> ${RMAN_CMD_FILE}
		case `date +%a | tr "[a-z]" "[A-Z]"` in
		${LEVEL_0_DAY}) [ "${DEBUG}" == "Y" ] && echo "DEBUG: Type: INCR Level 0"
				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}
                		;;
        		     *) [ "${DEBUG}" == "Y" ] && echo "DEBUG: Type: INCR Level 1"
				echo "BACKUP as compressed backupset SECTION SIZE 20G 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")	[ "${DEBUG}" == "Y" ] && echo "DEBUG: Type: ARCH"
		echo "backup as compressed backupset TAG='Arch_${ORACLE_SID}_`date +%d%m%YT%H%M%S`' archivelog all;" 	>> ${RMAN_CMD_FILE} 
		;;
	esac

	if is_fs_mounted
	then
		[ -d ${BACKUP_FS}/${ORACLE_SID} ] || mkdir ${BACKUP_FS}/${ORACLE_SID} 
        	[ "${DEBUG}" == "Y" ] && echo "/bin/find ${BACKUP_FS}/${ORACLE_SID} -type f -empty -delete" || /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
fi

echo "DELETE NOPROMPT OBSOLETE;"                                                  					>> ${RMAN_CMD_FILE}
echo "DELETE NOPROMPT EXPIRED BACKUP;"  										>> ${RMAN_CMD_FILE}
echo "}"                                                                                        			>> ${RMAN_CMD_FILE}
echo "exit"                                                                                     			>> ${RMAN_CMD_FILE}
}

# Main ==================================================================================================================================================================
export DEBUG="Y"  # "Y"||"N"
export ORACLE_SID=`echo ${1} | tr "[a-z]" "[A-Z]"`
export RETENTION_DAYS=${2}
export BACKUP_TYPE=`echo ${3} | tr "[a-z]" "[A-Z]"`
export LEVEL_0_DAY=`echo ${4:-ZZZ} | tr "[a-z]" "[A-Z]"`
export SCRIPT_DIR="/home/oracle/Scripts/RMAN"
export BACKUP_FS="/backups"
export BACKUP_LOG=${SCRIPT_DIR}/logs/${ORACLE_SID}_${BACKUP_TYPE}_backup_log.log

test `echo ${5:-NOCAT} | tr "[a-z]" "[A-Z]"` = "CAT" && USE_CATALOG="CAT" || USE_CATALOG="NOCAT"
test `uname -n` = "uks-odbnrgtst-02" && export ORACLE_HOME="/u01/app/oracle/product/11.2.0/dbhome_1" || export ORACLE_HOME="/u01/app/oracle/product/11.2.0/db_1"

[ "${DEBUG}" == "Y" ] && echo "-- Debug Output ----------------------------------------------------------------------------------------------------"
[ "${DEBUG}" == "Y" ] && echo "DEBUG: Debugging is switched on."
[ "${DEBUG}" == "Y" ] && export RMAN_CMD_FILE=${SCRIPT_DIR}/${ORACLE_SID}_rman_cmds_DEBUG.rman || export RMAN_CMD_FILE=${SCRIPT_DIR}/${ORACLE_SID}_rman_cmds.rman

[ -d  ${SCRIPT_DIR}/logs ] || mkdir ${SCRIPT_DIR}/logs


if [ ${#} -eq 4 -o ${#} -eq 5 ]
then
	echo `date` >> ${BACKUP_LOG}
	if is_RMAN_running
	then
		ORACLE_SID=`echo ${ORACLE_SID} | tr "[a-z]" "[A-Z]"`	# 1
		if is_sid_valid
		then
			if [[ "${2}" = +([0-9]) ]]	# 2
			then
				if [[ "${BACKUP_TYPE}" == "ARCH" || "${BACKUP_TYPE}" == "INCR" ]]	# 3
				then
					if is_day_valid
					then
						get_DB_type
						set_cat
						build_cmdfile
						[ "${DEBUG}" == "Y" ] && echo ${ORACLE_HOME}/bin/rman cmdfile=${RMAN_CMD_FILE} log=${SCRIPT_DIR}/logs/${ORACLE_SID}_RMAN_${BACKUP_TYPE}_backup.log || ${ORACLE_HOME}/bin/rman cmdfile=${RMAN_CMD_FILE} log=${SCRIPT_DIR}/logs/${ORACLE_SID}_RMAN_${BACKUP_TYPE}_backup.log
						if [ $? = 0 ]
                                       		then
                                       			echo -e "\nINFO: ${ORACLE_SID} Database Backup Successful." >>  ${BACKUP_LOG}
                                       		else
                                       			echo -e "\nERROR: ${ORACLE_SID} Database Backup Failed." >>  ${BACKUP_LOG}
                                       		fi
					else
						echo -e "\nERROR: Parameter 4: Invalid Level-0 Backup Day entered <Mon|Tue|Wed|Thu|Fri|Sat|Sun>.\n"
					fi
				else
					echo -e "\nERROR: Parameter 3: Backup Type must be <INCR> or <ARCH>.\n"
                       		fi
			else
				echo -e "\nERROR: Parameter 2: Retention Days must be numeric, in days.\n"
			fi 
		else
 			echo -e "\nERROR: Parameter 1: Database '${ORACLE_SID}' does not exist.\n"
		fi
	else
       		echo -e "\nINFO: RMAN is already running.\n"
	fi
else
 	echo -e "\nUsage: RMAN_DB_backup.ksh <ORACLE_SID> <RETENTION_DAYS> <ARCH|INCR> <FULL_BACKUP_DAY> <CATALOG|NOCATALOG>\n"
fi

[ "${DEBUG}" == "Y" ] && (echo "-- RMAN cmd File ----------------------------------------------------------------------------------------------------"; cat ${RMAN_CMD_FILE})

# ================== End of File =============================================================================================================================================