RMAN Example: Merging Oracle Incremental Backups

Merged incremental backups can reduce the time for Oracle database recovery and are suitable primarily for a disk based backup and recovery strategy.

The first time the RMAN script runs it creates a level 0 backup of the datafile. On subsequent runs, the script creates a level 1 incremental backup of the datafile, by using the System Change Number as a reference, and applies all level 1 backups taken since the last full backup to the image.

The RMAN script uses the tag to link the incremental backups to the image copy.

Before You Begin

1. Configure a merged incremental backup.

2. Enable the Flash Recovery Area.

   The image copy, and the incremental backups are stored in the Oracle Flash Recovery Area.

3. Optional: To have the CommCell Console authenticate the job, configure the parameters for CommCell Console third-party job authentication.

Procedure

• On the RMAN command line, run the following sample script, substituting any required or optional Oracle SBT parameters.

  For information on required and optional SBT parameters, see SBT Parameters.

  run {
  recover copy of database with tag 'incr_update';
  backup incremental level 1 for recover of copy with tag 'incr_update'
  database;
  }
  

What to Do Next

• Perform Oracle Flash Recovery Area Backups Using RMAN.