RESTORE - TARA/ABU

Syntax Element

Description

DATA TABLE or DATA TABLES

Restores both fallback and non-fallback tables to all AMPs or clusters of AMPs

DICTIONARY TABLE or DICTIONARY TABLES

Restores only dictionary rows

This option is only allowed for:

NO FALLBACK TABLE or NO FALLBACK TABLES

Restores tables without fallback to complete a previous all-AMPs or cluster restore where AMPs were offline, or to restore non-fallback data to specific AMPs recovering from disk failure

JOURNAL TABLE or JOURNAL TABLES

Restores an archived journal for subsequent use in a roll operation

ALL FROM ARCHIVE

Specifies that all databases and tables in the given archive file will be restored and that any existing databases and tables will be overwritten

This option is used in place of database/table names normally specified.

No other database or table names can be specified to be restored with this option.

(dbname)

Name of the database to restore

This form restores all tables of the type specified, and all stored procedures (if specified type is FALLBACK) that are in the named database and on the input file.

ALL

Restores the named database and all descendants

(dbname.tablename)

Name of a table within the named database to restore

All tables should be distinct within the list. Duplicate table names are ignored.

EXCLUDE

Prevents specified databases from being restored

(xdbname)

Name of database to exclude from restore

ALL

Excludes the named database and all descendants

(xdbname1) TO (xdbname2)

Alphabetical list of client databases to exclude from the restore

The delimiting database names need not identify actual databases.

Database DBC is not part of a range.

CLUSTERS = nnn or CLUSTER = nnn

Specifies AMP clusters to restore

nnn is the cluster number.

Specify up to 4096 clusters.

AMP = n

Specifies the AMP (or a list of AMPs) to restore for Teradata Database, where n is the number of the AMP

Specify up to five AMPs with this option.

RESTORE FALLBACK

Restores the fallback copy of primary and unique secondary indexes while restoring the data

This option applies only to data table restores of fallback tables.

Note: When the RESTORE FALLBACK option is specified and the system formats or hash functions of the source and target systems are different. Teradata ARC disables the RESTORE FALLBACK request.

NO BUILD

Prevents the Fallback and Secondary Index rows from being created

If NO BUILD is requested when restoring database DBC, the request will be ignored.

If the NO BUILD keywords are used during a RESTORE statement, a separate BUILD statement must be run for all databases and/or tables that were restored. The tables will not be accessible until a BUILD statement is run.

RELEASE LOCK

Releases utility (HUT) locks on the named databases when the restore completes successfully

ABORT

Aborts the restore if an AMP to which a non-fallback table is to be restored is not online

This option affects only an all-AMPs restore. It does not affect a specific AMP restore.

EXCLUDE TABLE or EXCLUDE TABLES

prevents individual objects in the listed database from being restored

(xtablename)

Name of an individual object in the designated database to exclude

Multiple objects are separated by commas.

This form (without a database name prefix) is used only when ALL has not been specified for the current object.

(xdbname.xtablename)

List of fully qualified objects (prefixed by database name) to exclude

PARTITIONS WHERE

Specifies the conditional expression for partition-level operations

(!conditional expression!)

The conditional expression for specifying selected partitions

LOG WHERE

Specifies the rows that are logged to an error table for manual insertion and deletion

(!conditional expression!)

The conditional expression for specifying rows to log to the error table when restoring selected partitions

ALL PARTITIONS

Restores all archived partitions for an archived PPI object

QUALIFIED PARTITIONS

Restores the same partitions specified in a previous selected-partition restore

ERRORDB and ERRORTABLES

Specifies the location of the error log for partition-level operations

DBSIZEFILE

Prompts Teradata ARC to read the file specified in filename for the desired perm space for each specified database or user

“Resizing the Teradata Database with DBSIZEFILE” on page 236 has more information.

filename

Specifies the name of the text file that contains pairs of database or user names and sizes

The information is used in resizing a database.

SKIP JOIN INDEX

Skip the restore of join and hash indexes

SKIP STAT COLLECTION

Skip the restore of Stat Collections