Recovering Damaged Database Files

The following two methods enable you to recover a database from a journal file:

  • Forward Recovery (roll forward)

  • Backward Recovery (roll back)

All journal files permit Forward Recovery. Only journal files created with MUPIP SET /JOURNAL=BEFORE_IMAGES support Backward Recovery.

Activate database recovery from a journal file using the MUPIP JOURNAL /RECOVER command; with the /FORWARD qualifier for forward recovery, or with the /BACKWARD qualifier for backward recovery. If something, such as head-disk interference destroys a portion of the database file, /FORWARD recovery must be used because JOURNAL /RECOVER /BACKWARD will have no valid starting point.