RE: replication question
- From: "John Hallas" <john.hallas@xxxxxxxxxx>
- To: <jeremy.schneider@xxxxxxxxxxxxxx>, "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 13 May 2008 17:14:38 +0100
2 valid concerns from the developers.
I suppose the standard questions would be
Oracle version
Data volumes
Full schema/database or just a couple of tables
Latency allowed
I suspect the answer from Oracle would be DG but bandwidth would/might
be problem
Streams is probably the way to go but it does seem a (perhaps
unnecessarily) complicated beast
www.jhdba.wordpress.com
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jeremy Schneider
Sent: 13 May 2008 16:45
To: Oracle-L Freelists
Cc: Weiss, Stephen E (Stephen)
Subject: replication question
Have a good question from a friend of mine who's not on the list -
wondering if anyone else would have input. Reply-all so that Steve can
see the replies too - anyone have additional thoughts about this?
---------- Forwarded message ----------
From: Weiss, Stephen E (Stephen)
Date: Tue, May 13, 2008 at 10:26 AM
Subject: RE: General experience question...
To: Jeremy Schneider <jeremy.schneider@xxxxxxxxxxxxxx>
Between two geo-separated RAC databases, say one on west coast, the
other on east coast.
What is the recommended method for keeping both up to date, but not
necessarily immediately up to date.
There's concern from developers that:
1. Oracle replication between sites would be too slow because it's
trigger based and would seriously impact performance, especially during
heavy traffic time.
2. Oracle replication is end-of-life for Oracle Streams. We're
concerned about streams in that it's quite complex.
________________________________
From: Jeremy Schneider [mailto:jeremy.schneider@xxxxxxxxxxxxxx]
Sent: Tuesday, May 13, 2008 11:22 AM
To: Weiss, Stephen E (Stephen)
Subject: Re: General experience question...
Replication is probably the best Oracle-centric option. It
depends a lot on the volume of updates and the data types you're using.
There are also some third-party solutions available. This would be a
great question to post on the oracle-l list too if you wanted some good
feedback. Mind if I forward it over there?
-Jeremy
http://www.ardentperf.com/category/technical
--
Jeremy Schneider
Chicago, IL
http://www.ardentperf.com/category/technical
The information included in this email and any files transmitted with it may
contain information that is confidential and it must not be used by, or its
contents or attachments copied or disclosed, to persons other than the intended
addressee. If you have received this email in error, please notify BJSS.
In the absence of written agreement to the contrary BJSS’ relevant standard
terms of contract for any work to be undertaken will apply.
Please carry out virus or such other checks as you consider appropriate in
respect of this email. BJSS do not accept responsibility for any adverse effect
upon your system or data in relation to this email or any files transmitted
with it.
BJSS Limited, a company registered in England and Wales (Company Number
2777575), VAT Registration Number 613295452, Registered Office Address, First
Floor, Coronet House, Queen Street, Leeds, LS1 2TW
Other related posts:
