Example 2: Validating 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;
RESTORE DATA TABLES (CRASHDUMPS),
RELEASE LOCK,
FILE=ARCHIVE;
LOGOFF;
The user needs to modify DBCID, USERID, and PASSWORD in the restore script accordingly before executing the script.

The above restore script performs a restore of user/database CRASHDUMPS and terminates with return code 0 as shown in the following sample output.

Sample Output: Restore

08/06/2014 08:23:34 RESTORE DATA TABLES (CRASHDUMPS),
08/06/2014 08:23:34 RELEASE LOCK,
08/06/2014 08:23:34 FILE=ARCHIVE;
08/06/2014 08:23:34 UTILITY EVENT NUMBER - 2581
08/06/2014 08:23:35 LOGGED ON 4 SESSIONS
08/06/2014 08:23:35 STARTING TO RESTORE DATABASE “CRASHDUMPS”
08/06/2014 08:23:35 DICTIONARY RESTORE COMPLETED
08/06/2014 08:23:35 “CRASHDUMPS” - LOCK RELEASED
08/06/2014 08:23:35
08/06/2014 08:23:35 STATEMENT COMPLETED
08/06/2014 08:23:35
08/06/2014 08:23:35 LOGOFF;
08/06/2014 08:23:35 LOGGED OFF 6 SESSIONS
08/06/2014 08:23:35 STATEMENT COMPLETED
08/06/2014 08:23:35
08/06/2014 08:23:35
08/06/2014 08:23:35 ARCMAIN TERMINATED WITH SEVERITY 0