Re: What level of RAID for Oracle WorkGroup Server 7.3?

(you can contact me by E-mail: altena_at_gol.com, do not use the addres  in the header)

hi Carl,

I am running an Oracle-7 database on a "hardware RAID technology" enabled server. Although your database will be significantly larger than ours, here's my reasoning:

The database and OS should be on RAID-5 disks. That's the whole meaning of raid-5: One disk fails... you keep your job ;-) This has the added advantage that the data is striped over the different drives for you.

You will need to back up your data anyway to prevent statements as   

  Delete from Very_Important_Data;

These backups can be done very quickly using disks that need not be Raid-5 protected.

IMHO the above is a "good" solution. The best solution will hopefully be posted by someone else...

Carl Forshee wrote:
>
> Hi,
>
> I have recently purchased a Pentium Pro dual processor server (256MB
> DIMM) with hardware RAID technology running Windows NT Server 4.0.
> We plan on installing Oracle WorkGroup Server 7.3. We have no prior
> experience with Oracle at our site.
>
> We have been getting conflicting information as to how our disks
> should be configured to optimize Oracle.
>
> Option 1 is RAID 5 for the data, index, and RBS tablespaces with
> separate disks (separate channel/controller)(non-mirrored) for
> everything else (i.e. OS, Oracle executibles, redo log files, control
> files, etc. We would include 7 drives under one RAID 5 array for this
> option and 7 drives (non-mirrored) for everything else.
>
> Option 2 would be to simply mirror all of our disks and distribute the
> Oracle tablespaces and files across them. We would be able to mirror
> up to 7 pair of disk under this option
>
> We are a small installation, but do not want to limit ourselves or do
> something that may cause a bottleneck. If anyone can help, I would
> appreciate it.
>
> Thanks.
>
> Carl Forshee (forsheec_at_wv.doe.gov)
Received on Sun Mar 23 1997 - 00:00:00 CST