Use Incremental Restore to Maintain Your DR System | Teradata DSA - 17.20 - Using Incremental Restore to Maintain Your DR System - BAR - Data Stream Architecture

Teradata® DSA User Guide

Data Stream Architecture
Release Number
November 2022
English (United States)
Last Update

Beginning with Analytics Database 16.20 Update 2, DSA allows incremental restores (IR) using delta and cumulative backup save sets. The primary use case for this feature is for keeping two systems in sync; for example, regular and disaster recovery systems. Incremental restore allows a delta or cumulative backup to be restored without including a full backup in the same restore job. This feature reduces restore time compared to the standard change block implementation of only allowing full restores. To prevent corruption and keep the systems in sync, incremental restore leaves the table in a read-only state.

Requirements for Incremental Restore

These criteria must be met:
  • Analytics Database 16.20 Update 2
  • Both the source and target database must have incremental restore enabled.
    Important: Teradata Support must enable incremental restore on the databases.
  • Both the backup and the restore job must have incremental restore enabled.

Options for Incremental Restore

From an IR-enabled backup, you can select the following three types of restores:
  • Next incremental restore: Restores the next save set after the last one that was restored.
  • Specify a version (Full): Restores from the selected save set to the last full save set.
  • Latest version (Full): Standard CBB restore, from the last available CBB save set to the last full backup.