Re: Advanced replication vs Logical standby
- From: Mark Bole <makbo@xxxxxxxxxxx>
- Date: Tue, 26 Apr 2005 05:50:15 -0700
A Joshi wrote:
> Hi,
> We are currently using advanced replication with a primary and secondary.
> We plan to move to Logical standby. We are hoping logical standby will
> support more data types and will be better in general maintenance then
> advanced replication. Does anyone have any other experience with it? Any
> catches? Thanks
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> --
> //www.freelists.org/webpage/oracle-l
>
I doubt the maintenance will be any less, but at least it will be
different. Logical standby is based on Streams (LCRs) while Advanced
Replication will most likely become deprecated in some future release,
so it's a good direction to go in.
In version 9i, I used logical standby for a production reporting
database but there are some bugs that may require you to use the
DBMS_LOGSTDBY.SKIP* procedures more often than you'd like. The one
thing that helped most was a white paper off of Metalink titled "Oracle
9i Data Guard: SQL Apply Best Practices".
You will have to turn on FORCE LOGGING and add supplemental logging to
your primary, but you can eliminate the snapshot logs and such, so
overall it should reduce the workload on your primary.
--
Mark Bole
http://www.bincomputing.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
