Restoring Using the EXCLUDE Option - TARA/ABU

Before restoring database DBC:

1 Reconfigure the system from a single AMP to the desired configuration.

2 Run the DBS Database Initialization Program (DIP) and execute the DIPERR and DIPVIEWS scripts. Do not run any of the other DIP scripts at this time, including DIPALL.

3 Use the EXCLUDE option to:

Make one database, ADMIN, and its descendants available first; and make the other databases in the system available immediately thereafter.

Exclude one large database, U12, from being restored.

Example  

In the next example, an entire system is restored from an all-AMPs archive and one specific AMP archive. File ARCHIVE is an all-AMPs archive; ARCHIVEX is a single AMP archive.

LOGON DBC,DBC;

DELETE DATABASE (DBC) ALL, EXCLUDE (DBC);

RESTORE DATA TABLES (DBC),

 FILE=ARCHIVE;

LOGOFF;

Run the post DBC restore script (post_dbc_restore).

LOGON DBC,DBC;

      RESTORE DATA TABLES (ADMIN) ALL,

        NO BUILD,

        FILE=ARCHIVE;

      RESTORE DATA TABLES (ADMIN) ALL,

        NO BUILD,

        FILE=ARCHIVEX;

      BUILD DATA TABLES (ADMIN) ALL,

        RELEASE LOCK;

      RESTORE DATA TABLES (DBC) ALL,

        EXCLUDE (ADMIN) ALL, (U12), (DBC), (TD_SYSFNLIB),

        NO BUILD,

        FILE=ARCHIVE;

      RESTORE DATA TABLES (DBC) ALL,

        EXCLUDE (ADMIN) ALL, (U12), (DBC), (TD_SYSFNLIB),

        NO BUILD,

        FILE=ARCHIVEX;

      BUILD DATA TABLES (DBC) ALL,

        EXCLUDE (ADMIN) ALL, (U12), (DBC),

        RELEASE LOCK;

      LOGOFF;

Run the post data restore script (post_data_restore).

When the operation is complete, check the output to verify that all AMPs remained online during the restore.

Restoring Database TD_SYSFNLIB

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;