Skip to content

Routine Backup Strategies (4/5) - Balanced Incremental Backups

  • by
Routine Backup Strategies (3/5) - Incremental 0+1 cumulative Backups
In this strategy, we schedule an incremental level 0 backup on Sunday night, an incremental level 1 cumulative backup on Wednesday night, and incremental level 1 differential on the other week night. It's truly an enhanced version of previous two strategies.

For more clearly demonstrate the strategy, I list the backup mode with the day of week below:
  • Sunday: Incremental level 0 backup, it's a full backup.
  • Monday: Incremental level 1 differential backup.
  • Tuesday: Incremental level 1 differential backup.
  • Wednesday: Incremental level 1 cumulative backup.
  • Thursday: Incremental level 1 differential backup.
  • Friday: Incremental level 1 differential backup.
  • Saturday: Incremental level 1 differential backup.
This strategy is try to balance the cost of backup and recovery by executing a cumulative backup on Wednesday night instead. The time consumed in backup can be shorter than previous strategies 1/5 and 3/5. And the time consumed in recovery can be shorter than strategy 2/5 in the same database.

Here are the scripts we use:

Modify the shell script. The script is able to execute the right RMAN script according to the weekday.
[oracle@primary01 rman_scripts]$ vi run_rman_daily_backup.sh
#!/bin/bash

. /home/oracle/.bash_profile
WORK_DIR=/home/oracle/rman_scripts

if [ `date +%u` = 7 ] ;
then
        EXEC_FILE=$WORK_DIR/incremental_0_full.rman
elif [ `date +%u` = 3 ] ;
then
        EXEC_FILE=$WORK_DIR/incremental_1_cumulative.rman
else
        EXEC_FILE=$WORK_DIR/incremental_1_differential.rman
fi

rman target / @$EXEC_FILE >> $WORK_DIR/backup_log_`date +%Y%m%d`.log

Routine Backup Strategies (5/5) - Incremental Image Copies

Leave a Reply

Your email address will not be published.