Restoring the Archive Database
AXQDBRST provides JCL that restores the database from the most current
generation of the Database Backup generation data group and any existing
generations of the Active Log generation
data group.
About this task
The database is restored to the point in time of its last backup and then the changes that were captured in the Active Log are applied in date and time sequence to restore the database to its current state.
If the Archive Database exists when you run AXQDBRST, the database is deleted and then is rebuilt in its entirety from the backup files.Procedure
- Modify JCL sample library member
AXQDBRSTaccording to the instructions that are provided in the comments. - Submit the job.
Results
REL X.X R O C K E T A R C H I V E M A N A G E R FOR Z/OS MXQDBRST JOBXXXXX
DATE: XX/XX/XXXX.XXX TIME: XX:XX:XX ARCHIVE DATABASE RESTORE REPORT FOR COMPANY_NAME PAGE 1
WORKFILE DATA SET NAME: RSTEST.RAM.RAMDB002.ARCHDBWK
DATABASE BACKUP FILE USED: RSTEST.RAM.RAMDB002.DBBKUP.G0001V00
BEGINNING COPY OF ARCHDB BACKUP FILE TO THE WORK FILE
ARCHDB BACKUP SUCCESSFULLY COPIED TO WORK FILE
ARCHDB BACKUP: RECS COPIED TO WORK FILE 7
BEGINNING COPY OF ACTIVE LOG DATA SET(S) TO THE WORK FILE
ACTIVE LOG FILE(S) USED: RSTEST.RAM.RAMDB002.ACTLOG.G0001V00
ACTIVE LOG RECS IN THIS GDG GEN: 2
ACTIVE LOG SUCCESSFULLY COPIED TO WORK FILE
TOTAL ACTIVE LOG RECS COPIED TO BACKUP: 2
BEGINNING SORT OF ARCHDB WORKFILE
THE SORT OF THE WORK FILE WAS SUCCESSFUL
BEGINNING DELETE REDEFINE OF DATABASE
DATABASE DATA SET NAME: RSTEST.RAM.RAMDB002.DATABAS1 WAS DELETED
THE DELETE AND REDEFINE OF THE DATABASE WAS SUCCESSFUL
BEGINNING RELOADING RECORDS TO DATABASE
DATABASE DATA SET NAME: RSTEST.RAM.RAMDB002.DATABAS1
THE DATABASE WAS SUCCESSFULLY RESTORED FROM THE BACKUPS
RELOAD PHASE TOTAL RECS READ: 9
RELOAD PHASE DELETE RECS SKIPPED: 0
RELOAD PHASE OLDER RECS SKIPPED: 2
RELOAD PHASE ADD RECS WRITTEN: 0
RELOAD PHASE UPDATE RECS WRITTEN: 0
RELOAD PHASE UNLOAD RECS WRITTEN: 7
RELOAD PHASE TOTAL RECS WRITTEN: 7
RESTORE OF DATABASE WAS SUCCESSFUL VER X.X A D V A N C E D A R C H I V E FOR DFSMShsm AXQDBRST JOBXXXXX
DATE: XX/XX/XXXX.XXX TIME: XX:XX:XX ARCHIVE DATABASE RESTORE REPORT FOR COMPANY_NAME PAGE 1
WORKFILE DATA SET NAME: TSTRAM.AXQ.V110.ARCHDBWK
DATABASE BACKUP FILE USED: TSTRAM.AXQ.V110.DBBKUP.G0001V00
BEGINNING COPY OF ARCHDB BACKUP FILE TO THE WORK FILE
ARCHDB BACKUP SUCCESSFULLY COPIED TO WORK FILE
ARCHDB BACKUP: RECS COPIED TO WORK FILE 269
BEGINNING COPY OF ACTIVE LOG DATA SET(S) TO THE WORK FILE
ACTIVE LOG FILE(S) USED: TSTRAM.AXQ.V110.ACTLOG.G0001V00
ACTIVE LOG RECS IN THIS GDG GEN: 5
ACTIVE LOG SUCCESSFULLY COPIED TO WORK FILE
TOTAL ACTIVE LOG RECS COPIED TO BACKUP: 5
BEGINNING SORT OF ARCHDB WORKFILE
THE SORT OF THE WORK FILE WAS SUCCESSFUL
BEGINNING DELETE REDEFINE OF DATABASE
DATABASE DATA SET NAME: TSTRAM.AXQ.V110.ARCHIVE.DB WAS DELETED
THE DELETE AND REDEFINE OF THE DATABASE WAS SUCCESSFUL
BEGINNING RELOADING RECORDS TO DATABASE
DATABASE DATA SET NAME: TSTRAM.AXQ.V110.ARCHIVE.DB
THE DATABASE WAS SUCCESSFULLY RESTORED FROM THE BACKUPS
RELOAD PHASE TOTAL RECS READ: 274
RELOAD PHASE DELETE RECS SKIPPED: 5
RELOAD PHASE OLDER RECS SKIPPED: 1
RELOAD PHASE ADD RECS WRITTEN: 0
RELOAD PHASE UPDATE RECS WRITTEN: 0
RELOAD PHASE UNLOAD RECS WRITTEN: 268
RELOAD PHASE TOTAL RECS WRITTEN: 268
RESTORE OF DATABASE WAS SUCCESSFUL