From oracle-l-bounce@freelists.org Fri Feb 18 16:33:28 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j1IMXGwL005448 for ; Fri, 18 Feb 2005 16:33:16 -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 j1IMX6em005437 for ; Fri, 18 Feb 2005 16:33:08 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 64F7673326; Fri, 18 Feb 2005 16:25:15 -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 02365-08; Fri, 18 Feb 2005 16:25:15 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D4BA97332E; Fri, 18 Feb 2005 16:25:14 -0500 (EST) Subject: Re: SV: Logical standby transaction_consistency parameter to none From: Carel-Jan Engel To: birkir@teymi.is Cc: "oracle-l@freelists.org" In-Reply-To: <20050218150217067.00000016184@birkir-pc> References: <20050218150217067.00000016184@birkir-pc> Content-type: text/plain Organization: DBA!ert Message-Id: <1108754318.6552.18.camel@dbalert199.dbalert.nl> Mime-Version: 1.0 Date: Fri, 18 Feb 2005 20:18:38 +0100 Content-Transfer-Encoding: 8bit X-archive-position: 16422 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: cjpengel.dbalert@xs4all.nl Precedence: normal Reply-To: cjpengel.dbalert@xs4all.nl X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.60 X-Spam-Level: Birkir, How is this DWH using the Logical Standby? If you use it for E.G. ETL, you might consider switching to Physical Standby, and open that in Read Only mode periodically. It will easier keep up with the primary. When you create a cron job that sets the database in Read-only mode every morning, say at 7am, and switches it back to managed recovery at 7 pm, the DWH can be feeded, and you have a nice DR database available as well. Finally, you can get rid of the supplemental logging, which will save the amount of redo on your primary. Best regards, Carel-Jan Engel === If you think education is expensive, try ignorance. (Derek Bok) === Upcoming appearances: * Mar 6-10, 2005: Dallas, Hotsos Symposium: Data Guard Performance Issues On Fri, 2005-02-18 at 16:02, Birkir Bjornsson wrote: > Hi > > Thanks for your reply. I will look at the white paper you suggested. The st= > andby database in this case is used as a query database for a data warehous= > e. I will probably try setting it to none and If that doesn=B4t help me I g= > uess I will have to re-instantiate the Database. > > Thanks again for your reply = > > Birkir Bjornsson > > -----Upphafleg bo=F0----- > Sendandi: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.o= > rg] Fyrir h=F6nd Mark Bole > Sent: 18. febr=FAar 2005 14:17 > Samrit: oracle-l@freelists.org > Efni: Re: Logical standby transaction_consistency parameter to none > > Birkir Bjornsson wrote: > > =3D = > > > = > -- http://www.freelists.org/webpage/oracle-l