Re: New Disk Setup

From: <billshatner71_at_googlemail.com>
Date: Thu, 28 May 2009 06:19:43 -0700 (PDT)
Message-ID: <5fb2ea87-aa5e-41ac-8ae2-924d005cd81f_at_e20g2000vbc.googlegroups.com>



On May 28, 12:55 pm, johnbhur..._at_sbcglobal.net wrote:
> On May 28, 5:34 am, billshatne..._at_googlemail.com wrote:
>
>
>
>
>
> > I've got to shift our OLTP production database onto a new server which
> > has 8 disks.
>
> > The layout I've got at the moment is the following.
>
> > Please feel free to flame me if you like but I was wondering if I'm
> > being overly cautious with mirroring and should use striping/
> > mirroring.
>
> > Any suggestions for modifications gratefully received.
>
> > 1 + 2 RAID-1
> > OS
>
> > 3 + 4 RAID-1
> > Datafiles
> > Control file
>
> > 5 + 6 RAID-1
> > Archived Redo Logs
> > Control file
>
> > 7 + 8 RAID-1
> > Oracle Software
> > Control file
> > Backups
>
> Well if you have a system with modest IO requirements almost anything
> will work.
>
> You don't give any details about what kind of server or disks or
> operating system or oracle version or if you are going to use ASM
> etc.  No information on what "kind" of backups either.  Does your os
> support asynchronous writes?  Are you planning on using RAW or using a
> cooked file system?
>
> With 8 disks available you are not going to get to get a lot of
> choices or performance.
>
> How about RAID 1 for disks 1/2 and put the OS + oracle software over
> there.
>
> Disks 7/8 for archive logs and backups in RAID 1.  You really don't
> want rman disk based backups writing to the same disks that the
> operating system is on ... that's guaranteed to cripple performance.
>
> That give you a whole 4 disks to work from eh?
>
> For many OLTP systems especially if they are commit happy the IO
> performance of the oracle online logs ( which you appear to have left
> out of your original description ) is critical.  How are you planning
> on meeting those requirements?- Hide quoted text -
>
> - Show quoted text -

Thanks for that. We're on Red Hat AS 4.7. My unix colleague is looking to use logical volumes.
Disks are 2x36Gb, 6x146Gb.

Couldn't tell you about the server itself or more about the disks, unfortunately. Oracle version is 10.2.0.4. We're not using ASM.

Backups will be hot backup and RMAN if we have the space.

Sorry, the online redo logs will be on a disk separate to the archived redo logs. Currently they're 25Mb each.

The 4 disk solution sounds a lot better. Received on Thu May 28 2009 - 08:19:43 CDT

Original text of this message