From oracle-l-bounce@freelists.org Sat May 15 17:40:09 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i4FMdsQ01609 for ; Sat, 15 May 2004 17:40:04 -0500 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 i4FMdi601587 for ; Sat, 15 May 2004 17:39:54 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4756372C0C2; Sat, 15 May 2004 17:29: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 20510-50; Sat, 15 May 2004 17:29:04 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C16B972C01C; Sat, 15 May 2004 17:29:02 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Sat, 15 May 2004 17:27:43 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C211672C00D for ; Sat, 15 May 2004 17:27:42 -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 20468-16 for ; Sat, 15 May 2004 17:27:42 -0500 (EST) 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 5212F72C02C for ; Sat, 15 May 2004 17:27:41 -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 i4FMh75a009309 for ; Sun, 16 May 2004 00:43:07 +0200 (CEST) Message-Id: <6.0.1.1.0.20040516003554.43f80220@pop.xs4all.nl> X-Sender: (Unverified) X-Mailer: QUALCOMM Windows Eudora Version 6.0.1.1 Date: Sun, 16 May 2004 00:42:24 +0200 To: oracle-l@freelists.org From: Carel-Jan Engel Subject: Re: Physicall to Logical In-Reply-To: <20040514194824.58992.qmail@web20729.mail.yahoo.com> References: <20040514194824.58992.qmail@web20729.mail.yahoo.com> Mime-Version: 1.0 Content-type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 644 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 X-Virus-Scanned: by amavisd-new at freelists.org Sanjay, Conversion between Standby types is non-existent. You have to drop the PSB, and re-instantiate an LSB. I don't know whether you are right or not, LSB is released with 9iR2, and certainly isn't very stable. I wouldn't rely on it for HA-purposes. For reporting, with restrictions in mind about unsupported data- and objecttypes, the cost of additional logging etcetera, it might help you. Don't jump into solutions, but get your requirements for standby written down properly first. Then determine whether a proposed solution will work. And test! You might consider (if space allows you) to have PSB as well as LSB. PSB for HA, LSB for reporting. Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === At 09:48 PM 5/14/2004, you wrote: >Hi > >Can anybody has an idea that how can I convert mine existing Physical >standby to Logical standby. I am on 9iRel 2 and If I am right then >Logicall standby is working good in this release. >thanks in Advance > >Sanjay > > ---------------------------------------------------------------- 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 -----------------------------------------------------------------