Differential Backups

Topics | How To | Related Topics


Overview

  • For the Oracle, DB2, DB2 DPF, Informix, and SAP iDataAgents, the incremental backup works as described below.
  • The Informix iDataAgent supports incremental backup Levels 1 and 2.
  • The incremental backup type is not supported by the Oracle Database application for 9.2 Standard Edition, and therefore is not supported by the Oracle iDataAgent. If you are using the Standard Edition of Oracle, you will need to run full backups.

A differential backup contains only the data that is new or has changed since the last full backup. Like incrementals, differential backups, on average, consume less media and place less of a burden on resources than full backups.

For most agents, differential backups are cumulative. This means that each differential backup contains all changes accumulated since the last full backup. Each successive differential backup contains all the changes from the previous differential backup. The Oracle iDataAgent, however, provides a backup option that allows you to specify whether or not you want the backup to be cumulative. The following illustration demonstrates the nature of differential backups. For simplicity, assume there is a file system that contains six files as represented in the figure. This file system and its modifications are the same as those described for Incremental Backups.

Note that the File System above could also represent database tables, Active Directory objects and attributes, etc.

Backup #1 is a full backup and therefore writes all the data to the backup media. Backups #2 through #n-1 are differential backups and only back up those files that changed since the time of the last full backup. For example, files A, B, and E changed after the full backup and were therefore backed up in Backup #2 as well as all subsequent differential backups. File C changed sometime after Backup #2 and was consequently backed up in Backup #3 and all subsequent differential backups. File F did not change; hence, it was not backed up in any of the differential backups, but it was included in both full backups, which, by definition, back up everything.

See Backup Data for an overview of all backup operations.

Back to Top