IBM Support

Full or Incremental backups with Data Protection for Oracle

Question & Answer


Question

Level0 versus Level1 Oracle backup with RMAN

Cause

The Data Protection for Oracle product contains a library that interfaces with RMAN to redirect the data being backed up to the Tivoli Storage Manager Server. Since RMAN/Oracle controls the backup process, backup functionality is dependent on what Oracle can perform.

Answer

Oracle provides the capability for full and incremental backups (as well as saving the archive redo logs). A full backup is a backup of one (or more) data files that contain all used blocks in that data file. Blocks that have never been used are not backed up. An incremental backup is a backup of one (or more) data files that contain only those blocks that have been modified since a previous backup at the same (or lower) level.
For example: Level 0 is the basis of the incremental backup strategy and backs up all of the used blocks in the Oracle data files. The first Level 1 backup backs up those blocks that have changed since the Level 0 backup. Any subsequent Level 1 backups will back up those blocks that have changed since the previous Level 1 backup.

There is also a cumulative incremental backup (using the 'cumulative' option), which backs up all blocks that have changed since the most recent incremental backup at level N-1 or lower.
For example: Level 0 is the basis of the incremental backup strategy and backs up all of the used blocks in the Oracle data files. The first Level 1 backup backs up those blocks that have changed since the last Level 0 backup. Any subsequent Level 1 backups (with the 'cumulative' option) backs up those blocks that have changed since the original Level 0 backup.

For more information on the types of Oracle incremental backups, consult the Oracle/RMAN documentation.

[{"Product":{"code":"SSTFZR","label":"Tivoli Storage Manager for Databases"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Data Protection for Oracle","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Product Synonym

TSM

Document Information

Modified date:
17 June 2018

UID

swg21208494