Home » Server Options » Data Guard » 2x standby db - 1 using redo apply & 1 using sql apply
2x standby db - 1 using redo apply & 1 using sql apply [message #165529] Thu, 30 March 2006 16:58 Go to next message
Messages: 1
Registered: March 2006
Junior Member
We are wanting to setup 2 standby databases - 1 for DR/failover using redo apply and 1 for reporting using SQL apply.
The first standby db is strictly for failover as the Primary db is a 24x7 system. The second db will allow us to add Summary tables & Materialized views around the core data and remove all reports processing away from the Primary.
Oracle documentation says you can have up to 9 standby databases, but doesn't say they can be populated by the 2 different methods (redo & SQL apply).
I'm assuming we can, but would like to know if anyone else has successfully setup a similar scenario before investing large amounts of time.
Re: 2x standby db - 1 using redo apply & 1 using sql apply [message #165694 is a reply to message #165529] Fri, 31 March 2006 09:46 Go to previous message
Messages: 13
Registered: February 2006
Location: SC
Junior Member
As a short answer - yes.

We have successfully tested setting up both a physical and logical standby on the same primary - basically for the same reasons you are looking to do it. We are working toward rolling this out in our production environment soon.

Our environment is a 10GR1 4 node RAC cluster with physical replication to a single node DR site and soon logical standby to a single node reporting environment.
Previous Topic: 10g Data Guard Fast Start Failover
Next Topic: Urgent - stuck in setting up standby
Goto Forum:

Current Time: Mon Jul 15 10:29:25 CDT 2024