Ask the Expert

RAC or Data Guard for 2TB application with 30 users

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.

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: