Example: Restoring Cluster Archives - 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

This example shows how to restore a cluster. The procedure is divided into three steps. Run Step 1 first, then run Steps 2 and 3 in parallel. Finally, run Step 4.

Job 1
LOGON USER1,USER1;
RESTORE DICTIONARY TABLES (USERDB),
   RELEASE LOCK,
   FILE=ARCHIVE;
LOGOFF;
Job 2 (run in parallel with Job 3)
LOGON USER1,USER1;
RESTORE DATA TABLES (USERDB),
   CLUSTER=0, 1,
   FILE=ARCHIVE;
LOGOFF;
Job 3 (run in parallel with Job 2)
LOGON USER2,USER2;
RESTORE DATA TABLES (USERDB),
   CLUSTER=2, 3,
   FILE=ARCHIVE;
LOGOFF;
Job 4
LOGON USER1,USER1;
BUILD DATA TABLES (USERDB),
   RELEASE LOCK;
LOGOFF;