Journal Impact on Recovery - 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

If a logical disk is damaged, data tables with local single after-image journaling might not be recovered beyond the last archived data. On the other hand, data tables with remote single after-image journaling might be recovered to the most recent transaction.

While the risks of cylinder corruption are minimal, a cylinder containing a user table and master journal, or a master index, can become corrupted. If this occurs, local journaling does not offer as much protection as remote journaling.