Previous Topic: SARDBASE RESTORE Using Forward Recovery DataNext Topic: Recovery Using DR Tape

Backing Up and Recovering the Database › SARDBASE RESTORE without Forward Recovery Data

SARDBASE RESTORE without Forward Recovery Data

If the database is lost or damaged, and all attempts to recover it have failed, it can be recovered from backup tapes as follows:

  1. Run the SARDBASE utility ADDDS function to create a new database.

    In cases where the old database has to be deleted due to insufficient disk requirements for the new database, provide an alternate means of backup for the database, such as FDR or DFDSS.

  2. Run the SARDBASE RESTORE function.

    If you have specified the 'ASYNCH' keyword on the RESTORE statement, the SARDBR17 console message notifies you when the preliminary phase has completed. You can now bring up the CA View started task to resume archival. An alternative is to restore only the master index, and then use SARRSP and/or SARTDR TLOAD to restore the SYSOUT data.

    The SARDBASE RESTORE JCL must specify a SARRECV or SARTAPE DD statement for purposes of locating the backup tapes.

    Note: Perform the RESTORE operation against a newly created, empty database. It is not necessary to reinstate any initialization parameters because these parameters are recovered during the restore process.

  3. Run SARDBASE BLOAD to load the banner pages into the new database.
  4. Run SARDBASE OLOAD to load the panel, message, and skeleton JCL online members into the new database.
  5. If the old database was not used in the restore process, run either SARRSP or SARTDR TLOAD to load the SYSOUT data; you can: