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
3) instance vs. storage
(this overlaps with some of Pete Sharman's comments quoted below).
-Mark Bole
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