Archiving or Restoring a Down Table - Teradata Database

Archiving or Restoring a Down Table

During an archive operation, the system checks the table header to verify if it contains any down status or down region information. If there is a down subtable or down region, it reports an error to ARCMAIN.

When archiving a table that is marked down or contains down regions, ARCMAIN either aborts the archive operation if it is a table-level archive, or skips the table and proceeds with the next object if it is a database-level archive operation. (In other words, in a multitable archive operation such as a database, cluster, or AMP archive, when the system encounters an error of down subtable or down region, ARCMAIN skips the table and proceeds with the next object.)

If you encounter an error message from ARCMAIN about a down region, do one of the following:

Run CheckTable utility at level 3 to identify possible table corruption.

Repair the down regions or reset the down status of the table or index.

Restore the down table or index status before running the archive operation again.

Then use the ALTER TABLE tablename RESET DOWN statement, and the system will delete the down regions of that table from the table header on each AMP.