Restoring with One AMP Offline - 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

The restore operation can occur even if AMPs have been added to or deleted from the configuration since the archive was taken.

  1. [Optional] Reconfigure the system from a single AMP to the desired configuration.
  2. Run the DBS Database Initialization Program (DIP) and execute the DIPERR and DIPVIEWS scripts. Do not run any of the other DIP scripts at this time, including DIPALL.

    See the Teradata Database Node Software Migration Guide (B035-5924) for information on running DIP. Please view the specific version of this document that matches the database version that you are restoring to. For instructions on how to access the Data Migration documents, see Supported Releases

  3. Restore all AMPs by performing the operation described in Restoring With All AMPs Online.
  4. When the offline AMP is returned to online operation, perform a specific-AMP restore for that AMP.

Example: Restoring with an AMP Offline

This example performs a specific-AMP restore for an AMP that was offline during the all-AMP restore.

LOGON DBC,DBC;
      RESTORE NO FALLBACK TABLES (DBC) ALL,
        AMP=1,
        EXCLUDE (DBC), (TD_SYSFNLIB),
        RELEASE LOCK,
        FILE=ARCHIVE;
      LOGOFF;

When the operation is complete, check the print file to verify that all AMPs remained online during the restore. If one or more AMPs went offline, see Restoring With AMPs Offline for more information.

To decrease the total time required to complete the restore process, specify the NO BUILD option for the restore operation, then submit a BUILD statement after the specific AMP restore. In addition, unique secondary indexes remain valid on nonfallback tables.