Re: "Oracle Streams" by Madhu Tumma
- From: Ranko Mosic <ranko.mosic@xxxxxxxxx>
- To: Pete Sharman <peter.sharman@xxxxxxxxxx>
- Date: Sat, 12 Nov 2005 18:37:29 -0500
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> 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@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Ranko Mosic
> *Sent:* Sunday, 13 November 2005 2:04 AM
> *To:* gorbyx@xxxxxxxxx
> *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@xxxxxxxxx> 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
>
>
Other related posts:
