Copying Two Databases With Fallback - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-01
dita:mapPath
utr1488824663491.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
lifecycle
previous
Product Category
Teradata Tools and Utilities

Here, two databases are copied that have different fallback attributes:

COPY DATA TABLE (Personnel)
   (FROM (OldPersonnel), NO FALLBACK)
   ,(Finance) (NO JOURNAL)
   ,FILE = ARCHIVE;

In the example:

  • The database named Personnel is restored from an archived database named OldPersonnel with all tables defined as nonfallback after the copy operation.
  • The database named Finance is restored from an archived database also named Finance with all journaling associated with its data tables disabled.