Re: Streams capture from an active DG standby

You setup apply process for downstream capture in exactly the same way is you do in "upstream" configuration.

The only difference is how your create capture.

I also prefer to use a single queue for capture/apply in downstream configuration to get rid of propagation.

On Sat, Apr 12, 2008 at 9:07 AM, John Hallas <john.hallas_at_bjss.co.uk> wrote:

> Ghassan,
>
>
>
> I am still experimenting with downstream log capture (archived_log) but
> have not got it to work yet. There seems to be a shortage of information
> around it, especially on getting the apply process to work. However that is
> a separate issue to this.
>
>
>
> In theory I cannot see why you cannot read the redo logs from a standby
> database (especially if you are using Active DG) and apply those changes to
> another database, I just cannot see any information anywhere about if it is
> possible or not.
>
>
>
> John
>
>
> ------------------------------
>
> *From:* Ghassan Salem [mailto:salem.ghassan_at_gmail.com]
> *Sent:* 11 April 2008 22:39
> *To:* John Hallas
> *Cc:* oracle-l_at_freelists.org
> *Subject:* Re: Streams capture from an active DG standby
>
>
>
> John
> from your last sentence
> "
>
> We are looking at shipping redo logs over to the remote site and then
> capturing transactions on that end to keep other databases in sync, all at
> the remote site.
>
> "
> it seems that you're looking after downstream capture. did you look into
> it?
>
> rgds
>
> On Fri, Apr 11, 2008 at 4:46 PM, John Hallas <john.hallas_at_bjss.co.uk>
> wrote:
>
> In 11G (OEL5 Linux) using Active dataguard does anybody know if it is
> possible to capture transactions at a schema level using Streams from the
> STANDBY database.
>
>
>
> I have searched the docs but I cannot find anything to prove or disprove
> it.
>
>
>
> Even if not using active DG is it possible to do the same from the standby
> database.
>
>
>
> We are looking at shipping redo logs over to the remote site and then
> capturing transactions on that end to keep other databases in sync, all at
> the remote site.
>
>
>
> Cheers
>
>
>
> John
>
>
>
> +44 (0)113 223 2274 (direct)
>
> +44 (0)113 297 9797
>
>
> ------------------------------
>
> The information included in this email and any files transmitted with it
> may contain information that is confidential and it must not be used by, or
> its contents or attachments copied or disclosed, to persons other than the
> intended addressee. If you have received this email in error, please notify
> BJSS.
> In the absence of written agreement to the contrary BJSS' relevant
> standard terms of contract for any work to be undertaken will apply.
> Please carry out virus or such other checks as you consider appropriate in
> respect of this email. BJSS do not accept responsibility for any adverse
> effect upon your system or data in relation to this email or any files
> transmitted with it.
> BJSS Limited, a company registered in England and Wales (Company Number
> 2777575), VAT Registration Number 613295452, Registered Office Address,
> First Floor, Coronet House, Queen Street, Leeds, LS1 2TW
>
>
>
> ------------------------------
> The information included in this email and any files transmitted with it
> may contain information that is confidential and it must not be used by, or
> its contents or attachments copied or disclosed, to persons other than the
> intended addressee. If you have received this email in error, please notify
> BJSS.
> In the absence of written agreement to the contrary BJSS' relevant
> standard terms of contract for any work to be undertaken will apply.
> Please carry out virus or such other checks as you consider appropriate in
> respect of this email. BJSS do not accept responsibility for any adverse
> effect upon your system or data in relation to this email or any files
> transmitted with it.
> BJSS Limited, a company registered in England and Wales (Company Number
> 2777575), VAT Registration Number 613295452, Registered Office Address,
> First Floor, Coronet House, Queen Street, Leeds, LS1 2TW
>

-- 
Alex Fatkulin,
The Pythian Group,
http://www.pythian.com/blogs/author/alexf

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