Re: Advanced replication vs Logical standby

It depends on the goals you want to achieve.

• Standby / Failover?
• Running reports / queries on remote database?
• What is the frequency needed to update the remote (regarding dataloss, how much delay in reporting allowed)

Choosing a solution shouldn't be a technology driven choice, but rather a requirement driven choice. After finishing the specs solutions can be considered on pro's and cons, and then the choice can be made. Involve mgmt in the trade-offs, when they expect High Availability it is your responsibility, unless you involved them in the decision to rule out certain (expensive?) features.

I've seen Logical Standby's with rather much maintenance involved, it's not particularly easier than AR.

Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok) ===

> 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
>

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