Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Logical standb by

RE: Logical standb by

From: John P Weatherman Jr. <asahoshi_at_infionline.net>
Date: Tue, 13 Jul 2004 14:06:07 -0400
Message-ID: <410-2200472131867318@infionline.net>


Seema,

We are currently running logical standby with mixed results. This is Oracle 9.2.0.4 on
Solaris9, I can't speak to other platforms. LSB is finicky at best. In particular, I have
found skipping non_schema_ddl a requirement, not a suggestion (in my case the
this was evident from hot backups). In addition, getting the apply operation to run
relatively smoothly required that transaction_apply be set to READ_ONLY, otherwise
deadlocks were far too common. Also keep in mind that MTS is NOT supported, nor
are a LOT of datatypes. Use the scripts to make sure you have everything set up
before proceeding. I have also found that LSD doesn't handle deadlocks on the
primary ell at all, it will kill the apply every time and skipping all the downstream
transactions can be trying. Also, reinstantiating tables after they are skipped has
numerous bugs associated with it, thankfully they often have patches already.
Large volumes of updates (data conversions for instance) can also result in needing
to rebuild the whole site, as the backlog will never catch up, well, not before the ice
caps melt anyway.

All that said, when it is working, it works just fine. While there are far too many days I
find myself rebuilding the LSB, we can also go for weeks without any issues at all, as long
as the primary stays stable and the data volumes are "normal". I know, faint praise. In
general, I expect a relatively static environment (in terms of software builds) that doesn't
have lots of daily problems is best for logical.

Like another reply, I would say that Physical Standby is very solid. I haven't had any problems
with it worth mentioning.

Just my $0.02.

John P Weatherman
Oracle DBA
Advance America

> [Original Message]
> From: Seema Singh <oracledbam_at_hotmail.com>
> To: <oracle-l_at_freelists.org>
> Date: 7/13/2004 1:26:11 PM
> Subject: Logical standb by
>
> Hi,
>
> I'm planning to setup Logical standby database on ORacle9.2.
> Just wanted to know how stable LSB in 9.2?
> any suggestionS?
> thx -seema
>
> _________________________________________________________________
> Get fast, reliable Internet access with MSN 9 Dial-up now 2 months
FREE!
> http://join.msn.click-url.com/go/onm00200361ave/direct/01/
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_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
> -----------------------------------------------------------------



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_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
-----------------------------------------------------------------
Received on Tue Jul 13 2004 - 13:03:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US