Oracle RMAN Incremental Backup and Merge

Prev1/1Next

With Oracle RMAN Incremental Merge, you can maintain an up-to-date image copy of an Oracle database in an application backup repository. To do so, perform the following:

Before you start working with the Oracle server, make sure you added an application backup repository to the Veeam Backup & Replication backup infrastructure and mounted the NFS share of the application backup repository on the Oracle server.

For more information, see Oracle RMAN Incremental Merge.

On the Oracle server, create an image copy of the database with a level 0 incremental backup. To do this, run the following command:

RUN {
ALLOCATE CHANNEL <channel_name> DEVICE TYPE DISK;
SQL "ALTER SYSTEM ARCHIVE LOG CURRENT";
BACKUP INCREMENTAL LEVEL 0 AS COPY DATABASE TAG '<tag_name>' FORMAT '<mount_point>/oracopy/%d_%N_%f.dbf';
BACKUP ARCHIVELOG ALL NOT BACKED UP FORMAT '<mount_point>/archlogs/%d_arch_%t_%U';
BACKUP CURRENT CONTROLFILE FORMAT '<mount_point>/controlfile/%d_ctrl.bkp' REUSE;
BACKUP SPFILE FORMAT '<mount_point>/spfile/%d_spfile.bkp' REUSE;
RELEASE CHANNEL <channel_name>;
}

where:

<mount_point> is the mount point of the application backup repository NFS share.
<channel_name> is the name of the RMAN channel. To run the backup process in parallel, you can allocate multiple channels.
<tag_name> is the tag that identifies the image copy of the database. Use the same tag for level 1 incremental backups so that Oracle RMAN merges them into this image copy.

For example:

RUN {
ALLOCATE CHANNEL ch1 DEVICE TYPE DISK;
SQL "ALTER SYSTEM ARCHIVE LOG CURRENT";
BACKUP INCREMENTAL LEVEL 0 AS COPY DATABASE TAG 'X' FORMAT '/nfsabr/oracopy/%d_%N_%f.dbf';
BACKUP ARCHIVELOG ALL NOT BACKED UP FORMAT '/nfsabr/archlogs/%d_arch_%t_%U';
BACKUP CURRENT CONTROLFILE FORMAT '/nfsabr/controlfile/%d_ctrl.bkp' REUSE;
BACKUP SPFILE FORMAT '/nfsabr/spfile/%d_spfile.bkp' REUSE;
RELEASE CHANNEL ch1;
}

Schedule regular level 1 incremental backups. During each run, Oracle RMAN will back up data blocks changed since the previous run and merge the incremental backup into the image copy. To do this, run the following command:

RUN {
ALLOCATE CHANNEL <channel_name> DEVICE TYPE DISK;
SQL "ALTER SYSTEM ARCHIVE LOG CURRENT";
BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG '<tag_name>' DATABASE FORMAT '<mount_point>/incrementbackup/%d_icr_%t_%U';
RECOVER COPY OF DATABASE WITH TAG '<tag_name>';
RELEASE CHANNEL <channel_name>;
}

where:

<mount_point> is the mount point of the application backup repository NFS share.
<channel_name> is the name of the RMAN channel. To run the backup process in parallel, you can allocate multiple channels.
<tag_name> is the tag of the image copy into which Oracle RMAN merges the incremental backup. Specify the tag that you used when you created the image copy.

For example:

RUN {
ALLOCATE CHANNEL ch1 DEVICE TYPE DISK;
SQL "ALTER SYSTEM ARCHIVE LOG CURRENT";
BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'X' DATABASE FORMAT '/nfsabr/incrementbackup/%d_icr_%t_%U';
RECOVER COPY OF DATABASE WITH TAG 'X';
RELEASE CHANNEL ch1;
}

Tip

In addition to the schedule, you can create application backup repository snapshots manually. Such a snapshot produces a restore point with the latest state of the image copy. For details, see Creating Snapshots Manually.