Recover a Journaled Database
To recover a specific database from the last checkpoint and journal, where both the checkpoints and journals are stored online, issue the following command at the operating system prompt:
rollforwarddb dbname
Note: All journals since the last checkpoint must be present.
Apply Journals Incrementally to a Backup Database
As journal files are generated, you can apply them incrementally to a backup copy of the database. Doing so minimizes downtime if the backup database is needed for disaster recovery.
Note: Incremental rollforward is not supported for a database that includes X100 tables.
To apply journals incrementally
1. Start the incremental rollforwarddb:
rollforwarddb dbname +c -j -incremental_start
2. Discover and apply new journals:
rollforwarddb dbname -c +j -incremental_continue
The database remains inconsistent and readonly. New journals are applied such that no transactions are left open.
3. Discover and apply new journals, roll back open transactions, and mark the database updatable:
rollforwarddb dbname -c +j -incremental_finish
The -incremental_finish flag ends the incremental rollforwarddb, and the database is marked consistent and updatable.
Note: Incremental rollforwarddb requires that all journals since the last checkpoint be present. For example, if you apply a batch of journal files, and then delete the previous batch of journal files, rollforwarddb ‑incremental_finish may fail.
For details on the flags, see the rollforwarddb command description in the Command Reference Guide.
Last modified date: 01/30/2023