Cluster Archive - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-2412
lifecycle
previous
Product Category
Teradata Tools and Utilities

Cluster Archive

An alternative to archiving data tables from all AMPs into a single archive is to archive into a set of archive files called a cluster archive.

To create a cluster archive, archive the data tables by groups of AMP clusters so that the complete set of archive files contains all the data from all of the AMPs. This saves time by archiving jobs in parallel.

Cluster Archive vs. Dictionary Archive

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.

    Example

    This example assumes the system has four clusters, each consisting of two AMPs. Each archive is of two clusters. The procedure is divided into three jobs. Run Job 1 first, then run Job 2 and Job 3 in parallel. Finally, run Job 4. This example makes a dictionary archive and two cluster archives.