Restoring With One AMP Offline
The restore operation can occur even if AMPs have been added to or deleted from the configuration since the archive was taken.
To restore with an AMP offline:
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 Migrating Data to Teradata Database release ##.# document for information on running DIP. Release ##.# is the Teradata Database version you are restoring to. For instructions on how to access the Data Migration documents, see “Additional Information” on page 5.)
3 Restore all AMPs by performing the operation described in “Restoring With All AMPs Online” on page 60.
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 62 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.