Re: RAID Storage for Oracle

And why would you not be able to do a forward recovery to point in time? Could you explain?

--
Ed Stevens

In article <29ap3.1385$0r.14838_at_news.goodnet.com>,   "Pat Minnis" <pminnis_at_maverick.net> wrote:
> 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.
> >
> >
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Aug 02 1999 - 07:27:15 CDT