TurboIMAGE/XL Database Management System Reference Manual (30391-90012)

370 Chapter7
Logging and Recovery
The Mirror Database
recorded in the RESTART file.
DATABASE(S) WITH RECOVERY SUSPENDED:
base1.group.acct
base2.group.acct
.
.
.
This is a list of the databases that are in the RESTART file. These database names are
specified later when either the RESTART or ABORT options are used. The RESTART file
name is the same as the logid name used in the GETLOG and the LOG,START commands
when logging was enabled on the primary system.
DBRECOV then prints the name of the log file it needs to restart recovery, the record number
beginning an internal structure, the number of records currently in the staging file, and
the actual file name of the RESTART file for that recovery process:
RESTART RECOVERY WITH LOG FILE: filexxx
QUIET BLOCK BEGINS AT RECORD recordnumber
NUMBER OF RECORDS IN STAGING FILE numrecs
RESTART FILE NAME: filename
The user is returned to MPE/iX, where the command DBUTIL >>SHOW database name
FLAGS can be used to display the recovery state, that is, whether the database in recovery
has been set for RESTART.
When running multiple recovery processes from the same log file, the user needs to equate
the logid, that is the formal file designator for the RESTART file, to a unique file name for
each recovery process. The new file name is the RESTART FILE NAME for that specific
recovery process.
Storing the Databases
The databases can be backed up at this time. It is important to store all files involved in
recovery since the last successful RESTART. In other words, the database administrator
should store the databases, the current RESTART file, and all log files that were processed
since the last successful DBRECOV,RESTART. If the RESTART file is not stored with the
database backups, it is modified when recovery is restarted. Without the previous RESTART
file or the log files, the database backup copies cannot be used to RESTART recovery in case
the current RESTART fails.
The RESTART file and the databases have associated time stamps telling DBRECOV which
RESTART file goes with which databases. When DBRECOV is restarted, the time stamp in the
RESTART file is changed. If the RESTART file is not stored, the time stamps will not match,
and the RESTART will not succeed.
The method used to store the databases, RESTART file, and log files depends on the medium
used for user logging, as follows:
• If logging to tape, the log files are already stored on a transportable medium and
backing them up is not necessary. However, the log files must be grouped with the
database and RESTART file backups. If the user does not keep track of which log files go