Backing Up and Recovering the Database › Recovery Using DR Tape

Recovery Using DR Tape

If the database is lost or damaged, and all attempts to recover it have failed, it can be recovered using the DR tape as follows:

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

   Note: For more information about SARDBASE, see chapter "Database Utilities." Sample JCL for this function can be found in CVDEJCL member BRMADDS.

2. Run SARTCP to map your latest DR tape.

   Note: For more information about SARTCP, see the chapter "Database Utilities."

   The tape map displays the INDEX file as the last file on the tape. The file number of the INDEX is specified as the file number on the SARTAPE DD in next step. Sample JCL for this function can be found in CVDEJCL member HBRMTCPM.

3. Run the SARDBASE RESTORE function.
   • If the file number of the index file is less than 10000

     The SARDBASE RESTORE JCL must leave out the SARRECV DD statement and use a SARTAPE DD statement to specify the DR tape DSN and INDEX file number. This information was obtained in the previous step. Sample JCL for this function can be found in CVDEJCL member HBRMREST.

   • If the file number of the index file is greater than 9999

     Use the SARRCOV utility to create a recovery file that contains the DSN of the DR tape and the file number of the index. This information was obtained in the previous step.

     Note: For more information about SARRCOV, see the chapter "Database Utilities." Sample JCL for this function can be found in CVDEJCL member HAEXRCOV

     The SARDBASE RESTORE JCL must leave out the SARTAPE DD statement and use a SARRECV DD statement to specify the name of the recovery data set. Sample JCL for this function can be found in CVDEJCL member HBRMREST.

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

4. Run the SARDBASE utility OLOAD function to load all online members to the new database. Sample JCL for this function can be found in CVDEJCL member HBRMOLOD.
5. Run the SARDBASE utility BLOAD function to load all banner members to the new database. Sample JCL for this function can be found in CVDEJCL member HBRMBLOD
6. This step assumes you are at your DR site and Primary or Duplex tapes are not available. Run SARINIT and specify DRTAPE=ACTIVE. It lets CA View to access the tape copy of reports from the DR tape rather than the Primary or Duplex tape. For more information about DRTAPE, see the chapter "Initialization Parameters."
7. Run either SARRSP or SARTDR TLOAD to load the SYSOUT data. For more information, see the chapter "Database Utilities." Samples JCL for these utilities can be found in CVDEJCL members HAEXTDR and HAEXRSP.
   • Use SARTDR TLOAD to load one or two generations of data.
   • Restart the CA View archival task and resume operation.
   • Run SARRSP to restore the remaining data.