Re: Real time data trasfer between 2 DB
- From: "Remigiusz Sokolowski" <remigiusz.sokolowski@xxxxxxxxxx>
- To: <Arvind.Kumar@xxxxxxxxxxxxx>
- Date: Fri, 27 Aug 2010 11:26:01 +0200
Arvind Kumar (IT-SIS-UIF) pisze:
> Hi Upendra,
>
>
>
> Thanks for the suggestions.
>
>
>
> * There will be three tables for initial load with 2.7GB in total.
>
> * Destination table only be used for reporting so not updates.
> * There would be 10000GPS units which will send their coordinates
> and other information
>
> At every 5 second so (10000) records would need to be transferred
> destination database with every refresh.
>
> * We are using varchar2 and number in those tables.
>
>
You could think about upgrading to 11g - in that case You would be able
to read from standby for reports purposes still applying data, as
Upendra said in point 2
>
>
>
> ________________________________
>
> From: Upendra N [mailto:nupendra@xxxxxxxxxxx]
> Sent: Friday, August 27, 2010 7:51 AM
> To: Arvind Kumar (IT-SIS-UIF); oracle-l@xxxxxxxxxxxxx
> Subject: RE: Real time data trasfer between 2 DB
>
>
>
> Hi Arvind,
> Depends on the flexibility on "near real time" requirements, you could
> use the following:
>
> 1. Materialized views - You could setup MVs with fast refresh to every
> minute or 30 seconds refresh interval. Depending on your read-only or
> read write requirements on the tables, this may or may not work. This is
> easy to setup and easy to manage.
> 2. Active Data guard - If you want only a read only database at the
> other site, this will work.
> 3. Advanced replication - You could setup replication interval to 30-60
> seconds. Provides flexibility to use tables that can be updated at both
> the databases.
> 4. Oracle Streams - You could setup schema level or selective table
> level replication, replication interval could be 30-60 seconds.
> 5. Depending on the flexibility you could also consider Oracle RAC -
> Metro cluster where RAC nodes spread across multiple data centers.
>
> Near real time could be 5 milliseconds or 5 minutes... you need to
> define this.
>
> Some of the questions you need to clarify:
> How large are the initial size of the tables?
> Do you want update capabilities on the destination database?
> How much data will you generate between the refresh interval?
> Do you have any special data types that needs to be replicated?
>
> -Upendra
>
>
>
>
> ________________________________
>
> Subject: Real time data trasfer between 2 DB
> Date: Fri, 27 Aug 2010 07:21:59 +0200
> From: Arvind.Kumar@xxxxxxxxxxxxx
> To: oracle-l@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.
>
>
>
> Thanks
>
> Arvind Kumar
>
>
>
>
--
Pole nakazi
----------------------------------------------------------------------
Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx>
pos : DBA at DIiUSI
addr : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland
phone : +48 58 667 17 43
mobile: +48 602 42 42 77
Nordea Bank Polska S.A. z siedzib? w Gdyni, ul. Kielecka 2, 81-303 Gdynia,
wpisan? do Rejestru Przedsi?biorców Krajowego Rejestru S?dowego pod numerem:
0000021828,
dla której dokumentacj? przechowuje S?d Rejonowy Gda?sk - Pó?noc w Gda?sku,
VIII Wydzia? Gospodarczy Krajowego Rejestru S?dowego,
o kapitale zak?adowym i wp?aconym w wysoko?ci: 227.593.500,00 z?otych,
NIP: 586-000-78-20, REGON: 190024711
--
//www.freelists.org/webpage/oracle-l
Other related posts:
