Table of Contents

Search

  1. Preface
  2. Summary of PowerExchange New Features and Changes
  3. PowerExchange Installation and Upgrade
  4. PowerExchange Agent
  5. PowerExchange Client for PowerCenter
  6. PowerExchange Condense
  7. PowerExchange Listener
  8. PowerExchange Logger for Linux, UNIX, and Windows
  9. PowerExchange Navigator
  10. PowerExchange Monitoring and Tuning
  11. PowerExchange Utilities
  12. PowerExchange for Adabas
  13. PowerExchange for CA Datacom
  14. PowerExchange for DB2 for i
  15. PowerExchange for DB2 for Linux, UNIX, and Windows
  16. PowerExchange for DB2 for z/OS
  17. PowerExchange for CA IDMS
  18. PowerExchange for IMS
  19. PowerExchange for Microsoft SQL Server
  20. PowerExchange for MySQL
  21. PowerExchange for Oracle
  22. PowerExchange for PostgreSQL
  23. PowerExchange for VSAM and Flat Files
  24. PowerExchange ODBC

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
.

0 COMMENTS

We’d like to hear from you!