RE: "Oracle Streams" by Madhu Tumma
- From: "Pete Sharman" <peter.sharman@xxxxxxxxxx>
- To: "makbo@xxxxxxxxxxx" <makbo@xxxxxxxxxxx>
- Date: Mon, 14 Nov 2005 15:19:55 +1100
I guess it's safe to say that customers can come up with a variety of ways to
use the Oracle software that it certainly wasn't intended to be used. However
since this thread started in the area of HA, that's where I've been keeping my
comments.
The issue I have with Ranko's comment below is that no one technology is ever
going to be a complete HA solution. RAC is part of the solution. Streams,
DataGuard or Advanced Replication can also be a different part of the solution.
But you need a combination of the different technologies, AND even more
importantly processes that support HA (like proper change control and so on)
before you have a complete solution.
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Mark Bole
Sent: Monday, 14 November 2005 12:17 PM
Cc: Oracle-L Freelists
Subject: Re: "Oracle Streams" by Madhu Tumma
Here are three ways to look at it.
1) Oracle Product Family / Marketing
Streams is considered an "Integration" product.
Data Guard is considered a "High Availability" product.
RAC is considered a "Scalability" product.
2) logical vs. physical
Streams (and the similar SQL-apply based Logical Standby) is logical,
Data Guard Physical Standby is, well, physical. RAC is either physical
or both, depending on your precise definition. (I guess when we have
cross-platform RAC, then it will be logical...)
3) instance vs. storage
RAC protects the instance. Streams protects the storage (but that is
not its primary purpose). And Data Guard does both (as long as you can
accept a brief outage of your instance).
(this overlaps with some of Pete Sharman's comments quoted below).
-Mark Bole
Ranko Mosic wrote:
> Correction: above mentioned proc is DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS
> ( only for 10.2 ).
> Streams is Oracle's official replacement for Adv. Replication.
> RAC, Data Guard ( standby), Streams( Adv Repl), can all be considered (
> partially ) as HA solutions and in that sense
> they are interchangeable.
> Standby can be in the same cage as primary so it is not only for site
> protection.
>
> Regards, Ranko.
>
> On 11/12/05, Pete Sharman <peter.sharman@xxxxxxxxxx
> <mailto:peter.sharman@xxxxxxxxxx>> wrote:
>
> Nope I disagree with your comment on Streams being an alternative to
> RAC. Nor is advanced rep. They solve totally different problems -
> RAC is for protection from machine failure (and scalability on the
> other side of the equation), Streams and advanced replication are
> for data distribution and protection from site failure (this last
> aspect also being something that DataGuard resolves). Some people
> (who I also disagree with) are saying that RAC with extended
> clusters can solve the site failure issue as well. So if anything,
> there is a possible argument that RAC can be considered an
> alternative to Streams, but not the other way around. J
>
>
>[...]
> <mailto:oracle-l-bounce@xxxxxxxxxxxxx>] On Behalf Of Ranko Mosic
> Sent: Sunday, 13 November 2005 2:04 AM
> To: gorbyx@xxxxxxxxx <mailto:gorbyx@xxxxxxxxx>
> Cc: Oracle-L Freelists
> Subject: Re: "Oracle Streams" by Madhu Tumma
>
[...]
>
> Streams is Oracle's replacement for Advanced Replication. In that
> sense it can be considered as an alternative to RAC.
>
> I liked it - much easier to setup then AR, good performance in test
> env.
>
> There is good working example on otn written by Mishra on basic setup.
>
> 10g also has dbms_streams.maintain_schema proc that enables simple
> replication setup for the whole schema in ONE step.
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
