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

Teradata® DSA User Guide

Product
BAR
Data Stream Architecture
Release Number
17.10
Published
April 2022
Language
English (United States)
Last Update
2022-04-08
dita:mapPath
het1611950545663.ditamap
dita:ditavalPath
vwp1576617377804.ditaval
dita:id
B035-3150
lifecycle
previous
Product Category
Software
Teradata Tools and Utilities

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.