Use DR Tape for Recovery

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.  These steps mention SARDBASE, SARTCP, and SARRCOV. For details about each one, see .
view
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.  These steps mention SARDBASE, SARTCP, and SARRCOV. For details about each one, see
Database Utilities
.
  1. Run the SARDBASE utility ADDDS function to create a new database.
    Note:
    Sample JCL for this function can be found in CVDEJCL member BRMADDS.
  2. Run SARTCP to map your latest DR tape.
    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:
      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
    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
    Initialization Parameters
    .
  7. Run either SARRSP or SARTDR TLOAD to load the SYSOUT data. For more information, see
    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
      View
      archival task and resume operation.
    • Run SARRSP to restore the remaining data.