PowerExchange Express CDC for Oracle Support for Oracle RESETLOGS Operations
PowerExchange Express CDC for Oracle Support for Oracle RESETLOGS Operations
Previously, PowerExchange Express CDC capture processing and the PowerExchange Logger for Linux, UNIX, and Windows ended with multiple error messages after the log reader encountered a RESETLOGS event in the archived redo logs. Effective in PowerExchange 10.1, PowerExchange Express CDC can detect a RESETLOGS event and continue capture processing across the RESETLOGS boundary in the archived redo logs.
The PowerExchange Express CDC restart token has been modified to add the resetlogs ID at the end of the token value. At initialization, PowerExchange Express CDC uses the resetlogs ID to check whether the database has undergone a RESETLOGS event. If a RESETLOGS event occurred, PowerExchange Express CDC verifies that the restart information and the last change data that was hardened to the PowerExchange Logger log files are valid and have not been orphaned by the event. If the information is valid, PowerExchange continues capture processing.
To restart a CDC session, you can still use the restart tokens of the older format, without the resetlogs ID. However, PowerExchange Express CDC then cannot check for RESETLOGS events or orphaned data. Errors might occur.
For more information, see the "Express CDC for Oracle" chapter in the
PowerExchange CDC Guide for Linux, UNIX, and Windows