Validating Teradata ARC - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2412
lifecycle
previous
Product Category
Teradata Tools and Utilities

The sample scripts below can be used to validate Teradata ARC.

LOGON DBCID/USERID,PASSWORD;
ARCHIVE DATA TABLES (CRASHDUMPS)	,
RELEASE LOCK,
FILE=ARCHIVE;
LOGOFF;

Note: The user needs to modify DBCID, USERID, and PASSWORD in the archive script accordingly before executing the script.

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

Sample Output: Archive

08/06/2014 08:20:32  ARCHIVE DATA TABLES (CRASHDUMPS),
08/06/2014 08:20:32  RELEASE LOCK,
08/06/2014 08:20:32  FILE=ARCHIVE;
08/06/2014 08:20:32  UTILITY EVENT NUMBER   - 2580
08/06/2014 08:20:32  LOGGED ON   4 SESSIONS
08/06/2014 08:20:32  
08/06/2014 08:20:32  ARCHIVING DATABASE “CRASHDUMPS”
08/06/2014 08:20:33  “CRASHDUMPS” - LOCK RELEASED
08/06/2014 08:20:33  DUMP COMPLETED
08/06/2014 08:20:33  STATEMENT COMPLETED
08/06/2014 08:20:33  
08/06/2014 08:20:33  LOGOFF;
08/06/2014 08:20:33  LOGGED OFF   6 SESSIONS
08/06/2014 08:20:33  STATEMENT COMPLETED
08/06/2014 08:20:33  
08/06/2014 08:20:33  
08/06/2014 08:20:33  ARCMAIN TERMINATED WITH SEVERITY 0
 
LOGON DBCID/USERID,PASSWORD;
RESTORE DATA TABLES (CRASHDUMPS),
RELEASE LOCK,
FILE=ARCHIVE;
LOGOFF;

Note: 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