Re: RAID and Oracle Databases

You're smart in placing Redo and temp on a Raid1. I am confused with the term "2 controllers". Are you telling us that there are two controllers from the server to the RAID box? Or the RAID box has two internal controllers (which means 10 disks have one controller!)? It makes sense for the RAID to have Two controllers from the server, so that if one controller fails, you still Have another redundant controller to access your data. You must take drives on seperate controllers in consideration when setting up your RAID. For example, lets say I have 8 drives with two controllers (4 drives on a controller) c1d1 c1d2 c1d3 c1d4 c2d1 c2d2 c2d3 c2d4 (where c means controller and d means disk) RAID5 would be c1d3,c1d4,c2d3,c2d4 Mount Point u01 1st RAID1 would be c1d1,c2d1 Mount point u02 2nd RAID1 would be c1d2,c2d2 Mount point u03

My temp will rest on u02 My redo logs on u03 my whatever will be on u01 This way, if I lose one internal RAID controller, my mirrored disk will still surrvive. In this example, if I loss an internal RAID controller, my RAID5 will be lost. But I'm sure your situation will be different. Anyway, Good Luck... Satar In article <362CCD69.3BB6D3CA_at_city.lakeland.net>, Vicky Hillsgrove <vhill_at_city.lakeland.net> wrote:

> We are currently getting ready to configure a new HP9000 K460 Server. We
> have
> purchases a 20 disk array w/ two controllers.
>
> We have a few older HP boxes that were configured with RAID5 disk arrays
> and all
> Oracle datafiles, redo logs, etc. have been stored on the disk array.
>
> I am very hesitant about configuring this new box with on line and
> archived redo logs
> and temporary tablespace on RAID 5. I understand that redo logs should
> not be put on
> disk arrays if possible, but that is my only option. Therefore, my
> configuration plan is as
> follows:
>
> 1. Bind 9 disks as a RAID5 Logical Unit and assign to one controller. I
> plan on putting
> my true datafiles and indexes on this unit.
> 2. Bind 10 disks as a RAID 1 (or 1/0) Logical Unit and assign to the
> other controller. I
> am planning on putting on line-redo logs, archived redo-logs and the
> temporary
> tablespace on this unit.
> 3. Have the remaining disk as a hot-swappable.
>
> My question regarding this configuration is: even though I am able to
> keep redo logs off
> RAID 5, am I going to gain an even bigger performance problem with
> controller
> contention? Which is worse, Redo's, etc. on RAID 5 - or - some
> controller contention?
> As far as I have researched, it is my understanding you can only have 1
> logical unit per
> controller - is this correct?
>
> Any advice you can send my way is VERY much appreciated. Please respond
> to all.
>
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own