SAN and Oracle database

[akumar]

Hi
I am setting up a Oracle 9i Server on a SAN.
I have 23 no. of 18.2Gb hard disks.
I have 2 No. of 18.2 Gb internal hard disks on the server.
The OS is NT 4.0.
This is for a DSS system

I decided to do the following:--
My internal drives will be mirrored and have the following:--
Oracle 9i Software
Other Software
Windows NT


How can I make best use of my hard disk resource on the SAN for my
data files,
redolog files,
control files and
archived redolog files ?

Thanks

[Zaggy]

I wish I was at work, becuase I have a Visio file that is perfect for your needs. The file makes it easy to visualize potentail I/O bottlencks, if you know your db I/O performance.

[reydp]

I personally will setup the following:

Have the 20 disks sets in RAID5(4 sets i.e. 4x5 disks) if you can afford to loose redundant 4 disks.
This 4 sets of RAID5 DISK will be your storage for data and index. Always separate index from its corresponding data.
Example:
(we give names to disks:disk1, disk2, disk3, disk4)
(data will have a name data1, and its corresponding index index1)
disk1 = data1, index2
disk2 = data2, index3
disk3 = data3, index4
disk4 = data4, index1

For your 3 disks left:
1 is for redo logs
1 for the archive logs
1 for RBS and Temp

For control file:
This is not an I/O extensive, you can put it anywhere you like, just make sure you have at least 2 copies. And if possible at least 1 is in RAID5 disk.