Specific-AMP Restores - 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

Use the specific-AMP restore to restore non-fallback data tables. Only perform this recovery when the AMP to be restored is online to normal Teradata Database operations. If an archive file from a specific-AMP archive is used, Teradata ARC does not delete the current copy of any non-fallback table being restored before it restores the archive copy.

If one or more AMPs are offline during archive or restore, it might be necessary to perform specific-AMP restores after completing an all-AMPs or cluster restore. For example, if an AMP is online at the start of a restore and goes offline during the process, it might be necessary to restore some non-fallback tables to the AMP when it comes back online. If, however, an AMP is offline at the start of a restore and comes back online before the procedure completes, Teradata ARC restores subsequent non-fallback tables to the AMP. In either case, specify the NO FALLBACK TABLES option of RESTORE.