16.10 - Restore State - Teradata Unity

Teradata Unity User Guide

Product
Teradata Unity
Release Number
16.10
Published
January 2018
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
anz1496162519675.ditamap
dita:ditavalPath
ft:empty

When in Restore state, the Teradata Database system or table does not receive new reads or writes. During the recovery operation, Unity queued writes are processed for this Teradata Database system and new writes are added at the end of the recovery queue.

A Teradata Database system or table can enter a Restore state in the following situations:

  • During automatic recovery.
  • After a Dispatcher startup for the associated Teradata system.
  • From an Active state, if the number of writes pending for the Teradata Database system is greater than the RecoveryQueueLimit parameter.

From Restore state, a Teradata Database system or table can enter the following states automatically:

  • Active state if the recovery process is successful.
  • Interrupted or Unrecoverable state if an error occurs during recovery.

To change the state from Out of Service or Interrupted state, use the SYSTEM RECOVER command.