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, as described in this document.
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.
Example | Commands |
---|---|
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,
RELEASE LOCK, FILE=JNLARCH: |
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 LOCK, FILES=ARCHIVE; |
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) RELEASE LOCK; |
Restore Warning Messages
-
ARC0727 CREATE Stat Collection failed with error %s: %s.
Explanation: An error was encountered while trying to recreate a Stat Collection. The error will include the error number and text returned by the Teradata system.
For Whom: User
Notes: Non-Fatal Error
Remedy: Either resolve the Teradata error that was displayed in the ARC log and reattempt the restore, or recollect statistics on the table and column(s) specified in the SQL information provided in the ARC log.
-
ARC0728 Stat Collection can not be recreated during a cluster restore. Stat Collections should be restored from this archive after all cluster restore and build steps have been completed.
Explanation: During the dictionary part of a cluster restore, ARC cannot recreate stat collection information, since the data has not yet been restored to the tables. ARC must defer recreating the stat collection until after the data for all tables has been restored.
For Whom: User
Notes: Non-Fatal Error
Remedy: After the cluster restore and build steps have been completed, the user needs to manually recollect the statistics.
-
ARC0729 SHOW Stat Collection query failed with error %s: %s.
Explanation: An error was encountered while trying to query the definition for a stat collection. The error will include the error number and text returned by the Teradata system.
For Whom: User
Notes: Non-Fatal Error
Remedy: Either resolve the Teradata error that was displayed in the ARC log and reattempt the restore, or recollect statistics on the table and column(s) specified in the SQL information provided in the ARC log.
-
ARC0730 Stat Collection query failed with error %s: %s.
Explanation: An error was encountered while trying to query the list of SC indexes from the StatsV view in database DBC. The error will include the error number and text returned by the Teradata system.
For Whom: User
Notes: Non-Fatal Error
Remedy: Either resolve the Teradata error that was displayed in the ARC log, or recollect statistics on the table and column(s) specified in the SQL information provided in the ARC log.