Durham Oracle: RMAN backup script

#!/bin/ksh

##########################################################################################

# Script Name : rman_backup.ksh

# Written By :

# Date :

# Usage : rman_backup.ksh -M <mode> -A <archivelog retention days>

# Parameters :

# M = Mode; DATABASE, ARCHIVELOG, ADHOC

# Description :

##########################################################################################

# FUNCTIONS

##########################################################################################

InitialiseVariables ()

{

export ORACLE_SID="DB Name as appropriate"

export ORACLE_HOME=/u01/app/oracle/product/12.1.0.1/dbhome_1

export PATH=$PATH:$ORACLE_HOME/bin

LogfileDir=/u02/backups/rman_logfiles

WrapperLogfile=${LogfileDir}/rman_backup_wrapper.log

Today=$(date +'%Y%m%d')

Now=$(date +'%Y%m%d_%H%M%S')

NLS_DATE_FORMAT='DD-Mon-YYYY Dy HH24:MI:SS'

export NLS_DATE_FORMAT

BACKUP_AREA=/u02/backups/

if [ ! -d $BACKUP_AREA ]

then

mkdir ${BACKUP_AREA}

ArcBackupArea=${BACKUP_AREA}/rman_archivelog_backups

DBBackupArea=${BACKUP_AREA}/rman_database_backups

ReportName=${LogfileDir}/rman_report_${Today}.txt

CrossscheckLogfile=${LogfileDir}/crosscheck.log

ArchiveLogRetention=7 #was previously 14

NumBackupsKeep=2

}

##########################################################################################

Usage ()

{

echo "Usage: $0 -M <Mode> -A <archivelog retention days>"

}

##########################################################################################

ValidateParameters ()

{

#Script Mode:

case $ScriptMode in

'DATABASE') return ;;

'ARCHIVELOG') return ;;

'ADHOC') return ;;

*) Usage; exit -1;;

esac

}

##########################################################################################

DeleteOldBackups ()

{

NumBackups=$(ls -d ${DBBackupArea}/20[0-9][0-9][0-9][0-9][0-9][0-9] | wc -l)

echo "Number of DB backups = ${NumBackups}." >> ${WrapperLogfile}

if [ ${NumBackups} -lt ${NumBackupsKeep} ]

then

echo "No need to delete any backups." >> ${WrapperLogfile}

else

Oldest=$(ls -d1 ${DBBackupArea}/20[0-9][0-9][0-9][0-9][0-9][0-9] | head -1 | xargs basename)

echo "Deleting backup ${Oldest}" >> ${WrapperLogfile}

rm -rf ${DBBackupArea}/${Oldest}

NumBackups=$(ls -d ${DBBackupArea}/20[0-9][0-9][0-9][0-9][0-9][0-9] | wc -l)

echo "There are now ${NumBackups} backups." >> ${WrapperLogfile}

}

##########################################################################################

RMANReport ()

{

rman nocatalog target / << EOF > ${ReportName}

set echo on;

show all ;

list backupset of database summary ;

list backupset of database ;

list backupset of controlfile summary ;

list backupset of controlfile ;

exit ;

EOF

sqlplus -s "/ as sysdba" << FIN >> ${ReportName}

PROMPT

PROMPT ARCHIVELOG Summary:

PROMPT ===================

set pages 25

column date1 format a12 hea "Date Created"

select count(*) "No. Backupsets", to_char(completion_time,'YYYY/MM/DD') date1

from v\$backup_set

where backup_type = 'L'

group by to_char(completion_time,'YYYY/MM/DD')

order by to_char(completion_time,'YYYY/MM/DD');

PROMPT

PROMPT END OF REPORT

PROMPT

exit

FIN

}

##########################################################################################

BackupArch ()

{

echo "Starting backup ..." >> ${WrapperLogfile}

BackupTag="ARCLG_${Today}"

LogFile=${LogfileDir}/rman_arc_${Now}.log

rman nocatalog target / <<EOF > ${LogFile}

set echo on;

run {

SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '${ArcBackupArea}/controlf_autobackup_%F';

allocate channel d1 type disk ;

allocate channel d2 type disk ;

allocate channel d3 type disk ;

allocate channel d4 type disk ;

allocate channel d5 type disk ;

allocate channel d6 type disk ;

delete noprompt archivelog until time 'trunc(sysdate - ${ArchiveLogRetention})' ;

delete noprompt backup of archivelog all completed before 'trunc(sysdate - ${ArchiveLogRetention})' ;

sql 'alter system archive log current';

backup as compressed backupset

tag=${BackupTag}

format '${ArcBackupArea}/rman_arc_%d_%t_%s_%p'

(archivelog all not backed up 2 times) ;

release channel d1 ;

release channel d2 ;

release channel d3 ;

release channel d4 ;

release channel d5 ;

release channel d6 ;

}

exit;

EOF

}

#######################################

ArchivelogReport ()

{

sqlplus -s "/ as sysdba" << FIN >> ${ReportName}

PROMPT

PROMPT ARCHIVELOG Summary:

PROMPT ===================

column date1 format a12 hea "Date Created"

select count(*) "No. Backupsets", to_char(completion_time,'YYYY/MM/DD') date1

from v\$backup_set

where backup_type = 'L'

group by to_char(completion_time,'YYYY/MM/DD')

order by to_char(completion_time,'YYYY/MM/DD');

PROMPT

PROMPT END OF REPORT

PROMPT

exit

FIN

}

##########################################################################################

CheckErrors ()

{

NumErrors=$(grep -c "RMAN-" ${LogFile})

if [ ${NumErrors} -ne 0 ]

then

echo "ERRORS were encountered !!!" >> ${WrapperLogfile}

else

echo "No errors encountered." >> ${WrapperLogfile}

}

