Hi. We are in the process of converting to Oracle 10g. We are also in the process of consolidating all databases running on Windows 2003 and Novell into one Solaris Server. Therefore, we need to have some high-availability solution in place. We have investigated several approaches, including RAC, HA Cluster (Solaris) and Data Guard solutions. For budget reasons, we have to eliminate RAC.
Let's assume I have four databases (D1, D2, D3 and D4) and two Solaris servers (S1 and S2). The configuration that I have in mind is: D1 and D2 will be located on S1, and their corresponding physical standby servers for D1 and D2 will be on S2. D3 and D4 production databases wil be on S2, and their corresponding physical standby databases will be on S1. This allows me to achieve load balancing.
What I am not sure of is, can HA offer a similar solution? I am afraid not. HA will keep one node active all the time and the other will be idle. We are very new to Solaris and we have a consultant helping us out. He recommends the HA solution.
Can you shed any thoughts on this? Are there any elegant solutions out there other than what I have discussed here?
The bottom line is load balancing and high availability for consolidating our database servers at a reasonable cost.