Cluster Archive vs. Dictionary Archive - Teradata Tools and Utilities

Teradata® Archive/Recovery Utility Reference

Product
Teradata Tools and Utilities
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-06-05
dita:mapPath
fac1527114221922.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
Product Category
Teradata Tools and Utilities

A cluster archive does not contain dictionary information (the data stored in the dictionary tables for the tables in the database). Create a dictionary archive:

  • Before running a cluster archive for the first time
  • Whenever modifying the structure of tables in the cluster archive

Consequently, if archiving by cluster, archive the dictionary and maintain it separately. Do not create a cluster archive of journal tables or database DBC.

Cluster archives only contain table data, therefore perform a dictionary archive for any databases or tables that are included in the cluster archive:

  1. Create the dictionary archive immediately prior to the cluster archives and then, without releasing Teradata Archive/Recovery Utility locks.
  2. Follow with a set of cluster archive requests covering all AMPs.

To restore successfully, the table data in the cluster archives must match the dictionary definition contained in the dictionary archive. A restore operation fails when it tries to restore cluster archives that do not match the dictionary archive.