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

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

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
Configuration
Installation
featnum
B035-5942-170K

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.