Backing Up and Recovering the Database › Recovery from Media Problems › COPY Disk-to-Disk

COPY Disk-to-Disk

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

1. Run the SARDBASE utility ADDDS function to create a new database on alternate DASD.
2. Run the SARDBASE utility COPY function to copy the data from the old (damaged) database into the new database.

   You can run SARBCH LIST on the old and new databases, to account for any data that were lost in the process.

3. 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 (later in this chapter), SARDBASE RESTORE Using Forward Recovery Data (later in this chapter), and SARDBASE RESTORE Without Forward Recovery Data (later in this chapter).
4. After SARTDR TADD has run, run SARDBASE VERIFY to build the alternate index, used for date selection.
5. Restart the CA View archival task and resume operation.