NO BUILD Option - 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

When restoring cluster archives to all-AMPs, use the NO BUILD option on each cluster restore operation. If the NO BUILD option is omitted, Teradata ARC prints a warning and enables the option automatically. After all the cluster archives have been restored, a BUILD statement will need to be run.

If an all-AMPs archive with nonfallback tables is restored to all AMPs, and the all-AMPs archive is missing an AMP that has a specific-AMP archive, restore the all-AMPs archive using the NO BUILD option. In this case, nonfallback tables are not revalidated. Following completion of the restore of the all-AMPs archive, restore the specific-AMP archive to all AMPs. Then follow this specific-AMP archive restore with a build operation.