From oracle-l-bounce@freelists.org Tue Apr 26 08:54:31 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j3QDsVQc001549 for ; Tue, 26 Apr 2005 08:54:31 -0500 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 j3QDsV4Z001545 for ; Tue, 26 Apr 2005 08:54:31 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4DCAF18682C; Tue, 26 Apr 2005 07:52:05 -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 29180-02; Tue, 26 Apr 2005 07:52:05 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C4DBC18681B; Tue, 26 Apr 2005 07:52:04 -0500 (EST) Message-ID: <426E3907.9030400@pacbell.net> Date: Tue, 26 Apr 2005 05:50:15 -0700 From: Mark Bole User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 Cc: oracle-l@freelists.org Subject: Re: Advanced replication vs Logical standby References: <20050426120933.85721.qmail@web60702.mail.yahoo.com> In-Reply-To: <20050426120933.85721.qmail@web60702.mail.yahoo.com> Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-archive-position: 18997 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: makbo@pacbell.net Precedence: normal Reply-To: makbo@pacbell.net X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.63 A Joshi wrote: > Hi, > We are currently using advanced replication with a primary and secondary. We plan to move to Logical standby. We are hoping logical standby will support more data types and will be better in general maintenance then advanced replication. Does anyone have any other experience with it? Any catches? Thanks > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > -- > http://www.freelists.org/webpage/oracle-l > I doubt the maintenance will be any less, but at least it will be different. Logical standby is based on Streams (LCRs) while Advanced Replication will most likely become deprecated in some future release, so it's a good direction to go in. In version 9i, I used logical standby for a production reporting database but there are some bugs that may require you to use the DBMS_LOGSTDBY.SKIP* procedures more often than you'd like. The one thing that helped most was a white paper off of Metalink titled "Oracle 9i Data Guard: SQL Apply Best Practices". You will have to turn on FORCE LOGGING and add supplemental logging to your primary, but you can eliminate the snapshot logs and such, so overall it should reduce the workload on your primary. -- Mark Bole http://www.bincomputing.com -- http://www.freelists.org/webpage/oracle-l