Streams capture from an active DG standby

  • From: "John Hallas" <john.hallas@xxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 11 Apr 2008 15:46:29 +0100

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

Other related posts: