Restart Log - TARA/ABU

Teradata Archive/Recovery Utility Reference

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

Restart Log

Teradata ARC does not record most of the modifications it makes to a database in the transient journal. Instead, Teradata ARC uses a file called restart log to maintain the operation status of the job being run.

The restart log catalogs the effects of utility operations on a database or table. Teradata ARC writes restart entries in the log at the beginning and end of each significant step (and at intermediate points in a long running task). If a job is interrupted for some reason, Teradata ARC uses this log to restart the archive or restore operation that was being performed.

When Teradata ARC is started, it first places markers into the restart log to keep track of the current input and logon statements. Then Teradata ARC copies the command stream to the restart log. Teradata ARC uses these commands during restart to continue with the most recent activity using the same logon user originally entered.

During a restore, Teradata ARC defers all build steps for a table until all table data has been completely restored. Then the deferred build steps are execute to completely restore the table. As each subtable is restored, the build step for that subtable is stored in an internal deferred build list in the Restart Log. If Teradata ARC must be restarted, Teradata ARC rebuilds the deferred build list from the build steps that are stored in the Restart Log for the table being restarted. Teradata ARC can store a maximum of 100 build steps per table in the Restart Log. If a table has more than 100 subtables, the build steps exceeding 100 are lost during the restart as the build steps can not be reconstructed. If a table has more than 100 subtables, and a restart is requested for that table, Teradata ARC displays message 1281, which directs the user to run a standalone BUILD statement to rebuild that table after it has been restored.