The syntax of Teradata ARC control language is similar to Teradata SQL, that is, each statement is composed of words and delimiters and is terminated by a semicolon. Teradata ARC writes each statement (and a response to each statement) to an output file.
Note: For simplified descriptions of the Teradata ARC control language, refer to the Archive/Recovery chapter of the Teradata Tools and Utilities Command Summary, which provides only syntax diagrams and a brief description of the syntax variables for each Teradata client utility.
The Teradata ARC control statements perform these types of activities:
Note: Starting with TTU 15.10.00.00, the use of Permanent Journal tables is deprecated by the Teradata Archive/Recovery Utility. This includes all statements and options that are related to Journal tables that are mentioned in this Manual.
Table 19 summarizes Teradata ARC statements. For more detail, refer to the sections that follow the table.
|
Statement |
Activity |
Function |
|
Archive |
Reads an archive tape and displays content information |
|
|
Archive |
Archives a copy of database content to a client resident file in the specified format Beginning with TTU 13.00.00, there is support for archiving all objects as individual objects. |
|
|
Archive |
Builds indexes for data tables and fallback data for fallback tables |
|
|
Recovery |
Marks a journal table for later archive or recovery activities |
|
|
Archive |
Recreates copies of archived databases or objects; also restores archived files from one system to another Beginning with TTU 13.00.00, there is support for copying all objects as individual objects. Note: Triggers cannot be copied. |
|
|
Miscellaneous |
Deletes a partially restored database |
|
|
Recovery |
Deletes a saved or restored journal |
|
|
Security |
Specifies any additional logon or authentication data required by an extended security mechanism |
|
|
Archive |
Ends the online archive process |
|
|
Archive |
Begins the online archive process |
|
|
Security |
Sets the extended security mechanism used by Teradata ARC to log onto a Teradata Database |
|
|
Session Control |
Ends a Teradata session and terminates Teradata ARC |
|
|
Session Control |
Begins a Teradata session |
|
|
QUIT |
Session Control |
See LOGOFF |
|
Miscellaneous |
Releases a utility lock on a database or table |
|
|
Archive |
Restores objects from an archive file to specified AMPs Beginning with TTU 13.00.00, there is support for restoring all objects as individual objects. |
|
|
Archive |
Validates referenced indexes that have been marked inconsistent during restore |
|
|
Recovery |
Restores a database or tables to a state that existed before some change |
|
|
Recovery |
Restores a database or tables to its (their) state following a change |
|
|
Miscellaneous |
Provides values for a session to precisely identify the origins of a query. |