Restoring With All AMPs Online - 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

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.