I tried it on 9.2.0.3.0 running on two Linux machines. I doubt all bugs were fixed in 9.2.0.4. I currently consider LSB to be a prototype, an interesting foretaste of things to come, but hardly more.
It of course depends on the size of the database, but couldn't you consider doing reporting on a Day - 1 database?
Might be simpler to use your hot backups and recreate a backup database every night. Or perhaps use snaphots (sorry, materialized views) - traditional replication (you don't need the 'advanced' stuff). If the production database can bear the overhead.
Anyway, if you are as lucky as I was, this is (rebuilding the database from your backups) what you may well end doing with LSB (plus the 26 step process each time - well, I wrote scripts to help).
HTH,
SF
>----- ------- Original Message ------- -----
>From: "Juan Miranda" <j.miranda_at_sermatica.es>
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>Sent: Thu, 13 Nov 2003 00:34:25
>
>
>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
--
Author: Stephane Faroult
INET: sfaroult_at_oriolecorp.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).
Received on Thu Nov 13 2003 - 03:39:25 CST
