How to List all the conflicts

Owned by Clive Otten (Unlicensed)
Jan 22, 2020
1 min read

Problem Description

How do I get a list of ALL the conflicts? Console is showing the following:

/MINE IS running. Currently at plog 67670 and SCN 6828074424 (05/25/2013 12:48:36). APPLY IS running. Currently at plog 67670 and SCN 6828074345 (05/25/2013 12:48:33) and 3 apply conflicts so far (last at 25/05/2013 12:33:50).

Using the "list conflict last" command I can see the last conflict. How do I retrieve ALL the conflicts so far, and/or for a period of time?

Solution

You cannot see all the conflicts in the command console. In the command console you can only list the last conflict, current conflict and a specific conflict (using a conflict id). To see the whole conflict history, please navigate to the database table DBRSAPPLY_CONFLICT_LOG on the target database. This will be under the dbvrep schema.

Arjen Visser June 14, 2013 22:52