Hardware Architecture Question

[Denda]

I'm looking for any advice on how to set the following up. Literature, books or on hand experience... We have 2 rp2470 (HPUX 11)each with 2-18G hard drives. Attached to the 2 rp2470's are an additional 12- 73G drives. I want to set up the following:

1. Oracle 9i Enterprise Server

2. 3 - Prod DB's (different apps @ 10G.

3. 3 - Failover DB's for Prod DB's

4. 3 - QA DB's for Prod DB's

5. Aprox 400G as data storage for an additional application.

The last time I did something like this was on a SUN box 2 1/2 years ago & I'm a little fuzzy... )
Can I setup RAID 5 & still have what I want or does it have to be mirrored. (The 400G data storage does not have to be mirrored)

Thank you in advance.

 

[bi]

You can set up on RAID5, but Oracle doesn't recommend it for things like your rollback segments, redo logs and control files. You will get hammered in performance because of the parity that has to be read and rewritten whenever there is a change in a file.

I have administered a system using RAID5 for the index files and even the data files, but the DBA was constantly complaining about performance. I don't know if that had to do with RAID5 or if the database was poorly designed and tuned.