RESTORE FALLBACK Keywords - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-01
dita:mapPath
utr1488824663491.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
lifecycle
previous
Product Category
Teradata Tools and Utilities

If this option is not specified, Teradata ARC restores only a single copy and then builds the fallback copy.

If an AMP is down during either the archive or the restore, Teradata ARC does not restore non-unique indexes.

If the RESTORE FALLBACK and NO BUILD options are both specified, one of the following occurs:

  • If the archive is for all AMPs, then Teradata ARC ignores NO BUILD.
  • If the archive and restore are both cluster level, Teradata ARC ignores NO BUILD.
  • If the table has unique indexes, the restore operation is not complete until an all-AMPs BUILD statement is applied to the fallback tables. Teradata ARC builds non-unique indexes within the cluster.

If the RESTORE FALLBACK and NO BUILD options are both specified to a cluster level archive and the restore is to all AMPs, Teradata ARC does not build indexes or revalidate the primary subtables. In this case, the table is not fully restored. To access the table using Teradata SQL, do one of the following first:

  • Perform another restore operation without the NO BUILD option and with the RESTORE FALLBACK option.
  • Perform another restore operation and apply an all-AMPs BUILD statement to the fallback tables.

When restoring a set of cluster archives to a reconfigured Teradata Database, restore each cluster archive to all-AMPs. Use the RESTORE FALLBACK option on all of the cluster restore operations or on none of the cluster restore operations. Otherwise, if the archive contains fallback tables, Teradata ARC reports an error and terminates the restore operation.

Use NO BUILD for all but the last all-AMPs restore operation. NO BUILD is optional for the last all-AMPs restore operation.

When restoring a set of cluster archives to the same configuration, always perform cluster level restore operations.

If the RESTORE FALLBACK option is specified without the NO BUILD option, the restore operation continues processing on a reconfigured system instead of restarting.

If a fallback table is being processed, this option disables the HALT and PAUSE runtime parameters until the restore completes.