Niall, Jed, rest of list; The standby database will be strictly for disaster recovery, running in managed recover mode, not read only mode. The streams implementation is a new requirement. I believe it will be to just replicate data to a third database...only certain data, not the entire database. This database will likely be used for another purpose...one needing a subset of production data in real time. I'm not sure we have a choice regarding the use of Oracle Streams, even though, as you say, it seems that a logical standby could serve the same purpose. It's the vendor's requirement to use Oracle Streams, and our internal disaster recovery plan to use the standby database. - Maureen Niall Litchfield wrote:
What's the purpose of the standby, and indeed of the streams implementation. You might consider making it a logical standby - or having one physical one logical - to meet your requirements.