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.