Re: Oracle Streams and Data Guard

From: Job Miller <>
Date: Mon, 23 Aug 2010 17:31:01 -0700 (PDT)
Message-ID: <>


You'll want to take a look at:

It's old, but it discusses Streams and DG failover/role transitions and should provide you the missing pieces.

I am working with one of your peers who is attempting to move from local capture to downstream capture, because they were finding the impact of local capture to be troublesome in their environment.

The idea of rewiring the delivered streams setup to be downstream capture is something you may want to consider. Your ERP vendor is already aware that another university is trying to make that switch.

Does anyone have any experience moving from local to downstream capture without disrupting the target environment?


  • On Mon, 8/23/10, Maureen English <> wrote:

> From: Maureen English <>
> Subject: Re: Oracle Streams and Data Guard
> To:
> Date: Monday, August 23, 2010, 4:09 PM
> 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.
> >
> --

Received on Mon Aug 23 2010 - 19:31:01 CDT

Original text of this message