From oracle-l-bounce@freelists.org Mon Mar 1 08:45:59 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i21Ejxi02395 for ; Mon, 1 Mar 2004 08:45:59 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i21Ejwo02390 for ; Mon, 1 Mar 2004 08:45:58 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 799FB395006; Mon, 1 Mar 2004 09:46:42 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 01 Mar 2004 09:45:37 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from smtp-out4.xs4all.nl (smtp-out4.xs4all.nl [194.109.24.5]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BC6B7394FAD for ; Mon, 1 Mar 2004 09:45:34 -0500 (EST) Received: from dbalert99a.xs4all.nl (dbalert.xs4all.nl [213.84.185.230]) by smtp-out4.xs4all.nl (8.12.10/8.12.10) with ESMTP id i21En5WA010246 for ; Mon, 1 Mar 2004 15:49:05 +0100 (CET) Message-Id: <6.0.1.1.0.20040301143445.435147f0@pop.xs4all.nl> X-Sender: careljan@pop.xs4all.nl X-Mailer: QUALCOMM Windows Eudora Version 6.0.1.1 Date: Mon, 01 Mar 2004 14:48:56 +0000 To: oracle-l@freelists.org From: Carel-Jan Engel Subject: Re: Logical Standby Switchover on Solaris In-Reply-To: References: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=====================_139917507==.ALT" X-archive-position: 91 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: oracle-l@freelists.org X-list: oracle-l --=====================_139917507==.ALT Content-Type: text/plain; charset="us-ascii"; format=flowed Hi Indy, I've configured appr. 30 DG installations, 8(.1.7/9.01/9.2.0.2 and up), and only one of them was LSB. This one was intended for serving the www-access, and witth the LSB solution the internet-users couldn't hurt performance on the Primary (publishing) system. HA was asserted using a PSB server as well. LSB appeared not be as stable as we wished. (This is 9.2.0.2) Apart from whatever OS you are on, I would not advise you to rely on LSB for failover purposes. For reporting, in some cases, yes, it can be useful. For High Availability you should rely on PSB. If you need both HA and LSB, consider configuring both LSB and PSB. All the documented stuff in Chapter 8 of the DG Concepts & Administration Guide should make you doubt whether you would rely on this for HA. At least I did, and decided not to go for it and advise my customers accordingly. There are simply too much failures possible in the Log Apply services related to unallowed DML etc. As long as you are not responsible for the DML executed (which DBA is?), applications can seriously damage the setup you tediously created. PSB is pretty straightforward, once you master the concepts, and has pretty much matureness right now. LSB is still immature (at least in 9i, I'm setting up a test in 10g). Regards, Carel-Jan At 02:10 PM 3/1/2004, you wrote: >Hi, > >Is there anybody configured Logical Standby on Sun solaris and if yes, can >you please update the ORacle/OS version including any additional Patches. >The important point I need to know if they have done the successful >switchover. I had tried this and it failed and still working with Oracle >support but so far with no result. If somebody has done the Switchover >test on other paltform, then please share the Platform. I am doing some >test with ORacle 10G today so as see if it works there. Actually I had >one of the Reporting site created with Logical standby for QA and it >failed to switchover and so been struck with rollover to PRoduction. > >Thanks > >Indy Johal >Manager, Database Administration >PR Newswire >indy_johal@prnewswire.com >http://www.prnewswire.com > >(201) 946-5687 [W] >(201) 220 6781 [M] > >"We tell your story to the world." === If you think education is expensive, try ignorance. (Derek Bok) === DBA!ert, Independent Oracle Consultancy Kastanjelaan 61C 2743 BX Waddinxveen The Netherlands tel. +31 (0) 182 640 428 fax +31 (0) 182 640 429 mobile +31 (0) 653 911 950 e-mail info.dbalert@xs4all.nl --=====================_139917507==.ALT Content-Type: text/html; charset="us-ascii" Hi Indy,

I've configured appr. 30 DG installations, 8(.1.7/9.01/9.2.0.2 and up), and only one of them was LSB. This one was intended for serving the www-access, and witth the LSB solution the internet-users couldn't hurt performance on the Primary (publishing) system. HA was asserted using a PSB server as well. LSB appeared not be as stable as we wished. (This is 9.2.0.2)

Apart from whatever OS you are on, I would not advise you to rely on LSB for failover purposes. For reporting, in some cases, yes, it can be useful. For High Availability you should rely on PSB. If you need both HA and LSB, consider configuring both LSB and PSB.
All the documented stuff in Chapter 8 of the DG Concepts & Administration Guide should make you doubt whether you would rely on this for HA. At least I did, and decided not to go for it and advise my customers accordingly. There are simply too much failures possible in the Log Apply services related to unallowed DML etc. As long as you are not responsible for the DML executed (which DBA is?), applications can seriously damage the setup you tediously created. PSB is pretty straightforward, once you master the concepts, and has pretty much matureness right now. LSB is still immature (at least in 9i, I'm setting up a test in 10g).

Regards, Carel-Jan



At 02:10 PM 3/1/2004, you wrote:

Hi,

Is there anybody configured Logical Standby on Sun solaris and if yes, can you please update the ORacle/OS version including any additional Patches. The important point I need to know if they have done the successful switchover. I had tried this and it failed and still working with Oracle support  but so far with no result. If somebody has done the Switchover test on other paltform, then please share the Platform. I am doing some test with ORacle 10G today so as see if it works there.  Actually I had one of the Reporting site created with Logical standby  for QA and it failed to switchover and so been struck with rollover to PRoduction.

Thanks

Indy Johal
Manager, Database Administration
PR Newswire
indy_johal@prnewswire.com
http://www.prnewswire.com

(201) 946-5687 [W]
(201) 220 6781 [M]

"We tell your story to the world."

===
If you think education is expensive, try ignorance. (Derek Bok)
===

DBA!ert, Independent Oracle Consultancy
Kastanjelaan 61C
2743 BX  Waddinxveen
The Netherlands
tel.    +31 (0) 182 640 428
fax     +31 (0) 182 640 429
mobile  +31 (0) 653 911 950
e-mail info.dbalert@xs4all.nl



--=====================_139917507==.ALT-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------