Fully Restoring the TransactionHistory Table - Teradata Tools and Utilities

Teradata® Archive/Recovery Utility Reference

Product
Teradata Tools and Utilities
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-06-05
dita:mapPath
fac1527114221922.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
Product Category
Teradata Tools and Utilities

  1. Perform a complete restoration of the full-table archive:
    RESTORE DATA TABLES
        (SYSDBA.TransactionHistory),
    RELEASE LOCK,
    FILE=ARCHIVE;
  2. Perform a full restoration of the differential and incremental archives (in order):
    RESTORE DATA TABLES(SYSDBA.TransactionHistory) (ALL PARTITIONS),
    RELEASE LOCK,
    FILE=ARCHIVE;
  3. (Optional) If a separate partition backup is performed due to an update of a non-active partition, restore the separate partition backup after (or instead of) the differential or incremental backup that contains the updated partition:
    RESTORE DATA TABLES
        (SYSDBA.TransactionHistory)
          ( PARTITIONS WHERE
            (! TransactionDate = DATE ‘2004-03-15’
              !) ),
    RELEASE LOCK,
    FILE=ARCHIVE;
Individual partitions can also be restored from a full-table or selected-partition archive. To restore individual partitions, specify the partitions to be restored in a PARTITIONS WHERE expression:
RESTORE DATA TABLES
 (SYSDBA.TransactionHistory)
   ( PARTITIONS WHERE
    (! TransactionDate BETWEEN DATE ‘2004-05-01’ AND DATE ‘2004-05-31’!)
    ),
      RELEASE LOCK,
      FILE=ARCHIVE;