Backing Up and Recovering the Database › Recovery from Media Problems › UNLOAD to Tape and LOAD Back

UNLOAD to Tape and LOAD Back

If the database encountered a media problem, do the following steps to recover the database:

1. Run the SARDBASE utility UNLOAD function to unload the database to tape.

   You can run SARBCH LIST before the UNLOAD and after the LOAD, to account for any data that were lost in the process.

2. Run the SARDBASE utility ADDDS function to create a new database on alternate DASD.
3. Run the SARDBASE utility LOAD function to reload the data from tape (from the UNLOAD) to the new database.
4. If necessary, you can restore lost data from backup tapes using SARTDR TADD.

   The output from SARBCH LIST shows the tape sequence number for each SYSOUT. The tape sequence number is part of the last qualifier of the tape data set name, used by SARTDR TADD.

   Notes:

   • If many SYSOUTs are missing, you can save time by using SARDBASE RESTORE as an alternative to SARTDR TADD.
   • For more information, see the sections Minimizing Non Archival Time (earlier in this chapter), SARDBASE RESTORE Using Forward Recovery Data (later in this chapter), and SARDBASE RESTORE Without Forward Recovery Data (later in this chapter).
5. Restart the CA View archival task and resume operation.