In a master-master (or peer to peer) replication environment, does Shareplex log the details of success or failure of the conflict resolution routines in the event_log or at any other place?
Informational solution.
Shareplex DOES log the failure of the conflict resolution in the event log. The message shown below is one such example:
06/03/08 10:51 Notice: 20000: User Defined Error: Custom PL/SQL procedure splex.splex_time(gen_row, gen_tab);. returned failure [sp_opst (for o.SID1-o.SID2queue Queuename)/5468]
06/03/08 10:51 Notice: Conflict Resolution failed - user chose no action. [sp_opst (for o.SID1-o.SID2 queue Queuename)/5468]
Shareplex does NOT log the success of the conflict resolution routines in the event_log. Such logging may fill up the event log and make it cumbersome to read, especially if many conflicts are resolved. The successes are instead typically logged in a table named CONF_LOG owned by Shareplex schema. The table is usually created by a user when the routines are configured. The table has a field named CONFLICT_RESOLVED and a stored value of 'Y' indicates that the conflict is resolved. The same table also logs the failure of the conflict resolution when the value in that field is 'N'. The table also has other fields that can be of help in analyzing the success or failure of the conflict.
The following are the fields in the table named CONF_LOG:
CONFLICT_NO
CONFLICT_TIME
SRC_HOST
SRC_ORA_SID
SOURCE_ROWID
TARGET_ROWID
ORACLE_ERR
CONFLICT_TABLE
CONFLICT_TYPE
CONFLICT_RESOLVED
PRIMARY_KEYS
MESSAGE
SQL_STATEMENT
CONFLICT_CHECKED
