Go Premium for a chance to win a PS4. Enter to Win


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
  • 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

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

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

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

772 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