Re: Configuring Oracle on RAID 5

""Anurag Minocha"" <aminocha_at_herold.com> wrote in message news:EBBA6D3A81229C42981E3AEA79BF5A4E111233_at_jshemail.herold.com... Hi,
I was wondering that since RAID5 creates one logical volume of disk across multiple drives there is no need to have multiple copies of control files and also multiplexing redo logs is not required.

I might be wrong ... I am not sure.

what care needs to be taken in creating and placing datafiles, redo log files and control files on a RAID 5 machine. where can i find more information about Oracle on RAID 5 machines. Thanks
Anurag

As has been repeatedly discussed here, using RAID 5 for redo log files and control files is *NOT* recommended, because of the CRC penalty on writes.  Not multiplexing control files and redo log files is *NOT* to be recommended in *ANY* configuration
because
a) Oracle is not aware of any hardware mirroring b) if the controller managing a mirrored disk fails, you still have nothing at all.
Oracle also needs at least 2 control files, otherwise it simply refuses to start.

Further information on Oracle and RAID 5 can be found on http://www.ipass.net/~dsisk/oont.htm
Also the excellent book by James Morle, Scaling Oracle 8i discusses RAID-5 in depth. My above comments are an abstract of both references.

Regards,

Sybrand Bakker, Oracle DBA

PS PLEASE DON'T POST IN HTML Received on Mon Mar 12 2001 - 15:39:14 CST