When in Restore state, the database system or table does not receive new reads or writes. During the recovery operation, queued writes are processed for this database system and new writes are added at the end of the recovery queue.
A 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 database system is greater than the RecoveryQueueLimit parameter.
From Restore state, a 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.