Restoring Data to a Smaller System - Teradata Database

Teradata Database Node Software Migration Guide

Product
Teradata Database
Release Number
16.10
Published
November 30, 2017
Language
English (United States)
Last Update
2018-04-25
dita:mapPath
bkn1504122461303.ditamap
dita:ditavalPath
5942_Migrating_1610.ditaval
dita:id
B035-5942
lifecycle
previous
Product Category
Software

Most full-system migrations involve destination systems with sufficient space for the operation. In rare exceptions, or when a disaster-recovery system is not the same configuration as the production system, the destination system may be smaller than the source system. In such cases, restoration may fail due to insufficient space.

If the destination system has insufficient space for a database, the restoration of that database fails. Additional space must be given to the database on the destination system before the database can be restored successfully. In addition, other databases included in the same restoration job that were successfully restored prior to running out of space must be restored again in order to migrate the statistics, join indexes and hash indexes. Statistics, join indexes, and hash indexes are processed during the build phase of the restoration process, and the information is kept in memory. If the restoration job fails to complete, that information is lost unless the entire restoration job is restarted. For this reason, breaking user data into multiple smaller archives in preparation for migration is recommended over creating a single archive containing all databases.

If the destination system is smaller than the source system, contact Teradata Customer Services for site-specific instructions specific to ensure a successful migration.

The GlobalDBSpace table introduced in Teradata Database Release 16.0 contains system level space accounting information to automatically increase database size by user-specified percentages. This feature resolves certain database space problems that may result when restoring data to a smaller system.