User's Manual
Recovery with a single transaction log
In this case, we assume that there is a single transaction log file, which has
existed since the database was created. Also, we assume previous backups of
the database file have been made and are available, for example on tape.
❖ To recover the database
1. Make a copy of the database and log file.
2. Restore the database (
.db
) file,
not
the log file, from tape into a
temporary directory.
3. Start the database using the existing transaction log and the -a option, to
apply the transactions and bring the database file up to date.
4. Start the database in your normal way. Any new activity will be appended
to the current transaction log.
X
Transaction log
(intact)
Database file
(corrupt)
Media failure
on the
database file
Transaction log
(intact)
Old database
file (intact)
Restore
backed up
database file
Transaction log
(intact)
Database file
(restored)
Start
database
with
transaction
log
254