A Forward Recovery procedure restores a backup copy of the database, and applies the journal file to that database file. The starting point for both the database and corresponding journal files must be identical. The journal file contains copies of each database update. Forward Recovery reads the entire journal file from the beginning and updates the backup copy of the database. To stop journal processing before the physical end of the journal file, specify a journal ending time using the optional MUPIP JOURNAL -BEFORE= qualifier.

Use MUPIP BACKUP to ensure that the beginning of the journal file coincides exactly with the beginning of the recovered database.

Forward Recovery generally takes longer than Backward Recovery. However, if the current database is destroyed, you must use Forward Recovery. If a journal file was created using NOBEFORE_IMAGES, that journal permits only Forward Recovery.

Example of Forward Recovery:

Example: MUPIP JOURNAL -RECOVER

This shows a recovery after a system crash at 10:35 which processes the entire journal file forward.

By adding -BEFORE="- - 10:30" to the command, the recovery stops when processing encounters updates that originally occurred after 10:30.