Archiving After Recovering a Down AMP - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
English (United States)
Last Update
Product Category

Archiving After Recovering a Down AMP

When an AMP is offline during an all-AMP archive, non-fallback tables may only be partially archived. You need to:

  • Issue the ARCHIVE statement after the AMP comes back online.
    This AMP was down during the all-AMP archive.
  • Perform a single-AMP backup.
  • Choose NO FALLBACK TABLES, to obtain a complete backup. (Fallback tables are always completely archived even if an AMP is down, because there is either a primary or fallback copy of the data on another AMP.)