Oracle-L: RE: Re: Logical StandBy question

From: Juan Miranda <j.miranda_at_sermatica.es>
Date: Thu, 13 Nov 2003 00:34:25 -0800
Message-ID: <F001.005D675F.20031113003425@fatcity.com>

I am just planning a LOGICAL data guard installation in an important client. They need it for reporting and backup (primary is 24x7x365 and we have hot backup.)

I didn?t kwon that LSB are so bad.

So do you think It is so bad that you don?t put it into production ???

Do you try 9.2.0.4 ??

I need to take a decision....

I thank your previous answers.
(I read doc, of course, but It is not explicity say that)   -----Mensaje original-----
  De: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]En nombre de Carel-Jan Engel
  Enviado el: miercoles, 12 de noviembre de 2003 19:59   Para: Multiple recipients of list ORACLE-L   Asunto: RE: Re: Logical StandBy question

Walt, drop me your email-address, and I send you the handouts of a special I presented about DG for Oracle University in Stockholm.

I'm going out now for a few hours (it's 19.30 over here), but I'll respond later this evening.

regards, Carel-Jan
At 09:19 12-11-03 -0800, you wrote:

Stephane,

What sort of problems can one expect from logical standby?

I'm toying with the idea of using it as a replication database -- no additional schema objects will be created, but users will have read-only access to it. It's one of the options I'm looking at.

Seems to me like there was a thread on this a few months ago, but I'm not sure...

--Walt

On Wed, 2003-11-12 at 09:49, Stephane Faroult wrote:
> Jose Luis,
>
> What you say refers to the physical standby database (which works
well),

> not to the logical standby database (which on the paper looks great,
allows you to open the database, create additional tablespaces, create additional indexes on replicated objects etc) but which in practice still has a lot of teething troubles. Wouldn't use it in production on Oracle 9.2.

>
> HTH,
>
> SF
>
> >----- ------- Original Message ------- -----
> >From: Jose Luis Delgado
> ><joseluis_delgado_at_yahoo.com>
> >To: Multiple recipients of list ORACLE-L
> ><ORACLE-L_at_fatcity.com>
> >Sent: Wed, 12 Nov 2003 08:09:27
> >
> >Hmmmmmm...
> >
> >I'd like to know where in the manuals... :-)
> >
> >I do not think so since the standby database stay
> >in
> >permanent recovery mode.
> >
> >JL
> >
> >--- Rachel Carmichael <wisernet100_at_yahoo.com>
> >wrote:
> >> yes. Well documented in the manuals
> >>
> >>
> >> --- Juan Miranda <j.miranda_at_sermatica.es> wrote:
> >> >
> >> >
> >> > Hi
> >> >
> >> > It is posible to create other schemas on a
> >logical
> >> stand by database
> >> > ?
> >> >
> >> > I mean, schemas that don?t exist in the primary
> >
> >> database.
> >> > --
> >> > Please see the official ORACLE-L FAQ:
> >> http://www.orafaq.net
> >> > --
> >> > Author: Juan Miranda
> >> > INET: j.miranda_at_sermatica.es
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net     --
    Author: Walt Weaver
      INET: wweaver_at_rightnow.com

    Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
    San Diego, California        -- Mailing list and web hosting services
    ---------------------------------------------------------------------

    To REMOVE yourself from this mailing list, send an E-Mail message     to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in     the message BODY, include a line containing: UNSUB ORACLE-L     (or the name of mailing list you want to be removed from). You may     also send the HELP command for other information (like subscribing).   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_at_xs4all.nl

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Juan Miranda
  INET: j.miranda_at_sermatica.es

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Nov 13 2003 - 02:34:25 CST