From oracle-l-bounce@freelists.org Sat Nov 12 11:26:08 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id jACHQ8Fc005968 for ; Sat, 12 Nov 2005 11:26:08 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id jACHQ3vX005958 for ; Sat, 12 Nov 2005 11:26:03 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BB4B02257DE; Sat, 12 Nov 2005 12:26:02 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15882-10; Sat, 12 Nov 2005 12:26:02 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2C0DF22547C; Sat, 12 Nov 2005 12:26:02 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Sat, 12 Nov 2005 12:24:08 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3278C225477 for ; Sat, 12 Nov 2005 12:24:08 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15571-04 for ; Sat, 12 Nov 2005 12:24:08 -0500 (EST) Received: from rgminet01.oracle.com (rgminet01.oracle.com [148.87.122.30]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DA6F92253CD for ; Sat, 12 Nov 2005 12:24:07 -0500 (EST) Received: from rgmgw2.us.oracle.com (rgmgw2.us.oracle.com [138.1.186.111]) by rgminet01.oracle.com (Switch-3.1.6/Switch-3.1.6) with ESMTP id jACHO51H011956; Sat, 12 Nov 2005 10:24:05 -0700 Received: from localhost (localhost [127.0.0.1]) by rgmgw2.us.oracle.com (Switch-3.1.4/Switch-3.1.0) with SMTP id jACHO5Mq017463; Sat, 12 Nov 2005 10:24:05 -0700 Received: from us.oracle.com (dhcp-amer-csvpn-gw1-141-144-64-49.vpn.oracle.com [141.144.64.49]) by rgmgw2.us.oracle.com (Switch-3.1.4/Switch-3.1.0) with ESMTP id jACHNxfO017268; Sat, 12 Nov 2005 10:23:59 -0700 From: "Pete Sharman" To: "ranko.mosic@gmail.com" , "gorbyx@gmail.com" Cc: "Oracle-L Freelists" , "Peter Ross Sharman" Subject: RE: "Oracle Streams" by Madhu Tumma Date: Sun, 13 Nov 2005 04:23:48 +1100 Message-ID: <20051113042348920.00000004044@psharman-au> In-Reply-To: <367369f10511120703v32cf479dya6307770616d3cd6@mail.gmail.com> X-Accept-Language: en-au, en MIME-Version: 1.0 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis X-Brightmail-Tracker: AAAAAQAAAAIX-Whitelist: TRUE X-archive-position: 28302 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: peter.sharman@oracle.com Precedence: normal Reply-To: peter.sharman@oracle.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.3 required=5.0 tests=BAYES_00,HTML_70_80, HTML_FONTCOLOR_UNKNOWN,HTML_MESSAGE,MIME_HTML_ONLY autolearn=no version=2.63

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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Ranko Mosic
Sent: Sunday, 13 November 2005 2:04 AM
To: gorbyx@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@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