Basics of Data Restoration | Teradata Vantage - 17.10 - Basics of Data Restoration - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine Node Software Migration Guide

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Configuration
Installation
Publication ID
B035-5942-171K
Language
English (United States)

Every site has established procedures for restoring data. Use the procedures established as standard for your site.

A full system restore requires both DBC All and DBC Only backups.

Some databases and objects cannot be restored on the destination system unless the related feature has been enabled on the destination system prior to restoration. Temporal and Columnar Partitioning as well as any other feature that must be purchased separately fall into this category.

If the DBC Only restore job fails, the entire procedure needs to be repeated starting at performing a sysinit of the system again. If a data restore job fails, that job can be repeated after the problem is fixed.