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.
To apply journals incrementally
1. Start the incremental rollforwarddb by issuing the following command:
rollforwarddb dbname +c -j -incremental
2. Discover and apply new journals by issuing the following command:
rollforwarddb dbname -c +j -incremental -norollback
The database remains inconsistent and readonly. There may be open transactions.
3. Discover and apply new journals and roll back open transactions by issuing the following command:
rollforwarddb dbname -c +j -incremental -rollback
The -rollback 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 ‑rollback may fail.
For details on the -incremental and other flags, see the rollforwarddb command description in the Command Reference Guide.