RESTORE
Purpose
RESTORE moves data from archived files to the same Teradata Database from which it was archived, or moves data to a Teradata Database other than the one used for the archive, if the database DBC is already restored. To use RESTORE to import data to the Teradata Database, the table being restored must exist on the target Teradata Database.
RESTORE between the same database version is supported. RESTORE from an older database version to a newer database version is supported. RESTORE of a newer database version back to an older database version is not supported.
Note: Beginning with TTU 13.00.00, there is support for restoring all objects as individual objects. For a complete list of objects supported by Teradata ARC, see “Appendix A Database Objects” on page 261.
Syntax
where
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 |