How to Use Standard Offline Backup | Teradata Unity - Using Standard Offline 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
dita:id
B035-2520
Product Category
Analytical Ecosystem

Unity allows applications to run on a second Teradata system while the offline backup has tables locked.

Use the unityadmin shell.

  1. Start a Read-only outage on the table, database, or system that you want to archive:
    Option Description
    table unityadmin -u admin -P admin -e 'object freeze <db.tablename> on <system_name>'
    database unityadmin -u admin -P admin -e 'database freeze <db_name> on <system_name>'
    system unityadmin -u admin -P admin -e 'system freeze <system_name>'
    For example, to begin an outage on a table named 'dbtest.table1' on Teradata 'system1', enter the following: unityadmin -u admin -P admin -e 'object freeze dbtest.table1 on system1'
  2. Recover the system, database, or table:
    Option Description
    table unityadmin -u admin -P admin -e 'object recover <db.tablename> on <system_name>'
    database unityadmin -u admin -P admin -e 'database recover <db_name> on <system_name>'
    system unityadmin -u admin -P admin -e 'system recover <system_name>'