16.20 - Incremental Restore for Data Stream Architecture (DSA) - Teradata Vantage NewSQL Engine

Teradata Vantage™ NewSQL Engine Release Summary

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Release Notes
featnum
B035-1098-162K
Incremental restore for Data Stream Architecture (DSA) enables a delta backup or cumulative backup to be restored to the system without including a full archive in the same restore job. The delta or cumulative backup is restored on top of a previous full, delta, or cumulative restore.
By default, this feature is disabled. Contact Teradata Support to have it enabled.

To enable databases and tables so archives support incremental restores, you use the new SQL statement LOGGING INCREMENTAL ARCHIVE ON FOR object_list. To disable databases and tables so that archives cannot be incrementally restored, you use the new SQL statement LOGGING INCREMENTAL ARCHIVE OFF FOR object_list.

By default, databases and tables are in a read-only state after incremental restores. To enable read and write access for databases and tables, you use the new SQL statement INCREMENTAL RESTORE ALLOW WRITE FOR object_list.

Benefits

Incremental restore improves the performance of restoring Disaster Recovery (DR) systems. If the full archive has already been restored to another target system, you do not have to restore the full archive again on the target system.

Considerations

By default, this feature is disabled. Contact Teradata Support to have it enabled.

SQL Changes

Incremental restore for DSA includes the following new SQL statements:
  • INCREMENTAL RESTORE ALLOW WRITE FOR object_list
  • LOGGING INCREMENTAL ARCHIVE ON FOR object_list [DELETE LOG ROWS]
  • LOGGING INCREMENTAL ARCHIVE OFF FOR object_list

Additional Information

  • Teradata Vantage™ SQL Data Definition Language Syntax and Examples, B035-1144
  • Teradata® DSA User Guide, B035-3150