Example 2: Restore Script - 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
LOGON DBCID/USERID,PASSWORD;
ARCHIVE DATA TABLES (DB1) ALL,(DB2),
RELEASE LOCK,
FILE=ARCHIVE;
LOGOFF;

This script performs these restore operations:

  1. ARCMAIN logs on to a Teradata Database pointed to by database DBCID.
  2. ARCMAIN places Host Utility (HUT) locks on the databases to be restored before starting the restore operation.
  3. The database’s DB1, all its descendent databases, and DB2 are restored. The operation is performed database by database in alphabetical order.

    For each database, these operations are performed table by table in alphabetical order:

    • Primary data is restored.
    • If applicable, fallback and index data are built from primary data.
  4. The RELEASE LOCK option releases the HUT locks after the restore of each database is complete.
  5. After all databases are restored, the LOGOFF command disconnects ARCMAIN from the Teradata Database.