RMAN Backup script

Latest posts by Cyrille Modiano (see all)

This is a sample backup script I used, it has already a lot of options. Feel free to make any modification you want. If you add some good enhancements, let me know I can put them here so everybody can profit from them.

RMAN Backup script

#!/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

27 thoughts on “RMAN Backup script

  1. Hi Cyrille

    Great script

    Maybe add some “mkdir -p” to create the required directories.

    I found these missing:

    $BACKUP_BASE/log
    $BACKUP_BASE/
    $BACKUP_BASE//autobackup

    sure I can create them, but nice if I didn’t have to 🙂

    1. Hi Allan,

      Thank you for your feedback, I’m glad you found the script useful.
      I don’t have a similar one for restore operations, there are too many specificities.

      Cyrille

  2. Hi Cyrille,

    Script is very nice, Please let me know if you have done any updates to the script recently.

  3. Thanks. maybe email address can be set into variable declared early in the script (near BACKUP_BASE). Easy for new comer (most of newbies copy paste without reading through the whole script). And also easier to change it later 🙂

  4. Hi Cyrille,

    In these script you’re backup the database on the same filesystem the databse are, right ?

    Is it possible to backup to another filesystem (like /backup) ?

    Thanks and regards,

    Mitch

  5. Hi Cyrille,

    When I try to lauch the scripts, I’ve an error:

    oracle@server[]:/outils/scripts
    # ./backup_rman_mitch.bash PROD FULL COMPRESS 1
    ./backup_rman_mitch.bash: ./log/rman_backup_PROD_FULL_20181112140441.log: No such file or directory
    egrep: can’t open ./log/rman_backup_PROD_FULL_20181112140441.log
    cat: cannot open ./log/rman_backup_PROD_FULL_20181112140441.log

    Do you have an idea ?

    Regards,

    Mitch

  6. Hi Cyrille,

    Thanks for your help, but I always got an error:

    oracle@server[]:/outils/scripts
    # ./backup_rman_mitch.bash PROD FULL COMPRESS 1
    ./backup_rman_mitch.bash: /log/rman_backup_PROD_FULL_20181112150007.log: Permission denied
    egrep: can’t open /log/rman_backup_PROD_FULL_20181112150007.log
    cat: cannot open /log/rman_backup_PROD_FULL_20181112150007.log

    Regards,

    Mitch

  7. Hi Cyrille,

    Same error:

    oracle@server[]:/outils/scripts
    # ./backup_rman_mitch.bash PROD FULL COMPRESS 1
    ./backup_rman_mitch.bash: /log/rman_backup_PROD_FULL_20181112_151212.log: Permission denied
    egrep: can’t open /log/rman_backup_PROD_FULL_20181112_151212.log
    cat: cannot open /log/rman_backup_PROD_FULL_20181112_151212.log

    Regards,

    Mitch

  8. Hi Cyrille
    This is a very effective script Thanks for the effort , However , if you could add a feature of multiple database backups getting triggered on same database if current one is running …?

  9. Hello. the command “mkdir -p $BACKUP_BASE/autobackup” is redundant, that directory is not used. There should be “mkdir -p ${BACKUP_DIR}/autobackup” in function backup_database

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.