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

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)

Beginning with Advanced SQL Engine 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:
  • Advanced SQL Engine 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.