The restore operation can occur even if AMPs have been added to or deleted from the configuration since the archive was taken.
1 Reconfigure the system from a single AMP to the desired configuration (optional).
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 IUMB document 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 the “Data Migration documents” section of the table on page 7, under “Additional Information.”
3 Restore all AMPs by performing the operation described in “Restoring With All AMPs Online” on page 64.
4 When the offline AMP is returned to online operation, perform a specific-AMP restore for that AMP.
Example
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” on page 67 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.