ArcGis data replication using Oracle replication technologies

[MuhamedHarisMuhamed]

Hi Support ,

We are using ArcGIS pro with Oracle database , and we are planning to have a new database server for web application to reduce the usage in production database , Kindly advice  Which is the best  solution for the replicate the real time data from production database to the application database .

Any one have experienced with Giodatabase synchronization with Oracle golden gate ?

regards

Haris Palliyal

[AlisonWieckowicz]

I see that this post is from 2022 but I curious what outcome you had when evaluating bidirectional replication of GDB with golden gate.   We too considering similar options. 

There is a lot that concerns me with true bidirectional active/active replication of a geodatabase.  I was told that primary keys aren't required as long as you could uniquely identify a row.    How would global IDs be ensured to be unique if sde.next_rowid could be executed by either DB simultaneously.   

Am I over thinking this?