RE: replication question
Date: Tue, 13 May 2008 13:10:54 -0400
Having done this in a past life:
- Oracle data can be replicated between two servers via Materialized views which are not directly trigger operated, except for the MV log which is local. You can then schedule the updates to occur when you want & yes they can be bi-directional.
- Setting up Streams (something else I've done more recently) is
not as complicated as one would think. It's the rules that can be the
pain in the backside. Just remember KISS.
Dick Goulet / Capgemini
North America P&C / East Business Unit
Senior Oracle DBA / Hosting
Office: 508.573.1978 / Mobile: 508.742.5795 / www.capgemini.com Fax: 508.229.2019 / Email: richard.goulet_at_capgemini.com 45 Bartlett St. / Marlborough, MA 01752
Together: the Collaborative Business Experience
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeremy Schneider Sent: Tuesday, May 13, 2008 11:45 AM
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_at_ardentperf.com>
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:
- Oracle replication between sites would be too slow because it's trigger based and would seriously impact performance, especially during heavy traffic time.
- 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_at_ardentperf.com]
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. Itdepends 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 Schneider Chicago, IL http://www.ardentperf.com/category/technical This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. -- http://www.freelists.org/webpage/oracle-lReceived on Tue May 13 2008 - 12:10:54 CDT