Repair Data Corruption | Teradata Vantage - 17.00 - 17.05 - Repairing Data Corruption - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

Table Rebuild is a utility that repairs data corruption. It does so by rebuilding tables on a specific AMP vproc based on data located on the other AMP vprocs in the fallback cluster.

Table Rebuild can rebuild data in the following subsets:

  • The primary or fallback portion of a table
  • An entire table (both primary and fallback portions)
  • All tables in a database
  • All tables that reside on an AMP vproc

Table Rebuild performs differently based on the type of table (for example, fallback or not).

Type of Table Action
Fallback Tables Delete the table header (one row table which defines a user data table)

Delete specified portion of the table being rebuilt

Rebuild the table header

Rebuild the specified portion of the table

Non-fallback Tables Delete the table header.

Rebuild the table header.

Permanent Journal Tables Delete data for the table being rebuilt.

Rebuild the table header.

Locks the table pending rebuild.

You must restore non-fallback data.
You can start REBUILD when the failed AMP has been fixed and brought back to the OFFLINE state.