Oracle Streams and Data Guard

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

We've recently been told that we will likely need to set up Oracle
Streams to replicate some data from our main production database to
another database.  We're also in the process of setting up a new
disaster recovery site using a standby get the data
from our main production database.

I'm familiar with the standby database least an 8i
version.  Data Guard doesn't look that much different as far as the
way to set things up.  Oracle Streams looks like it does something
similar to a logical standby, using a different process.

I'm wondering if anyone is using Data Guard with their primary
database also using Oracle Streams to send data to a different
database.  If so, are there any details to be aware in
the case of a disaster when the primary goes down and the standby
comes up as the primary...should the standby somehow be configured
to use Oracle Streams to pass the data to the database that was
receiving it from the primary before the disaster?

I have read through some of the documentation, but not all of it, so
my questions may be answered in what I haven't read.  I'm just curious
if anyone else is doing something similar and is interested in sharing
their insights/experiences.

- Maureen

Other related posts: