RESTORE and COPY are the two ARC commands that move data from an archive to a Teradata Database system. However, only the RESTORE command can be used for full-system migrations.
RESTORE Job Scripts
The following table provides some examples of the commands that might be included in your restore job scripts. These are only the ARC commands and are not complete scripts.
|If you have permanent journals, re-create the journal dictionaries using these commands that exclude database DBC. The journal data is not restored.||
RESTORE DICTIONARY TABLES ALL FROM ARCHIVE,
|Commands to restore the data tables without restoring database DBC and other databases that are recreated by DIP scripts.
These commands restore user databases, secondary indexes, and fallback.
RESTORE DATA TABLES (DBC) ALL,
EXCLUDE(DBC), EXCLUDE(TD_SYSFNLIB), EXCLUDE(CRASHDUMPS), EXCLUDE(DBCEXTENSION), EXCLUDE(SYSBAR), EXCLUDE(SYSLIB), EXCLUDE(SYSSPATIAL), EXCLUDE(SYSUDTLIB),
|Release the host utility locks with this command.||RELEASE LOCK (DBC) ALL;|
|You must revalidate referential constraints with these commands.||
REVALIDATE REFERENCES FOR (DBC) ALL,
EXCLUDE (DBC), (TD_SYSFNLIB)