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