Restoring to a Teradata System Managed by Unity from a Backup - 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
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem
You can do a complete restore of all copies of a system, database, or table from a backup archive. Restoring a table, database, or system requires a complete outage of the object. Follow these steps:
  1. Use the unityadmin shell to deactivate the object so it is no longer accessible through Unity:
    Option Description
    table unityadmin -u admin -P admin -e 'object deactivate <dbtest>'
    database unityadmin -u admin -P admin -e 'database deactivate <dbtest>'
    system unityadmin -u admin -P admin -e 'system deactivate <system1>'
  2. Restore all copies of the object to the same point.
  3. Make sure all copies of the system, database, or table are in-sync.
  4. Use the unityadmin shell to activate the object so that, moving forward, all writes are recorded for the object in the Recovery Log:
    Option Description
    table unityadmin -u admin -P admin -e 'object activate <dbtest>'
    database unityadmin -u admin -P admin -e 'database activate <dbtest>'
    system unityadmin -u admin -P admin -e 'system activate <system1>'