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

Chapter 8 387
Using the Database Utilities
DBRECOV
DBRECOV
The DBRECOV program usually is executed after a backup database copy has been restored
by running DBRESTOR in the event of a system failure. DBRECOV reads the log file containing
records of all database modifications and re-executes the transactions against the restored
database(s). The DBRECOV >FILE command enables individual users to be informed of the
extent of recovery. For more information on roll-forward recovery, roll-back recovery, and
the DBRECOV STOP-RESTART feature, refer to chapter 7.
DBRECOV also uses a mirror database on a secondary system as a workable maintenance
method. The options used with DBRECOV for this type of recovery and maintenance method
are RESTART, ABORT and PURGE. Example 4 shows a step-by-step mirror database
maintenance.
DBRECOV can perform rollforward recovery of TurboIMAGE/XL databases stored using the
TurboSTORE/iX 7x24 True-Online Backup. No new option for DBRECOV is needed.
The commands associated with DBRECOV are >CONTROL, >EXIT, >FILE, >PRINT,
>RECOVER, >ROLLBACK and >RUN. Each command is discussed separately.
Operation
:RUN DBRECOV.PUB.SYS [,
option
]
Options
RESTART restarts the roll-forward recovery process. Information in the RESTART file
is used by DBRECOV to restart recovery from the point it was stopped.
ABORT purges the RESTART file and returns the flags to the same settings as
before the recovery process was started.
PURGE deletes the current RESTART file before beginning the mirror database
process again. PURGE can also be used if ABORT fails to abort recovery
(possibly due to an inconsistent RESTART file).
Initiates execution of the DBRECOV program in the PUB group and SYS account. The
recovery system prints a banner indicating the version, date, and time. It then prompts for
a command input.
Example 1
Roll-forward recovery of database ORDERS.
:RUN DBRECOV.PUB.SYS
>RECOVER ORDERS
DATABASE ORDERS LAST DBSTORED THURS, SEP 21, 1989, 8:30 AM
>RUN