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;