Hi Friends, Is it possible to synchronize two database in single database.
Actually the scenario is, there will be single instance database with dataguard config...So this database will be used from two different locations/places .. the distance is around 1000 Km. If the user not able to log from second location because of network problem ... then seconday server ie datagaurd will become primary for the second location.
Then both the databasses will work as PRIMARY database for the two different locations. Once the network issue resolve then we need to sync the database to single database ...
Is there any solution for synchonize the database ...or any tool for this one....
Thanks in advance
Dataguard can't help you with that requirement - you need some sort of multi master replication to solve that problem - so something like old style advanced replication, streams or goldengate. None of these are easy - the biggest issue being conflict resolution if data is changed in both sites which one is correct......
You are looking for a Bidirectional Replication.
Golden Gate Bidirectional Replication
Oracle Bi-Directional Data Replication