Re: HELP: RAID-5 Killing Performance

It is important to Mirror the Archived Redo Log files ( it is a Show Stopper ) and preferably put them on a dedicated Filesystem ..and Keep atleast two days worth files on the host itself for any Emergency Recovery( I somehow dont want to believe in Tapes at crucial times ) ..

As far as Online redo Log files, it is not mandatory to Mirror them at the Hardware level if you are doing it at the Oracle Level..

-Thiru

In2Home User wrote:

> We're running Oracle 8.0.5 on Solaris 2.6.
> Our database server is a Sun UltraSparc I 333MHz with 1GB of RAM.
> We have several disks, a RAID-5 array, and a local tape device.
>
> My DBA is utilizing the disks in the following manner:
>
> disk1 - os
> disk2 - home
> disk3 (mirrored) - archived redo logs
> disk4 (RAID-5) - control file, system, temp, oracle software
> disk5 (RAID-5) - control file, rbs, redo logs
> disk6 (RAID-5) - control file, tools, users, redo logs
>
> My largest concern is that having the redo logs on RAID-5 has
> got to be killing my performance. Ideally, they should be on a
> dedicated set of mirrored drives (then again, ideally I should have
> 22 separate disks, yeah). However, my DBA feels that its more
> important to have the archive logs on the dedicated mirrored disks.
>
> Anyone care to share their opinion as to how we might make better
> use of the above hardware setup? Would it make sense to write archive
> logs directly to tape and move the redo logs to the mirrored disks?
>
> Thanks in advance,
>
> Chris
Received on Tue Sep 14 1999 - 14:04:16 CDT