I am putting together a document that highlights the problems that could arise from an active/active database design. Essentially what I am proposing is having a database in Sydney and an identical copy in UK, and a software called Oracle Golden Gate to perform the replication between. Now this software is costly and I need to justify why we need it.
I understand that without some sort of intelligence behind this proposed scenario, there could be scenarios like table and database lockups. Can someone be able to list a number of possible problems that such a design would attract without a 3rd party app like golden gate?