##########################################################################################

CrosscheckBackups ()

{

echo "Performing crosscheck ..." >> ${WrapperLogfile}

rman nocatalog target / <<EOF > ${CrossscheckLogfile}

set echo on;

run {

crosscheck backupset ;

delete noprompt expired backupset ;

}

exit;

EOF

}

##########################################################################################

BackupDatabase ()

{

echo "Starting backup ..." >> ${WrapperLogfile}

BACKUP_DIR=${DBBackupArea}/${Today}

export BACKUP_DIR

if [ ! -d $BACKUP_DIR ]

then

mkdir ${BACKUP_DIR}

BackupTag="REGDB_$(date +'%Y%m%d')"

LogFile=${LogfileDir}/rman_dbf_${Now}.log

rman nocatalog target / <<EOF > ${LogFile}

set echo on;

run {

CONFIGURE CONTROLFILE AUTOBACKUP ON;

SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '${BACKUP_DIR}/controlf_autobackup_%F';

allocate channel d1 type disk ;

allocate channel d2 type disk ;

allocate channel d3 type disk ;

allocate channel d4 type disk ;

allocate channel d5 type disk ;

allocate channel d6 type disk ;

backup as compressed backupset

section size 51200M

tag=${BackupTag}

format '${BACKUP_DIR}/rman_dbf_%d_%t_%s_%p'

(database include current controlfile);

sql 'alter system archive log current';

backup as compressed backupset

format '${ArcBackupArea}/rman_arc_%d_%t_%s_%p'

(archivelog all not backed up 2 times) ;

release channel d1 ;

release channel d2 ;

release channel d3 ;

release channel d4 ;

release channel d5 ;

release channel d6 ;

}

exit;

EOF

BackupSize=$(du -sh ${BACKUP_DIR})

echo "Size of backup = ${BackupSize}" >> ${WrapperLogfile}

}

##########################################################################################

BackupAdhoc ()

{

echo "Starting backup ..." >> ${WrapperLogfile}

BACKUP_DIR=${DBBackupArea}/ADHOC

export BACKUP_DIR

if [ ! -d $BACKUP_DIR ]

then

mkdir ${BACKUP_DIR}

BackupTag="ADHOC_$(date +'%Y%m%d')"

LogFile=${LogfileDir}/rman_dbf_${Now}.log

rman nocatalog target / <<EOF > ${LogFile}

set echo on;

run {

CONFIGURE CONTROLFILE AUTOBACKUP ON;

SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '${BACKUP_DIR}/controlf_autobackup_%F';

allocate channel d1 type disk ;

allocate channel d2 type disk ;

allocate channel d3 type disk ;

allocate channel d4 type disk ;

allocate channel d5 type disk ;

allocate channel d6 type disk ;

allocate channel d7 type disk ;

allocate channel d8 type disk ;

sql 'alter system archive log current';

backup as compressed backupset database

section size 51200M

tag=${BackupTag}

format '${BACKUP_DIR}/rman_adh_%d_%t_%s_%p'

keep until time 'sysdate+182'

restore point ${BackupTag} ;

sql 'alter system archive log current';

release channel d1 ;

release channel d2 ;

release channel d3 ;

release channel d4 ;

release channel d5 ;

release channel d6 ;

release channel d7 ;

release channel d8 ;

}

exit;

EOF

BackupSize=$(du -sh ${BACKUP_DIR})

echo "Size of backup = ${BackupSize}" >> ${WrapperLogfile}

}

##########################################################################################

ExitIfAlreadyRunning ()

{

NUM=$(ps -ef |grep rman_backup.ksh|grep -v $$|grep -v grep|wc -l)

if [ $NUM -ne 0 ]

then

echo "RMAN backup is already running. Therefore, exiting here ..." >> ${WrapperLogfile}

echo "Script completed at `date`" | tee -a ${WrapperLogfile}

exit

}

##########################################################################################

HousekeepArchivelogs ()

{

ARC_COUNT=$(ls /u02/backups/rman_archivelog_backups/rman_arc* | wc -l)

echo "Number of archivelogs before deletion: ${ARC_COUNT}" >> ${WrapperLogfile}

find /u02/backups/rman_archivelog_backups -name "rman_arc*" -mtime +18 -exec rm {} \;

ARC_COUNT=$(ls /u02/backups/rman_archivelog_backups/rman_arc* | wc -l)

echo "Number of archivelogs after deletion: ${ARC_COUNT}" >> ${WrapperLogfile}

}

##########################################################################################

# MAIN PROCESSING

##########################################################################################

# Source profile, as this will run from cron

#. ~/.profile > /dev/null 2>&1

while getopts M: flag

case $flag in

M) ScriptMode=$OPTARG ;;

*) Usage; exit -1;;

esac

done

if [ "$ScriptMode" = "" ]

then

Usage

exit -1

ValidateParameters

InitialiseVariables

echo "-------------------------------------------------" | tee -a ${WrapperLogfile}

#echo " " | tee -a ${WrapperLogfile}

echo "Script starting at `date`" | tee -a ${WrapperLogfile}

echo "Mode = ${ScriptMode}." >> ${WrapperLogfile}

ExitIfAlreadyRunning

if [ "$ScriptMode" = "ARCHIVELOG" ]

then

BackupArch

if [ "$ScriptMode" = "DATABASE" ]

then

DeleteOldBackups

CrosscheckBackups

BackupDatabase

RMANReport

HousekeepArchivelogs

if [ "$ScriptMode" = "ADHOC" ]

then

BackupAdhoc

CheckErrors

echo "Script completed at `date`" | tee -a ${WrapperLogfile}

##########################################################################################

exit

##########################################################################################