Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Rass.

Asked: December 10, 2016 - 4:47 am UTC

Last updated: December 11, 2016 - 4:23 am UTC

Version: Oracle 10g

Viewed 1000+ times

You Asked

My company is in Indonesia. Having branches separates in all province. We use Oracle Database. All the branches must having internet connection to connect the application. But there is one branch, the province is so deep inside. Sometimes the internet is cut very often. so the main branch have a problem to get their daily transactions. They have to make manual transaction if the internet not work. And they will input their transaction when the internet connection is coming. As the result we will not get accurate data. On that time the IT have to make update their transaction date. to get the accurate data. It is really wasting the time..

From my story. Is there any solution to face this?
Is it possible to do mirroring database on that branch. For example they have a local database. And when the internet is coming the new datas from their local database will update the main database from the main branch? Or on What is the concept of mirroring database that oracle has?

and Connor said...

Two solutions are available here

1) Goldengate

http://www.oracle.com/technetwork/middleware/goldengate/overview/index.html

2) Advanced replication

http://docs.oracle.com/database/121/REPLN/toc.htm

Both are not trivial exercises, because managing two separate databases and trying to keep them in sync is not as easy as it seems. You need to deal with conflicts (ie, one system updates a record from "A" to "X", and the other updates the same record from "A" to "Y" - who should win?)

I'm just trying to set your expectations here - its a tough project.

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