Recovering a Specific AMP - 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 a nonfallback table with after-image journaling to a specific AMP after a disk failure, use a ROLLFORWARD statement followed by a BUILD statement of the nonfallback table.

If the nonfallback table has unique indexes, rollforward time may be improved by using the PRIMARY DATA option. This option instructs the rollforward process to skip unique secondary index change images in the journal. These indexes would be invalid from the specific-AMP restore operation, therefore the PRIMARY DATA option might save a significant amount of I/O. Revalidate the indexes following the rollforward with the BUILD statement.