OBJECT RECOVER Command | unityadmin | Teradata Unity - OBJECT RECOVER - Continuous Availability - Teradata Unity

Teradata® Unity™ User Guide

Product
Continuous Availability
Teradata Unity
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2020-09-15
dita:mapPath
fmz1594836948704.ditamap
dita:ditavalPath
qqk1595871525984.ditaval
dita:id
B035-2520
Product Category
Analytical Ecosystem

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;