Restore to a Teradata System Managed by Unity from a Backup | Teradata Unity - 17.00 - Restoring to a Teradata System Managed by Unity from a Backup - 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
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>'