Skip to content

Routine Backup Strategies (1/5) - All Full Backups

  • by
Go Back to Overview Page -Routine Backup Strategies (0/5) - An Overview
Restoring a database directly from a full backup can speed up the recovery process. Some oracle databases contain small amount of data that can be fully backed up in a short time In such case, DBA can consider the strategy to back up the database with full mode everyday for faster recovery. Here are the scripts we use:

Create a new a full backup RMAN script.
[oracle@primary01 rman_scripts]$ vi full.rman
run {
backup
full
database;
backup
archivelog all not backed up;
 }

Create the running shell script.
[oracle@primary01 rman_scripts]$ vi run_rman_daily_backup.sh
#!/bin/bash
. /home/oracle/.bash_profile
WORK_DIR=/home/oracle/rman_scripts

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

Don't forget to change mode of this shell script
[oracle@primary01 rman_scripts]$ chmod u+x run_rman_daily_backup.sh
Routine Backup Strategies (2/5) - Incremental level 0+1 Backups

Leave a Reply

Your email address will not be published.