TurboIMAGE/XL Database Management System Reference Manual MPE/iX V6.5 (30391-90011)

Appendix G 669
Recovery and Logging Quick Reference
Sample Job Streams
Figure G-5. Sample Job Stream for Backup with Database Open for Access
:JOB MGR.DATAMGT
:FILE ORDERBK2;DEV=TAPE Mount tape.
:STORE ORDERS;*ORDERBK2;ONLINE=START Store database while it is open for
access.
:EOJ Assume that you will start a new log
cycle after ORDER999.
The next example in Figure G-6. uses roll-forward recovery and TurboSTORE/iX 7x24
True-Online Backup (with ONLINE=START or ONLINE=END option). If all recommended
procedures have been followed, the database backup copy will have flags set for enabling
recovery and disabling access, so the step to set these flags would be unnecessary. If this
process is being done interactively, the following command in DBUTIL will show if the flags
for recovery and access are correctly set:
>>SHOW database name FLAGS
Figure G-6. Sample Job Stream for Roll-Forward Recovery
:JOB MGR.DATAMGT
:FILE ORDERBAD;DEV=TAPE Current damaged database on the system
needing recovery.
:STORE ORDERS;*ORDERBAD;ONLINE=START Store damaged database; optional step.
:RUN DBUTIL.PUB.SYS
PURGE ORDERS Purge the current database.
EXIT
:FILE ORDERBK2;DEV=TAPE Mount the backup tape.
:RESTORE *ORDERBK2;ORDERS Restore the backup copy of the database
for recovery.
:RUN DBUTIL.PUB.SYS
DISABLE ORDERS FOR ACCESS Set the flags in the database.
ENABLE ORDERS FOR RECOVERY
ENABLE ORDERS FOR MUSTRECOVER
EXIT
:RUN DBRECOV.PUB.SYS Use roll-forward recovery on
RECOVER ORDERS database ORDERS.
FILE PART1,SYS/P1D1.MKTG,0,3 Use the FILE command to route log
records
FILE PART2,SYS/P1D1.MKTG,0,3 to individual user log files.
FILE PART3,SYS/P1D1.MKTG,0,3
RUN
EXIT
:LOG ORDERLOG,RESTART Restart current log file and set the
:RUN DBUTIL.PUB.SYS database flags.
ENABLE ORDERS FOR ACCESS
DISABLE ORDERS FOR RECOVERY
ENABLE ORDERS FOR MUSTRECOVER
EXIT
:EOJ