Usage Notes - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-01
dita:mapPath
utr1488824663491.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
lifecycle
previous
Product Category
Teradata Tools and Utilities

An online archive is a process in which rows are archived from a table at the same time update, insert, or delete operations on the table are taking place. When an online archive is initiated on a table or a database, Teradata ARC creates a log for the specified table or a separate log for each table in the specified database. The log, which contains all changes to the table, is saved as a part of the archive process. The changes recorded in the log can be applied to any changes to the table that occurred during the archive, such as a restore operation.

Example 1: LOGGING ONLINE ARCHIVE ON

This example starts online archive logging on Table1.

LOGGING ONLINE ARCHIVE ON FOR (DatabaseA.Table1);

Example 2: LOGGING ONLINE ARCHIVE ON

This example starts online archive logging on Table1, Table2 and Table3.

LOGGING ONLINE ARCHIVE ON FOR
(DatabaseA.Table1),
(DatabaseA.Table2),
(DatabaseA.Table3);

Use LOGGING ONLINE ARCHIVE ON to start online archive logging for specified objects before submitting an archive job for those objects. After logging is started for a target table, any changed rows to that table are recorded into a log that grows until the database runs out of space or LOGGING ONLINE ARCHIVE OFF is used to end online archive logging.

Database objects can be created during online archive. The new database objects created during online archive may be included in the archive if it is a full database archive. If the new database object is a table, then that table will be archived without benefit of Online Archive, meaning that a read lock will be applied to the table at the beginning of the archive and will remain in place until the archive is complete, thereby, blocking any write transactions to that table while it is being archived.

The total number of tables that can be in an active state of online archive logging at the same time is 1,000,000.

For information on the NOSYNC keyword as it relates to Online Archive, see Archiving Online.

For tables involved in a load operation, see Archiving Online.

If any table is still enabled for Online Logging either after the archive is finished or due to a graceful abnormal termination of Teradata ARC, a warning message appears that indicates one or more tables are still enabled for online logging. For more details, see section Archiving Online.