A large number of audit records can be written in a second, or even a thousandth of a second. Roll‑forward recovery now provides a finer, more‑specific termination condition capability to support roll‑forward recovery terminating at a specified audit serial number. When rolling forward to an audit serial number, audit records are processed until the audit record serial number is greater than the termination serial number.
The Roll‑Forward Recovery Options group box on the JADE Database utility Initiate Recovery and Restore Database And Roll Forward dialogs now provides the Recover transactions to audit serial number option button and a text box in which to specify the serial number of the last audit record to which committed transactions are recovered.
The batch JADE Database utility provides the optional lastSerialNumber parameter that you can specify for the recover and restore commands instead of the optional recovertTo or lastJournal parameter, to specify the last audit record to which committed transactions are recovered.
The following exceptions can be raised.
3193 (Roll-forward terminate serial number is earlier than audit trail), when a roll‑forward recovery to a serial number is attempted with termination criteria earlier than the first audit trail record. The audit trail serial number and the termination serial number criteria are written to the recovery.log file.
Re-issue the roll forward request with the corrected termination serial number criteria.
3194 (Roll-forward terminate before backup recovery complete), when a roll‑forward recovery of an online backup is performed specifying a termination condition that terminates the roll forward before the end backup checkpoint record is processed; that is, before file integrity is restored. The audit trail serial number and Log Sequence Number (LSN) and the End-Backup LSN are written to the recovery.log file.
Re‑issue the roll forward request with termination criteria beyond the end backup checkpoint record.