User Guide : 16. Performing Backup and Recovery : Recovery from Checkpoints : Recover a Database from an Old Checkpoint
 
Share this page                  
Recover a Database from an Old Checkpoint
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:
rollforwarddb +j #cn dbname
Linux:
rollforwarddb +j '#cn' dbname
where n is the checkpoint number. For example the following command requests recovery from checkpoint 4 for the Employee database:
rollforwarddb +j #c4 employee
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:
rollforwarddb +j #c dbname
Linux:
rollforwarddb +j '#c' dbname