Re: Oracle and SAN

Thanks guys for all the responses.

In a SAN box, can we configure it with several RAID 1 volumes with specific physical drives ? Or are they just several RAID 1 volumes built logically, i.e. we don't know which physical drives tie to which RAID 1 drive ?

In my existing databases, I use all RAID 1 configuration for all 5 volumes; 3 for Oracle tablespaces, 1 for redo logs and 1 for RMAN backup storage. Should I configure all RAID 1 in the SAN as well ? From marist89's response, it sounds like that RAID 5 is not good for redo logs in SAN even though they have lots of cache.

Please advise. I need the info to tell the SAN administrator how to configure me 5 or 6 Volumes for the database.

Thanks.

JW.

"marist89" <marist89_at_excite.com> wrote in message news:1121952394.712752.305980_at_g14g2000cwa.googlegroups.com...
> >From your perspective a SAN is nothing more than a bunch of disks
> connected to a computer. Just like a traditional direct-attach disk
> array. The only difference is you are connecting to the disk via Fibre
> vs. SCSI. You can configure a SAN just as poorly as you can configure
> a direct-attached disk array.
>
> Usually the difficulty with Oracle on SAN's is the storage
> administrators don't understand what the database host needs. They'll
> share your disk with the email server. When your server is doing very
> little I/O you'll be getting service times in the 40's.
>
> They'll give you 6 physical disks in a RAID 5 filesystem but present it
> as 8 LUNs so you think you have 8 RAID 5 filesystems.
>
> They'll tell you they have hardware RAID and lots of cache so RAID 5 is
> as fast enough for your redo logs.
>
Received on Thu Jul 21 2005 - 23:40:36 CDT