Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Comparing Oracle High Availability Solutions

Posted on 2011-09-29
Medium Priority
Last Modified: 2012-05-12

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?)

Question by:szadba
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 48

Assisted Solution

schwertner earned 750 total points
ID: 36816331
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.

Author Comment

ID: 36817193
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.
LVL 15

Accepted Solution

Franck Pachot earned 750 total points
ID: 36817917
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)
LVL 48

Assisted Solution

schwertner earned 750 total points
ID: 36895960
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.

Author Closing Comment

ID: 36918776
splitting points.

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question