| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Logical standb by
9.2.0.5 is supposed to fix a number of LSB problems in earlier 9x, but it
seems to have other problems (e.g. CBO bugs)....
Disclaimer: I've not tested LSB in 9.2.0.5.
RF
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
To: oracle-l_at_freelists.org
Sent: 7/13/2004 1:06 PM
Subject: RE: Logical standb by
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
> -----------------------------------------------------------------
-- 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:23:03 CDT
 |
 |