#!/bin/bash
##############################################################################
# RMAN BACKUPS
##############################################################################
#
# Description: This script create a RMAN backup based on parameter passed
#
##############################################################################
#
# Author: Cyrille MODIANO
#
# Version : 1.0 (2016-07-12)
# Version : 1.1 (2016-12-15) - Added compression
# Version : 1.2 (2017-01-18) - Added parallelism and backup of a list of databases
#
##############################################################################
usage () {
echo "Usage : SID BACKUP_TYPE COMPRESSION PARALLELISM
SID : SID, comma separated list of databases or ALL for all databases (running)
BACKUP_TYPE : INCR, FULL, COLD or ARCH
COMPRESS : COMPRESS or NOCOMPRESS to compress or not the backup
PARALLEL : defines the number of channel to use
exemple backup full : rman_backup.sh db1 FULL COMPRESS 16
exemple backup arch : rman_backup.sh db1 ARCH NOCOMPRESS 2
"
}
##Variables definition
BASEDIR=$(dirname "$0")
BACKUP_BASE=/Data_Domain/oracle/prod/
LOGDIR=${BASEDIR}/log
DEST_EMAIL=example@example.com
export NLS_DATE_FORMAT='dd/mm/yyyy hh24:mi:ss'
DATE=`date +"%Y%m%d_%H%M%S"`
PATH=$PATH:/usr/local/bin
# Create directorires if not exist
mkdir -p $BACKUP_BASE/
mkdir -p $LOGDIR
mkdir -p $BACKUP_BASE/autobackup
# Validating du number of parameters passed
if [ $# -lt 4 ]; then
usage
exit 1
fi
# Parameters provided
DB_LIST=$1
BACKUP_TYPE=$2
PARALLEL=$4
# Backup type validation
case $BACKUP_TYPE in
FULL)
LEVEL="incremental level 0"
;;
INCR)
LEVEL="incremental level 1"
;;
ARCH)
LEVEL=""
;;
COLD)
LEVEL=""
;;
*)
usage
exit 1
;;
esac
# Compression validation
if [ $3 = 'COMPRESS' ]; then
COMPRESS='AS COMPRESSED BACKUPSET'
else
if [ $3 = 'NOCOMPRESS' ]; then
COMPRESS=''
else
usage
exit 1
fi
fi
##backup function
function backup_database() {
# Set Oracle Environment for database
ORACLE_SID=$1
ORAENV_ASK=NO
. oraenv
OUTPUT_SID=${ORACLE_SID}
BACKUP_DIR=$BACKUP_BASE/${ORACLE_SID}
LOGFILE=$LOGDIR/rman_backup_${ORACLE_SID}_${BACKUP_TYPE}_${DATE}.log
# Controlfile backup directory
CF_BACKUP="'$BACKUP_DIR/autobackup/cf_sp_%F'"
FORMAT_DATA="format '${BACKUP_DIR}/data_%d_${BACKUP_TYPE}_bks%s_%T_%U.bck'"
FORMAT_ARCHIVE="format '${BACKUP_DIR}/arch_%d_${BACKUP_TYPE}_bks%s_%T_%U.bck'"
if [ $BACKUP_TYPE = 'COLD' ]; then
sqlplus -s / as sysdba <<EOF
shutdown immediate;
startup mount;
exit
EOF
rman target / << EOF >> $LOGFILE 2>&1
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ${CF_BACKUP};
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET PARALLELISM ${PARALLEL};
run {
backup ${COMPRESS} database $FORMAT_DATA;
delete noprompt obsolete;
}
exit
EOF
sqlplus -s / as sysdba <<EOF
alter database open;
exit
EOF
else
if [ $BACKUP_TYPE = 'ARCH' ]; then
rman target / << EOF >> $LOGFILE
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ${CF_BACKUP};
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET PARALLELISM ${PARALLEL};
run {
backup ${COMPRESS} archivelog all $FORMAT_ARCHIVE delete input filesperset 10;
delete noprompt obsolete;
}
exit
EOF
else
rman target / << EOF >> $LOGFILE 2>&1
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ${CF_BACKUP};
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET PARALLELISM ${PARALLEL};
run {
backup ${COMPRESS} archivelog all $FORMAT_ARCHIVE delete input filesperset 10;
backup ${COMPRESS} ${LEVEL} database $FORMAT_DATA include current controlfile;
backup ${COMPRESS} archivelog all $FORMAT_ARCHIVE delete input filesperset 10;
delete noprompt obsolete;
}
exit
EOF
fi
fi
# Validate Errors in the log.
ERRORLIST=$(egrep "^RMAN-[0-9]*:|^ORA-[0-9]*:" $LOGFILE)
ERRORLIST=$(echo $ERRORLIST)
if [ -n "$ERRORLIST" ]
then
SUBJECT="$(date +%y)/$(date +%m)/$(date +%d) $(date +%H).$(date +%M).$(date +%S) - `hostname` - Backup Report ${OUTPUT_SID} - ERROR"
else
SUBJECT="$(date +%y)/$(date +%m)/$(date +%d) $(date +%H).$(date +%M).$(date +%S) - `hostname` - Backup Report ${OUTPUT_SID}"
fi
cat -v $LOGFILE | mail -s "$SUBJECT" "$DEST_EMAIL"
}
if [ $1 = 'ALL' ]; then
for database in `ps -ef | grep pmon | egrep -v 'ASM|grep' | awk '{print $8}' | cut -d_ -f3`
do
backup_database $database
done
else
for database in $(echo $1 | sed "s/,/ /g")
do
backup_database $database
done
fi
