Restoring Cluster Archives - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-01
dita:mapPath
utr1488824663491.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
lifecycle
previous
Product Category
Teradata Tools and Utilities

When restoring all AMPs from a cluster archive, restore the dictionary archive first. Restoring the dictionary archive:

  • Replaces the dictionary information for all objects being restored in the dictionary tables that reside in database DBC. For a complete list of objects supported by Teradata ARC, see Database Objects.
  • Deletes any data (excluding journals) that belong to the database or tables being restored.
  • Prevents fallback tables that are being restored from accepting Teradata SQL requests.
  • Prevents nonfallback tables with indexes that are being restored from accepting Teradata SQL requests.

Remove tables from the restoring state with the BUILD DATA TABLES statement. This statement also revalidates any existing secondary indexes. The build operation should follow the restore of all cluster archives that represent the complete archive.

To avoid duplicate rows, do not run multiple copy operations from a single cluster archive.