NOSYNC Considerations - 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

The NOSYNC option tells Teradata ARC to handle all of the tables in a DB-level online archive request as if they were TB-level objects. Teradata ARC takes the DB-level request and breaks it down to send a TB-level online archive request for each table in the database.

By using the NOSYNC option, no read lock or access lock is placed on that database and no synchronization is done to make sure that all of the tables are enabled with online archive before access to those tables is allowed. This means that these tables do not have a single common consistency point. Each table has its own consistency point in the event of a restore. Each table restores to the state it was in when the Online Archive NOSYNC processing reached that particular table when activating the Online Archive change logs.