Replicate using oracle source found that some of the records are missed

[spola]

need a quick help

Our CDC task got failed with redo log doesn't exist, once our DBA's are restored all redo logs and we have resumed with the timestamp, we have seen all the redo logs are processed successfully but after some time it got failed again with redo doesn't exist issue with another sequence number, we have followed the same process like restoring those redo logs and resuming the job with a timestamp.

After few days we have found that data missing in the target.

for suppose if we resume the task now by collecting the SCN number from the first failure, is it going to load the duplicates in target (or) it will load only the missing records (or) else do we have only one option FUll + CDC (or) else do we have any other option

[lyka · Accepted solution]

Hello,

It will load duplicate however you can use the apply error handling and use MERGE and UPSERT

MERGE:

Duplicate key when applying an INSERT: > Update the existing target record:

UPSERT:

No record found for applying an UPDATE set to Insert the missing target record

Please note that when you use UPSERT, LOB support will be disabled

Hope this helps

Thanks

Lyka