Restoring Database TD_SYSFNLIB - 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

When doing a full system restore (RESTORE DATA TABLES (DBC) ALL), database TD_SYSFNLIB must be excluded from the restore. If database TD_SYSFNLIB is not excluded, the restore job aborts with the following error message:

*** Failure 9806:Invalid Restore of database TD_SYSFNLIB.

The correct syntax for a full system restore is:

 LOGON DBC,DBC;
      RESTORE DATA TABLES (DBC) ALL,
        EXCLUDE (DBC), (TD_SYSFNLIB),
        RELEASE LOCK,
        FILE=ARCHIVE;
      LOGOFF;

Since you cannot restore database TD_SYSFNLIB, you must run the 'dipudt' DIP script after restoring the rest of your data to recreate and repopulate database TD_SYSFNLIB.