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.