| 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
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 -----------------------------------------------------------------Received on Tue Jul 13 2004 - 13:03:30 CDT
 |
 |