ReplicaDB icon indicating copy to clipboard operation
ReplicaDB copied to clipboard

Published 20 hours ago • verified publisher icon osalvador

Oracle to postgres data sync issue

Open ud20 opened this issue 4 years ago • 3 comments

We are trying to do a data dump from oracle to postgres. On some larger tables(>120GB) we are seeing some errors. ERROR ReplicaTask:72 ERROR in TaskId-0 inserting data to sink table: ORA-01555: snapshot too old: rollback segment number 20 with name "_SYSSMU20_231399234$" too small We tried a few different things like, do it when the data is not changing constantly, smaller fetch size, less number of jobs running but, nothing seemed to work so far. Did you ever see anything similar happening?

ud20 avatar Apr 17 '20 17:04 ud20

Hello, ud20,

This is a common error with Oracle with large tables. Check if you can make any of the recommendations listed on this website: https://blog.enmotech.com/2018/09/10/ora-01555-snapshot-old-error-ways-to-avoid-ora-01555-snapshot-too-old-error/

In parallel I am investigating how to address it directly with ReplicaDB.

Greetings

osalvador avatar May 13 '20 16:05 osalvador

Hello @osalvador We did it in smaller chunks. 2 years of data at once and finished the migration. Thank you for your help!

ud20 avatar May 13 '20 20:05 ud20

Thanks to you @ud20!

I keep the issue open until I find a solution to this problem directly in ReplicaDB.

Regards!

osalvador avatar May 14 '20 07:05 osalvador