RE: Real time data trasfer between 2 DB
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: <Arvind.Kumar@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 27 Aug 2010 10:25:29 -0400
First question I would ask is why do we have 2 databases in the first
place. Mostly I get that requirement because "we don't want to impact
the activity of the application with reporting requirements" In your
case the application is the bus sending data to the database for input,
not update. And depending on your server the replication can become
more of a resource hog than the reporting. I've got a situation like
that right now and it really is a bear. So, get the right server with
more memory and cpu than you think you'll need for 10 years and have
just the single instance. That also takes care of the latency issue as
well.
Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Arvind Kumar
(IT-SIS-UIF)
Sent: Friday, August 27, 2010 1:22 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Real time data trasfer between 2 DB
Greeting all,
What would be the best method to transfer data between two databases
(10g R2) in real time (near real time). It's a transport system where
GPS devices installed in City Buses inserts records (location, timings)
into oracle DB then this data has to be transferred to other oracle DB
for reporting with a max latency on 5 second.
Any input or experience on similar scenario will be highly appreciated.
Thanks
Arvind Kumar
Other related posts:
