Previous Topic: Journaling to a Disk DeviceNext Topic: Recovery Procedures for Mixed-Mode Operations


Using an Incomplete Journal File

What is an Incomplete Journal File?

An incomplete journal file is a journal file that does not contain a final ABRT checkpoint for the active transaction or even an end-of-file mark. This occurs when the journal file has been unexpectedly interrupted, for example, when the operating system crashes. An incomplete journal file is not suitable for recovering your database. To make a suitable journal file for recovery, use the FIX ARCHIVE utility statement, which:

Steps

To recover a database in local mode, using an incomplete journal file, follow these steps:

Action

Statement

Fix the journal file

FIX ARCHIVE

Recover the database using the output from the FIX ARCHIVE utility statement as described for journaling to a tape device above.