16.10 - Repairing Data Corruption - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

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.