RMAN Example: Performing Oracle Incremental Backups

You can run incremental backup operations 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.

You can set the incremental level to 0 or 1. An incremental backup at level 0 contains the same data as a full backup, and is the baseline for subsequent level 1 incremental backups. An incremental backup at level 1 contains data changed since the level 0 backup.

Procedure

On the RMAN command line, run the following sample script, substituting any required or optional Oracle parameters. For information on required and optional parameters, see Oracle Agentless SBT Parameters for RMAN Jobs.

run
{ 
allocate channel ch1 type sbt
PARMS="SBT_LIBRARY=<Oracle plugin location>/libcvobk_thinlibrary.so";
allocate channel ch2 type sbt 
PARMS="SBT_LIBRARY=<Oracle plugin location>/libcvobk_thinlibrary.so";
send "--cv-host <Backup host hostname> --cv-clientname <Pseudo client name> --cv-bkplvl INCR";
backup incremental level = 1 format='%d_%u' database plus archivelog delete input;
}

Loading...