Rebuilding and Restoring the Shadow Database

This procedure must be selected on the new live database.

Having reconfigured the Shadow as the live database using Database Recovery option 1, this procedure enables you to reconfigure the failed database as the new Shadow.

Procedure

1. Select option 2 on the Database Recovery menu. A message is then displayed describing the purpose of the procedure — enter y  to continue.

2. If the failed database is already enabled, the procedure to re-build the new Shadow Database is started immediately

   On a UNIX system, if the failed database is disabled, you are first asked if you want to run the file system check utility fsck to check and repair errors on the partition. If you ask to run fsck, you are then asked for the superuser (root) password — the partition is checked/repaired. Once the database is consistent, the partition is enabled and the procedure to re-build the new Shadow Database is started.

   On a Windows system, the partition is enabled and the procedure to re-build the new Shadow Database is started.

3. The re-build procedure starts with the warning prompt:

   WARNING: This will clear database 'databasePath'
   Are you sure you wish to clear it [Y/N] ?

   Enter y  to remake the database. This clears the Shadow and rebuilds an empty database, retaining the configuration parameters of the old database.

4. Once the database has been successfully rebuilt, you are then asked if you wish to perform a restore in order to recover the Shadow from the last database save. Enter y  to continue with the restore.
5. Except if the Physical Save option was selected when defining the backup method used by tlmenu, before continuing with the restore, you are given the option to resize files during the restore. If you select this option, the size of those files (modulo), which have previously been set up for resizing, will be changed during the restore. For details on setting up file resizing parameters, refer to User's Reference: General. Note however that selection of this option may slow down the restore process considerably.

6. The procedure continues, depending on which backup method is configured for tlmenu operation (described in Backup Methods used by tlmenu):

   • If the Multi-Deck Save and Restore utility is configured as the backup method, you are prompted to start the restore.

   • If FILE-SAVE is configured as the backup method, a list of tape units configured on the database is displayed, followed by the prompt:

     Enter tape unit for Restore (tape_unit) :

     Enter the number of the tape device to be used to restore the save. A message similar to the following is displayed:

     Mount Save tape on tape unit tape_unit
     Are you ready to start the restore (y/n/q) ? :

     Ensure that the most recent backup tape is mounted in the specified tape device and that the device is on-line, then enter y. The tape is read and the tape label displayed for you to make sure that it is the correct tape. You are then prompted to confirm that the tape is correct.

7. If the correct tape is mounted, then enter y  to execute the procedure. The restore is then executed, ending with the message:

   Now select option 3 to restore the Clean Log(s)
   and then secure the shadow database

   This returns you to the Database Recovery menu. Now use option 3 to restore clean logs onto the rebuilt Shadow.