Re: RAID Storage for Oracle

I picked this message in the thread to reply from since it mentions an issue with striping that too many DBA's seem to ignore.

You can't stripe the whole thing and expect to recover to the current point in time if a disk crash occurs. To the last backup yes, but not any further than that. Hot backups? Forget it.

Jeff Hunter <jeffh_at_btitelecom.net> wrote in message news:37a1182f_at_defiant.btitelecom.net...
> Yikes! A serious performance hit? No, RAID 5 is not a serious performance
> hit in some circumstances. There is, however overhead associated with
RAID
> 5 stripes.
>
> Situations where I recommend RAID 5 are:
> 1. Read intensive applications (Datawarehouse, reporting databases, etc.)
> 2. Where hardware cost is a bigger issue than data protection
> 3. Using hardware based RAID.
>
> However, even situations with that are ideal for RAID 5 configurations
still
> need some 0+1 LUNS for rollback segments, redo logs, and archived redo
logs.
> The performance overhead with RAID 5 is experienced usually with
> write-intensive operations. Also, I always try to stay away from software
> based raid systems in production dbs...
>
> Jeff Hunter
> eric_peterson_at_maurices.inrg.com wrote in message
> <7nngjq$7ln$1_at_nnrp1.deja.com>...
> >Does anyone know what level RAID storage Oracle recommends? A fellow
> >DBA just got back from an Oracle 8 course and informed me that we
> >should not be using RAID5 as it stripe's the data and is a serious
> >performance hit. Any information would be helpful.
> >
> >TIA
> >Eric Peterson
> >Programmer/Analyst DBA
> >Maurices Inc.
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Share what you know. Learn what you don't.
>
>
Received on Mon Aug 02 1999 - 00:38:06 CDT