Re: Streams capture from an active DG standby
- From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
- To: john.hallas@xxxxxxxxxx
- Date: Sat, 12 Apr 2008 11:46:21 -0400
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@xxxxxxxxxx> 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@xxxxxxxxx]
> *Sent:* 11 April 2008 22:39
> *To:* John Hallas
> *Cc:* oracle-l@xxxxxxxxxxxxx
> *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@xxxxxxxxxx>
> 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
Other related posts:
