Re: Oracle Streams and Data Guard

  • From: Maureen English <maureen.english@xxxxxxxxxx>
  • To: Oracle-L@xxxxxxxxxxxxx
  • Date: Mon, 23 Aug 2010 12:09:26 -0800

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


Other related posts: