Q

RAC or Data Guard for 2TB application with 30 users

We have a 2TB application with approximately 30 users. Do I need 10g RAC or Data Guard for HA for this application?

We recently bought a Sun E6900 12 CPU 28 TB server. One of the applications is going to be around 2 TB with approximately 30 users. This is mainly a batch PL/SQL OLTP application. My question is, do I need 10g RAC or Data Guard for HA for this 2 TB application with 30 users? Also, can I use OCFS for RAC on SUN instead of SUN clustered software? I appreciate your response.

Your database size and number of users should have very little bearing on whether or not you need RAC or Data Guard for high availability. The driver for any HA solution should always be the cost to your company for being down for a defined period of time. Any HA solution will always cost more than a non-HA solution. Since your company is paying for the HA solution, it only makes sense to the company if the HA solution stops them from...

losing money. For instance, if your database were down for one hour and that translated into $100,000 of lost revenue, then an HA solution would make sense because the HA solution might cost something like $20K or $40K to implement. However, if an hour of downtime only costs your company $1,000, then an HA solution may be more than its worth. It is up to those paying the company's bills or authorizing the expenditure of funds to make this decision. The DBA should lay out the options and pros and cons of each.

OCFS will not work on Solaris. OCFS is only for Linux and Windows. If you run RAC on Solaris, then you can either use Oracle's ASM or a clustered file system from Sun.

This was first published in March 2007

Dig deeper on Oracle database availability

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close