Re: Real time data trasfer between 2 DB

  • From: Kellyn Pedersen <kjped1313@xxxxxxxxx>
  • To: deshpande.subodh@xxxxxxxxx, andrew.kerber@xxxxxxxxx
  • Date: Mon, 30 Aug 2010 17:45:09 -0700 (PDT)

One more option on this thought-  If you are going to dump it to a flatfile and 
then load, how about CDC, (change data capture) to load it to db1 and db2?  A 
simple CDC could load the data into the destination system on regular 
Always 100 different way to skin this kind of database cat... :) 

Kellyn Pedersen
Sr. Database Administrator
I-Behavior Inc.
"Go away before I replace you with a very small and efficient shell script..."

--- On Fri, 8/27/10, Andrew Kerber <andrew.kerber@xxxxxxxxx> wrote:

From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
Subject: Re: Real time data trasfer between 2 DB
To: deshpande.subodh@xxxxxxxxx
Cc: Arvind.Kumar@xxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
Date: Friday, August 27, 2010, 6:40 AM

Is the 5 second latency the time between broadcast of the data and the time it 
must be available in the second database?  If you have a little more time in 
there, then I like the idea of queueing it into a flat file and loading it into 
both DB's from there.  If it must go from the gps to db1 to db2, I would use 
triggers rather than streams or dataguard.

Frankly, I think you will have more problems getting the data to the first 
database quickly then you will have replicating it over to the second.

On Fri, Aug 27, 2010 at 7:17 AM, Subodh Deshpande <deshpande.subodh@xxxxxxxxx> 

Hi Arvind,
0)worked on replication but now on bus transport system have not worked on such 
system and hence random gueses
what if you pull the data from city buses, replication, streams, golden gate 
will be more suitable, you want transactions only..
pulling will keep the bus conductor/machine free from loading the data and main 
hub will always know what is the status alogn with co-ordinates of city bus
1) insted installing databases in buses can the ticketing machine send the data 
in flat file formats and that data you can be sent from wap devices to a stage 
area from where you can load the data either using external tables..or 
sqlloaders this will reduce the licensing cost.per city bus ddatabse and 
maintence cost will be more..


On 27 August 2010 10:51, Arvind Kumar (IT-SIS-UIF) <Arvind.Kumar@xxxxxxxxxxxxx> 

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.
Arvind Kumar


Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'


Other related posts: