Re: Advanced replication vs Logical standby

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
>
> --
> http://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



--
http://www.freelists.org/webpage/oracle-l