Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Jack.

Asked: July 06, 2023 - 2:10 pm UTC

Last updated: January 08, 2025 - 2:46 am UTC

Version: 19c

Viewed 100+ times

You Asked

If I only wanted to do multi-master replication of just a few tables (<5) between two Oracle databases in Oracle 19c here in 2023, without having to pay for the Golden Gate license, what are my options?

I want something like the "Advanced Replication" feature from the older versions of Oracle (I remember using it back in Oracle v7), but I understand this feature was desupported long ago. Then there was Oracle Streams, CDC, and updatable Materialize Views... all of which seemed to be desupported now as of Oracle 19c in favor of doing all replication activities with Golden Gate.

I just discovered "Golden Gate Free", but this is limited to databases less than 20G in size. My database is bigger.

I only need to do replication between two databases for about 3 tables for about a year while we align other activities to migrate fully off of one of those databases. But it must support OLTP between the databases and keep the 3 tables in sync in "near real time". In other words, both databases need to allow concurrent read/write of these tables. And ideally, conflict resolution should be done via a "latest time stamp wins" approach.

What would you do if you were me?

Thanks,
Jack

and Connor said...

Unless you want to home-grow this, I'd suspect your options are going to be third party options for example: https://www.qlik.com/us/products/qlik-replicate

But the fact that even replication specialists like dbvisit ended up sunsetting their replication facilities, gives you an idea for how complex a task this can be.


Is this answer out of date? If it is, please let us know via a Comment