Recover a Subset of Data Using Roll Forward
The roll forward end time option (specified with the -e flag) permits the recovery of a subset of data in the journal file. The option is useful when problems have been encountered in a full roll forward database operation or when, for example, a critical piece of data has been inadvertently deleted.
Important! As this form of recovery does not restore the database to the state reflected by the full set of journals, it is critical that a checkpoint of the database be performed after the recovery completes. If not, another roll forward performed later can leave the database in an inconsistent state.
The only recommended course of action after is rolling forward a database with the -e option is:
• Roll forward the database again
• Checkpoint the database, preferably with the -d option (to delete previous checkpoints)
Note: The rollforwarddb -b and -e (Before and End) options operate on End Transaction timestamps, not on the time that a user may associate with an update. The auditdb -e and -b (End and Before) options also operate on End Transaction timestamps, and can be used to check anticipated roll forward results.