Teradata Database versions prior to 14.00
*** Warning 9136: Online archive logging cannot be enabled on one or more tables.
Error code 9136 is returned by the DBS for one of the following conditions:
The table is a MultiLoad or FastLoad target table that was aborted in the apply phase
The table is an aborted multiload work table
When Teradata ARC receives the 9136 error code, Online Logging is not enabled on the table and when Teradata ARC attempts to archive the table, the table will be skipped.
Although the table is skipped, the table header will still be archived but no data is archived. When the table is restored from the archive file, only the table header is restored, resulting in an empty table after the restore or copy operation.
NOSYNC Considerations
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.