Re: RAID configuration for Oracle8

Putting all redo-log-files/groups on one disk bears a big risk: if the disk fails your database is gone.
With 5x4.3GB disks I assume that you are using RAID-5: Not much room left for configuration options: make three mount points/partitions for your control files, one for your system.dbf and one or two for your data and index files (well, OFA).
Depending on the number of transactions and the amount of data use two or three redo files. (Three or more for heavy workloads: when a log switch occurs, the first log is written to disk (assuming archive log mode), when another log switch occurs, the first one might not be ready again (means not been written to disk completly). Again two or three mount points for these.

I don't see there much use for redo log groups when all redo files placed on the same RAID-Set.

Greetinx
Meinolf
On Fri, 02 Apr 1999 13:22:40 GMT, guruju_at_erols.com wrote:

>In article <7dug65$tjb$1_at_nnrp1.dejanews.com>,
> shan168 <shan168_at_my-dejanews.com> wrote:
>> Hi, everybody,
>>
>> We just got a Compaq server with RAID disks (5 x 4.3GB). How should I
>> configure this server? I.e. how many disks/partitions should be created, and
>> how the redo logs/control file/data files be stored on these huge RAID disks?
>> The concurrent users for the databases will be around 30 with 24x7 schedule.
>> The applications tend to be (100 reads:1 write). Any suggestions will be
>> deeply appreciated!
>>
>> S.H.
>>
>> -----------== Posted via Deja News, The Discussion Network ==----------
>> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>>
>Hi S.H
>
> I am using RAID on HP9000. Its kind of tricky, make sure atleast you have
>one non RAID disk for your redolog files. The remaining is pretty much Oracle
>OFA configuration. Linearly distribute your mount points across the disks.
>There is lot more about RAID implementation. Performance is big issue.
>
> What it RAID level you are going to use, RAID5 or RAID 0/1. If it is (100
>reads and 1 write) RAID5 may be appropriate, again depends on your block
>level striping.
>
>Regards,
>SCG
>Systems Consulting Group, LLC
>Herndon, VA
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Apr 07 1999 - 01:59:33 CDT