DSA Backup and Restore | Teradata DSA - 17.20 - DSA CBB Backup and Restore - BAR - Data Stream Architecture

Teradata® DSA User Guide

Product
BAR
Data Stream Architecture
Release Number
17.20
Release Date
October 2021
Content Type
User Guide
Publication ID
B035-3150-101K
Language
English (United States)

Teradata implements backups using changed block backups (CBB). With CBB, a system can run a full backup or only back up data blocks that have changed since a prior backup. This greatly reduces backup time and storage, at the cost of increased restore time. Restore time is increased because DSA has to read multiple backup save sets and construct the complete save set to restore. CBB allows cumulative or delta backups but restores must be full restores (For incremental backup and restore, see Using Incremental Restore to Maintain Your DR System). CBB backup is applicable to both standard (offline) backups and online archive.

Use cumulative and delta backups for the following:
  • Databases and tables that have a very low change rate compared to table size
  • Primary Partition Index (PPI) tables where changes are limited to one or few partitions

Three types of backups are available: full, delta, and cumulative.

Backup Types

The first backup must always be a Full backup. The full backup is the baseline for all further backups.

Full
A full backup archives all data from the specified objects. This backup takes the longest time to complete, and uses the most backup storage space. However, a full backup has the shortest restore time, since all data required to restore the objects is contained within a single backup save set.
Delta
A delta backup archives only the data that has changed since the last backup. This backup completes in the shortest time and use the least storage space. However, a delta backup increases the time to restore the database, as it may add many backup save sets that must be processed before a set of objects can be fully restored.
Cumulative
A cumulative backup archives the data that has changed since the last full backup. This backup type consolidates changes from multiple delta backups or cumulative backups before a full backup is run. A cumulative backup has a shorter database restore time than a series of delta backups, and takes less time and space than a full backup.

Guidelines for Backups

  • Regardless of the type of backup performed, the dictionary information for all objects is fully backed up. This makes sure that all non-data objects and object definitions are fully recovered in the event of a restore from any point in time.
  • In the event of a restore or analyze_validate, you select the backup save set corresponding to the point in time when you want the objects restored. This can be a full, delta, or cumulative backup save set. For a given restore point, the following save sets are processed, relative to the selected backup save set:
    • Any delta backups after the most recent full or cumulative, and the selected restore point
    • The most recent cumulative backup, if any. Only if newer than the full backup.
    • The most recent full backup

In the event of an analyze_read, only the selected save set is analyzed.

Running a cumulative or delta change block backup of a DBC ALL backup job does not include the DBC system tables. The DBC database is used when you need to restore the whole system after a system initialization (sysinit). Therefore, run a separate FULL backup of the DBC database for every CBB backup job cycle run.