Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Question about OFA and RAID 5

Question about OFA and RAID 5

From: Tom Schruefer <tschruefer_at_mail.howard.k12.md.us>
Date: Tue, 10 Jul 2001 10:13:22 -0700
Message-ID: <F001.00345E3C.20010710093541@fatcity.com>

Any suggestions on the message below would be greatly appreciated. Thanks in advance.

I have been appointed our new Oracle DBA and have since been taking classes and reading books. I quite enjoyed the recent thread on OFA. I seem to have a bit of a quandary, here it is.

We have 68 schools with 46,000 students, each with their own student database, we have purchased a product that will allow us to aggregate all of these databases into one central database. This project is but one step toward a centralized student data system, which we currently do not have the infrastructure for.

Here is the suggested configuration for the database server for this product.

2 9GB HD in a RAID 1 - Suggested for the OS and LOGS 6 18GB HD in RAID 5 - Database
1 18GB HD Hot Spare

I realize that something of this nature would allow for a lot of disk through-put (I would think), but it doesn't really allow for a OFA configuration.

I should clarify at this time that there were two choices for the DB either Oracle or SQL Server, we chose Oracle. I have a suspicion that this configuration is either intended to maximize database access, at the expense of recoverability or its the SQL Server version of OFA, or both. If it is both is there a way to provide for OFA and also maximize disk access?

BTW, I actually purchased a system with much more disk space than the above, 14 18gb HD and 2 9gb HD.



Howard County Public School System, Maryland, USA tschruefer_at_mail.howard.k12.md.us

The views expressed in this message do not represent the views of the Howard County Public School System, blaa, blaa, blaa. You get the idea.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Tom Schruefer
  INET: tschruefer_at_mail.howard.k12.md.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jul 10 2001 - 12:13:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US