Automatic Conflict Detection and Resolution is critical to any active/active and multi-master GoldenGate implementation. Below are some useful views to gather ACDR information:
DBA_APPLY_ERROR_MESSAGES
Displays information about the individual messages in all the error transactions generated by all applied processes in the database.
DBA_GG_AUTO_CDR_TABLES
Provides details about all the tables configured for Oracle GoldenGate automatic conflict detection and resolution (CDR).
DBA_GG_AUTO_CDR_COLUMNS
Provides details about all the Oracle GoldenGate automatic conflict detection and resolution (CDR) columns in the database.
DBA_GG_AUTO_CDR_COLUMN_GROUPS
Provides details about all the Oracle GoldenGate automatic conflict detection and resolution (CDR) column groups in the database.
If you are not yet taking advantage of the GoldenGate active/active feature, I highly recommend you review it and send me any questions. Making your applications highly available, fault-tolerant, and performing flawlessly can provide you with many benefits.
You must log in to post a comment.