The size of DBCLOG can grow with the number of objects you specify in the statement and is indirectly involved with the ALL keyword for descendent databases.

Archive/recovery's first action is to write the script to restart the log file. The log file contains:

• Current statement

• Object list

• Checkpoint positioning information

• Checkpoint configuration information

Teradata RDBMS Database Administration

8 - 25Chapter 8: Archiving, Restoring and Recovering Data

Archive Routines (Recommended)

Archive Routines (Recommended)

It is recommended that you perform the following on a daily and weekly basis.

Daily Archive Routine

It is recommended that you perform the following procedure on a daily basis:

Step Action
1 Submit a CHECKPOINT WITH SAVE statement for each journal table. This appends any changes stored in the active journal subtable to the saved journal table, and initiates a new active journal subtable.
2 Archive each current journal.
3 Delete the saved journal subtable from the saved journal.

Weekly Archive Routine

It is recommended that you perform submit an all-AMPs DUMP of all data tables on a weekly basis. Note that this statement is set up so that only table is dumped each day; by the end of the week, each table is dumped once.

A restore operation transfers database information from archive files backed up on portable storage media to all AMPs, clusters of AMPs, or specified AMPs.

You can restore archived data tables to the RDBMS if the data dictionary contains a definition of the entity you want to restore.

For example, if the entity is a database, that database must be defined in the dictionary. Or, if the entity is a table, that table must be defined in the dictionary. You cannot restore entities not defined in the data dictionary.

A dictionary table archive contains all table, view, and macro definitions in the database. A restore of a dictionary archive restores the definitions of all data tables, views and macros. However, it does not restore any data.

Teradata RDBMS Database Administration

8 - 25Chapter 8: Archiving, Restoring and Recovering Data

Restore-Related Statements

Restore-Related Statements

The ARC utility provides several recovery control statements you use during restore-related operations. Each command is described in the table below.

You can invoke the ARC utility from a channel-attached MVS or VM client, a Windows 2000 client, or the main NetVault GUI (usually on the MASTER Teradata plugin machine).

Restore-Related Statement Function
ANALYZE Reads an archive tape to display information about its contents.
BUILD Builds indexes for fallback and non-fallback tables. It also builds fallback rows for fallback tables, and can build journal tables by sorting the change images. (This statement causes rehashing of V1 data restored to a V2 system.)