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 Database Objects.
- 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. See Changes Allowed to a PPI Table .
- 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 Database Objects .