RE: replication question
- From: "Goulet, Dick" <richard.goulet@xxxxxxxxxxxxx>
- To: <jeremy.schneider@xxxxxxxxxxxxxx>, "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 13 May 2008 13:10:54 -0400
Jeremy,
Having done this in a past life:
1) 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.
2) 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@xxxxxxxxxxxxx
45 Bartlett St. / Marlborough, MA 01752
Together: the Collaborative Business Experience
______________________________________________________________
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@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
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.
Other related posts:
