Post

2 followers Follow
1
Avatar

Dbvisiit Replicate conflict

Hello

How to solve conflict like this

dbvrep> list conflict
Information for conflict 65010136843 (current conflict):
Table: DBVREP1.DBRSOBJ$ at transaction 033f.01d.00000047 at SCN 9514423886098
SQL text (with replaced bind values): update "DBVREP1"."DBRSOBJ$"
set "MINE_ENABLED" = 'Y',
"MINE_OUT" = 'N',
"MINE_INHERIT" = 'Y',
"MINE_DDL" = 'Y'
where (1=1)
and "MINE_ENABLED" IS NULL
and "MINE_OUT" IS NULL
and "MINE_INHERIT" IS NULL
and "MINE_DDL" IS NULL

Error: Command affected 0 row(s).
Handled as: RETRY

dbvrep>list progress all

-------------------------------------------------------------
DBVREP1.DBRSCOMMON_HEARTBEAT: ---%  Mine:1/1             Unrecov:0/0
Applied:0/0         Conflicts:0/0       Last:--/--
DBVREP1.DBRSOBJ$:              99%  Mine:59222/59222     Unrecov:0/0
Applied:59194/0     Conflicts:1/1       Last:01/03/2017 16:55:10/RETRY:Command
affected 0 row(s).
DBVREP1.DBRSUSER$:             95%  Mine:84/84           Unrecov:0/0
Applied:80/0        Conflicts:0/0       Last:--/--
DADIN.TAB6:                   ---%  Mine:999/999         Unrecov:0/0
Applied:0/0         Conflicts:0/0       Last:--/--
-------------------------------------------------------------------------------
-------------------------------------------------------------



 dbvrep> healthcheck
Argument "\0\0\0\0\0\0\0^I\0\0\0\0^CÓÙM-\0ñ\0^N\0^BÒä\0\0\0\0\0^B¾..." isn't numeric in scalar assignment at IO/Socket/IP.pm line 716.

Connectivity test for APPLY: OK
Connectivity test for MINE: OK
2 processes checked.

MINE is running. Currently at plog 70 and SCN 9514423925499 (03/01/2017 03:04:54).
APPLY is running, initialization NOT yet complete. Currently at plog 65 and SCN 9514423886095 (03/01/2017 00:10:47) and 4 apply conflicts so far (last at 01/03/2017 15:38:35) and WAITING on manual resolve of apply conflict id 6501013684
Progress of replication CE508PRD:MINE->APPLY: total/this execution
------------------------------------------------------------------------------
DADIN.TAB5:                   ---%  Mine:999/999         Unrecov:0/0         Applied:0/0         Conflicts:0/0       Last:--/--
------------------------------------------------------------------------------
1 tables listed.
meric in scalar assignment at IO/Socket/IP.pm line 716.

                            

I try to solve with resolve conflict  65010136843 as ignore, but the problem keep appear

 

Thanks

 

Dadin Jaenudin Answered

Please sign in to leave a comment.

1 comment

0
Avatar

Conflicts in Dbvisit replicate have been designed to prevent target database from data inconsistency. There should always be a valid reason for a conflict and understanding your data will help understanding reasons behind conflicts.

If you need our assistance please log a ticket and upload all support packages and other information requested by Dbvisit product specialists.


Try to resolve the conflict as overwrite - may have to try it a couple of times.

dbvrep> resolve conflict as overwrite

Another way would be :
1. pause apply - look at the SCN at which it is paused
2. stop apply and mine
3. import the data from source DBRSOBJ$ table to target using flashback_scn from previous point
4. start the processes

Charmaigne Bezuidenhout 0 votes