Retract Changes Using Roll Forward
If a user makes a serious error in a table that is being journaled, the changes can be retracted. Use the roll forward operation to restore the database up to the beginning of the transaction in which the error occurred.
For example, to restore a database from the previous checkpoint to its condition at 8:00 A.M. on April 15, 2012, issue the following command:
rollforwarddb -v +c +j -e15-apr-2012:08:00:00 dbname
This command retracts all changes made to the database after this time, not just those made to the table with the error.
To ensure that the error is not reintroduced when you perform a roll forward in the future, take a new checkpoint to reset the journals.
Last modified date: 08/14/2024