16.10 - OBJECT RECOVER - 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

Purpose

Replays the Recovery Log to bring the Unity managed table object from an Out of Service, Interrupted, or Read Only state to Active state without requiring manual intervention by an administrator to restore the data. If the recovery operation is unsuccessful, the table object changes to the Interrupted or Unrecoverable state depending on the error.

Syntax

OBJECT RECOVER {tablename [,tablename,...] [ON tdpid [, tdpid, ...]]} [ REASON reason];

Parameters

tablename
The fully qualified table name if you are attempting to change the state of a table. You may enter multiple table names.
tdpid
Unique identifier (TDPID) of a Teradata Database system.
REASON
Reason for clearing. Use single quotation marks when the reason is more than one word.

Usage Considerations

  • To restore a Unity managed table object to Active state, you must synchronize the data outside of Unity or if all writes were done through Unity, synchronize the table through recovery processing.
  • If the Unity managed table object cannot recover successfully due to a transient error, then the table object remains in Interrupted state, which raises an alert. After resolving the error, retry the recovery.
  • If Unity cannot successfully recover the Unity-managed table object due to data consistency issues, then the table object enters Unrecoverable state.

Example

unityadmin>  OBJECT RECOVER db1.obj9333 ON sys1;