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" <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >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: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] 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 > > ><[EMAIL PROTECTED]> > > >To: Multiple recipients of list ORACLE-L > > ><[EMAIL PROTECTED]> > > >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 ><[EMAIL PROTECTED]> > > >wrote: > > >> yes. Well documented in the manuals > > >> > > >> > > >> --- Juan Miranda <[EMAIL PROTECTED]> >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: [EMAIL PROTECTED] > > -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
