From Roy Hann@21:1/5 to Steve on Mon Apr 4 08:18:24 2022
According to the Ingres documentation, a rollforward with -rollback
requires all journals since the last checkpoint be present.
Does "all journals" really mean all journals stretching back to when
the checkpoint was taken or does it simply mean all journals yet to
Our DR environments has been in a state of incremental rollforward for probably over a year and we only keep several days of journals.
The -rollback flag just controls what happens when the rollforward runs
out of journal records at the end of the process. If there are
uncommitted transactions it rolls them back instead of assuming "future" journal files would complete the transactions and dispose of them in the
If whatever your incremental rollforward is doing is working as you
expect and require, adding -rollback won't stop it working. It may
however cause transactions to be lost that would otherwise have been
recovered in future.