Comparing Oracle High Availability Solutions


We are looking for a solution where our application is able to either write to two databases on separate servers in separate data centers or have Oracle manage this synchronization of data for redundancy.  We need the application to be up 24x7 so we were looking at Data Guard originally.

Current architecture in test is:

Application 1 (A1) and Database 1 (DB2)  are on the same server.  Application 2 (A2) and Database 2 (DB2)  are on another server.   If the A1/DB2 Server fails, corosync switches everything to A2/DB2 and Oracle bidirectional streams are set up between the databases to sync the data. However, the streams are not reliable and seem to break and we have issues with sequence numbers, and streams is to be de-supported (GoldenGate is supposed to be the replacement?)

We are looking at re-architecting this solution but we would like something that either writes to both databases (Advanced replication or GoldenGate?).  We were considering Data Guard (11g) but I am not sure how the application would know to write to the standby if there was a failure on the primary or if we do a switchover.   So if we have 4 servers now (A1, A2, DB Primary, DB Standby) and A1 went down and switches to A2, could I name the SIDs the same so that A2 writes to the either primary DB depending on which server it is on?  I hope my question makes sense, the complexity and options of the HA solutions is confusing.  I'd prefer something that does not require manual intervention on the db side as well.  

We need the application to be up and running always and not lose any data. It is a small fast logging application but if it is down, users can't log into their applications.

Thanks for any feedback on the best solution (Data Guard, Advanced Replication, RAC, GoldenGate, bidirectional streams?)

Who is Participating?
Franck PachotConnect With a Mentor Commented:
DataGuard is the best solution if you can accept an interruption of a few minutes in case of failover.  It is simple and reliable.
RAC is the solution if you cannot accept those 5 minutes, but it does address only the high availability of the instance - not the lost of the database files. But RAC is more complex to manage (and that is sometimes against the availability...)
I don't think that GoldenGate is an high availability solution, as HA must be reliable, and should provide same performance (so data must be identical logically and physically)
schwertnerConnect With a Mentor Commented:
Data Guard is the best solution because it is known, well designed and there are many articles on it.

But the main question is if you have control over the functionality of the application.

If the answer is yes you can write on more then one Oracle instance an to read from one of them that is available.
If this is not the case then you have standard solution like Data Guard.
szadbaAuthor Commented:
I think I may have found the solution to my question.    With Data Guard use the Fast Start Failover and Data Guard Broker to failover automatically.   I can also configure  Transparent Application Failover (TAF) and Fast Application Notification (FAN)  Oracle services so that the  application will know where to go if the primary becomes unavailable and fails over to a new primary.  FAN comes in several flavors – for JDBC thick and thin clients AND for OCI-based clients.  

Looking at RAC, I see that this would work too but I would still need to configure Data Guard and RAC is costly and would require more set-up.

Streams works but is not going to be enhanced any longer due to GoldenGate being acquired.

So if anyone has anything to share using Data Guard with the FSF, FAN/TAF services or thinks there may be a better solution, please let me know.
schwertnerConnect With a Mentor Commented:
RAC is not failover solution. RAC is load balancing solution.
But if you have access to the code of your application you could ask to duplicate the output DMLs (insert, update, delete) into different duplicate DBs.
szadbaAuthor Commented:
splitting points.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.