Skip to content
Home » Oracle » Routine Backup Strategies (1/5) - All Full Backups

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

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 {
archivelog all not backed up;

Create the running shell script.
[oracle@primary01 rman_scripts]$ vi
. /home/oracle/.bash_profile

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
Routine Backup Strategies (2/5) - Incremental level 0+1 Backups

Leave a Reply

Your email address will not be published. Required fields are marked *