RE: synchronizing database on linux and windows ?
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <nileshkum@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 10 Sep 2007 15:03:07 -0400
I'm a bit confused by your use of the phrase "so that data on both the
databases are synchronous" together with the subject line "synchronizing."
In the thread you've been given a few suggestions about ultimately
"synchronizing" your databases (together with appropriate caveats about what
might be appropriate depending on your load and volume).
However, if you truly want the data on both databases to be synchronous, and
since you cannot RAC across different platform types, you will need to
utilize two phase commit in your application.
Oracle's two phase commit protocol is razored down to extreme efficiency
compared to what must be done to achieve the goal. Even so, it is a high
overhead if you don't truly need synchronization.
What is your real service level requirement? Is there an acceptable non-zero
lag time during which the databases may diverge as updates arrive? Are
updates allowed at both locations? Might conflicting updates be attempted at
different locations? (If so, you'll need a tie breaking protocol.)
Regards,
mwf
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of nilesh kumar
Sent: Monday, September 10, 2007 9:13 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: synchronizing database on linux and windows ?
Hello All,
I have installed oracle 10g on windows and on linux on two different
machines, I need to create a application in which, through front end any
changes made to the database on windows that changes need to be reflected on
the database on linux so that data on the both the database are synchronous.
Could any one help me how shall I proceed.
Thanks
Nilesh Soni
Other related posts:
