Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: "Oracle Streams" by Madhu Tumma

Re: "Oracle Streams" by Madhu Tumma

From: Ranko Mosic <ranko.mosic_at_gmail.com>
Date: Sat, 12 Nov 2005 18:37:29 -0500
Message-ID: <367369f10511121537t7f9d00a6lb8744ea5ff60cfaf@mail.gmail.com>


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_at_oracle.com> 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
>
> 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
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Ranko Mosic
> *Sent:* Sunday, 13 November 2005 2:04 AM
> *To:* gorbyx_at_gmail.com
> *Cc:* Oracle-L Freelists
> *Subject:* Re: "Oracle Streams" by Madhu Tumma
>
> Just to add, went briefly through the book - it has just a tad more then
> what you'll find in manuals.
>
> Not worth your time.
>
> 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.
>
> Regards, Ranko.
>
> On 11/12/05, *Alex Gorbachev* <gorbyx_at_gmail.com> wrote:
>
> Thanks to all for replying online and offline.
>
> My monitor stand is high enough (including couple books from than
> publisher already). And more important - no spare time.
>
> Regards,
>
> Alex
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Nov 12 2005 - 17:39:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US