Loading...

RMAN Example: Performing Oracle Incremental Backups

Incremental backups can be performed when the database is online.

An incremental backup contains only data that is new or has changed since the last full backup. On average, incremental backups use less media and resources than full backups.

The incremental level can be set to 0 or 1.

When the incremental level is set to 0, the backup contains the same data as a full backup, and is the baseline for subsequent level 1incremental backups. The level 1 incremental backup includes the changed data from the level 0 backup.

Before You Begin

  1. If you run the RMAN script on a UNIX environment, relink the SBT library or use PARMS in the Allocate Channel Command.
  2. Use a unique backup piece format to avoid conflicting backup piece names.
  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 {
    allocate channel ch1 type 'sbt_tape';
    allocate channel ch2 type 'sbt_tape';
    setlimit channel ch1 maxopenfiles 8;
    setlimit channel ch2 maxopenfiles 8;
    backup incremental level = 1
    filesperset = 4 format '%d_%U_%t'
    database include current controlfile;
    }

Last modified: 4/9/2018 12:49:26 PM