If the most recent checkpoint has been damaged or is unreadable, it is possible to recover from an older checkpoint. You can use either a specific checkpoint number or the most recent usable checkpoint.

To recover the database from a particular checkpoint and apply all journals after that time, issue the following command:

Windows:

where n is the checkpoint number. For example the following command requests recovery from checkpoint 4 for the Employee database:

The checkpoint sequence number must be a valid checkpoint number. You can verify this number with the infodb command.

If the most recent checkpoint is unfinished and you want to recover using the most recent usable finished checkpoint, issue the following command:

Windows: