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

388 Chapter8
Using the Database Utilities
DBRECOV
Example 2
Roll-forward recovery of multiple databases ORDERS and RETAIL. PART and SALES are
filenames, ADMIN and MKTG are accounts in the FILE commands. The 0 is the rmode
and the 3 is the fmode.
:RUN DBRECOV.PUB.SYS
>RECOVER ORDERS
DATABASE ORDERS LAST DBSTORED MON, SEP 25, 1989, 6:40 PM
>CONTROL NOSTORE
>RECOVER RETAIL
>FILE PART,JOHN.ADMIN
>FILE SALES,MARY.MKTG,0,3
>RUN
Example 3
Roll-back recovery of multiple databases ORDERS and RETAIL.
:RUN DBRECOV.PUB.SYS
>CONTROL NOABORTS
>ROLLBACK ORDERS,RETAIL
DATABASE ORDERS LAST USED THURS, SEP 21, 1989, 6:00 PM
DATABASE RETAIL LAST USED FRI, SEP 22, 1989, 8:00 AM
>RUN
Example 4
DBRECOV STOP-RESTART recovery on database ORDERS. The recovery process is done on
a secondary system with the mirror database maintenance and recovery process. The
following example begins with a prompt for the user to continue or stop the roll-forward
recovery process on the secondary system. When DBRECOV cannot find the next log file in a
log set, the user can stop the recovery process and back up the secondary system. In the
example, note that the restart file ORDERLOG is named after the database
logid .
UNABLE TO OPEN LOG FILE ORDER005
REPLY `CONTINUE' OR `STOP' ON CONSOLE.
STOP
DATABASE(S) WITH RECOVERY SUSPENDED:
ORDERS.DATAMGT.ADMIN
RESTART RECOVERY WITH LOG FILE: ORDER005
QUIET BLOCK BEGINS AT RECORD 1005
NUMBER OF RECORDS IN STAGING DISC 1810
RESTART FILE NAME: ORDERLOG
:FILE L;DEV=TAPE
:STORE ORDERS @ ;*L
:RUN DBRECOV.PUB.SYS,RESTART