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

Chapter 7 349
Logging and Recovery
Roll-Forward Recovery
enter the >EXIT command; DBRECOV terminates, and no recovery takes place.
>RUN
After the >RUN command is given, DBRECOV recovers the specified databases, creates
user recovery files, and terminates. After entering the >RUN command, DBRECOV asks
you to mount the log tape (if the log file medium is tape). Continue the roll-forward
process as directed by messages returned to both the console and the terminal screens.
9. If the CHANGELOG command or the GETLOG AUTO option was used during logging and
the logging file medium is tape or the next disk file in the log set is missing, the
following message appears on the terminal screen and the console:
Reply CONtinue on console when logfile is ready
When the required log file is available, enter the response CON to the console request
from DBRECOV.
Note that the response is in a form similar to REPLY for a tape mount used when storing or
restoring tapes; that is, you need to supply the Process Identification Number (PIN). For
recovery to succeed, you must have access to the log file. This implies either knowing the
logging identifier password and having system manager (SM) or operator (OP) capability,
or being the creator of the log identifier with read access to the log file if it resides in a
different logon group and account. If the log file is on tape, the operator must reply with
the proper volume identifier.
NOTE If the operator is unsure of the volume identifier, it is displayed on the console
when the tape is mounted.
If the database creator and the creator of the log identifier are not the same, and if the disk
log file and the database are in two separate accounts, follow the steps listed below for
recovery to proceed:
1. Assign a maintenance word to the database.
2. Log on as the creator of the log identifier.
3. Fully qualify the database name when issuing the >RECOVER command.
4. Specify the maintenance word.
If you want to use TurboSTORE/iX 7x24 True-Online Backup (with ONLINE=START or
ONLINE=END option) for roll-forward recovery, follow the steps below. For this
illustration, it is assumed that you are starting with the first log cycle with the AUTO
option, and recovery is needed after two backups.
1. Create a logid with the AUTO option.
2. Build a logfile, LOGF001.
3. Use DBUTIL to set the logid and enable the logging flag. You may optionally set the
MUSTRECOVER flag as well.