Before restoring database DBC:
- Reconfigure the system from a single AMP to the desired configuration.
- 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.
- 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.