Restoring With All AMPs Online - Teradata Tools and Utilities

Teradata® Archive/Recovery Utility Reference

Product
Teradata Tools and Utilities
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-06-05
dita:mapPath
fac1527114221922.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
Product Category
Teradata Tools and Utilities

It is feasible to restore even if AMPs are added to or deleted from the configuration after the archive.

Example

This example restores all databases with all AMPs online and assumes that none of the databases has journal table definitions. Journal tables must be dropped before running this job.

LOGON DBC,DBC;
DELETE DATABASE (DBC) ALL, EXCLUDE (DBC);
RESTORE DATA TABLES (DBC),
  RELEASE LOCK,
  FILE=ARCHIVE;
LOGOFF;

Run the post DBC restore script (post_dbc_restore).

LOGON DBC,DBC;
RESTORE DATA TABLES (DBC) ALL,
  EXCLUDE (DBC), (TD_SYSFNLIB),
  RELEASE LOCK,
  FILE=ARCHIVE;
LOGOFF;

Run the post data restore script (post_data_restore).

The DELETE DATABASE statement is included so that only the tables in database DBC are present. If the DELETE statement is omitted, the restore cannot finish.

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