Hello sonicefu.

I have Data Guard with Physical Standby like you. Now, I am testing Oracle Streams between two different servers and I want to configure Oracle Streams between Primary and another server, like you tell us in this post.

It is work? When you exec a switchover or failover, the Standby database works like source in the Stream configuration? I need be sure about this.

My Stream configuration between Primary and Destination server not work. I don't know why but I am working in this question. The problems are in the apply process, something about SCN. Any idea?

Hope you read this post.

Thank you.


Quote Originally Posted by sonicefu View Post
Hi Experts,

I want to configure Data Guard (Physical Standby) + Oracle Streams for HA and DR. I have configured Data Guard at 2 servers and Oracle Streams between Primary Database and Streams Subscriber (3rd Database server) successfully.
Should I implement streams at Standby Database also so that my implementation can become a HA implementation?

Hope to hear from you soon !

Best Regards,