A restore operation transfers database information from archive files on the client
to one of the following:
Database DBC
Database SYSUDTLIB
User database or table
All AMPs
Clusters of AMPs
Specified AMPs
An archive of database DBC contains the definition of all user databases in the Teradata
Database. Therefore, restoring database DBC to the Teradata Database automatically
defines for that system the user databases from a database DBC archive.
Restoring database DBC also restores database SYSUDTLIB automatically. SYSUDTLIB contains
the definition of all UDTs defined in the system.
These types of information are restored:
An all-AMPs dictionary tables archive of a user database contains the dictionary definitions
for each object in the database.
An all-AMPs data tables archive of a user database contains the dictionary definitions
plus any data for each object in the database.
An all-AMPs restore of a database archive automatically restores all objects from
the archive (including the dictionary definitions and any data). Similarly, a restore
of a dictionary archive restores the dictionary definitions of all objects in the
archive but no data. For a complete list of objects supported by Teradata ARC, see
“Appendix A Database Objects” on page 265.
An all-AMPS restore of selected partitions restores only the partitions specified
by the PARTITIONS WHERE condition. Dictionary, cluster, and journal restores are not
supported.
Restores of selected partitions are always to existing tables, and certain changes
to the target table definition are allowed. For more information, see “Changes Allowed to a PPI Table” on page 184.
Secondary indexes are also updated for restores.
Beginning with Teradata Tools and Utilities 13.00.00, Teradata ARC supports restoring
all objects as individual objects. For a complete list of objects supported by Teradata
ARC, see “Appendix A Database Objects” on page 265.