Rachel I don't think you and I disagree at all. I'm learning that being a good DBA is as much about people skills as technical skills. I think the important point is that you did clearly point out to them the issues involved with a single RAID set. It doesn't hurt to write it down because people tend to recall verbal conversations differently (if at all). We run some smaller production databases on a single RAID set, but so far I've been able to at least keep a couple of things on a separate device. Recovery could be really bad if you lost all copies of your control files along with your single RAID device. But then, if all your archive logs were on that device, I suppose you wouldn't be doing a recovery to the point of failure anyway ;-) Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED]
-----Original Message----- Sent: Thursday, March 27, 2003 8:54 AM To: Multiple recipients of list ORACLE-L Dennis, Sometimes you don't have the option to decide if you are using a single RAID set or not. At my last job I was told "hey, we have 375GB of space for you -- and it's RAID-5". I was not asked if I wanted it configured that way, I was not listened to when I protested. So the alternatives I faced were a) run my database on RAID-5 and do the best I can or b) quit because I refused to run a database on RAID-5 Option b seemed a little extreme. You really can't make pronouncements like "you shouldn't run a production database on a single RAID set" because sometimes you have to. Oh yeah -- the database ran fine, we had no performance problems and we DID have good backups. Rachel --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Dwayne > So you have a single RAID set, or 5 separate devices? You might > have a > test database on a single RAID set, but you shouldn't do that in > production. > First, multiple control files on separate devices. Redo should write > to a > non-RAID device since it continuously writes. Past that it depends on > how > much performance this system requires. > Gaja and Kirti explain this nicely in Oracle Performance Tuning > 101. > > Dennis Williams > DBA, 40%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -----Original Message----- > Sent: Thursday, March 27, 2003 6:59 AM > To: Multiple recipients of list ORACLE-L > > > Hi all, > > I am configuring a system for use with Oracle and am confused on the > concepts > of RAID and OFA, specifically how they work together. > > I inherited a system that is a RAID 5 utilizing 5 disks. Oracle8i > (8.1.7) > is > currently running on it. The database is setup on one disk (data > files, > control files, redo logs, etc.). > > I understand that striping spreads the info out across all the disks. > That > being true, is it necessary to put the redo logs, rollback segments, > etc on > sepaparte disks ala OFA? > > Since the database is not in production yet, I have time to make > these > changes > (not to mention we are planning to redo the setup with Red Hat > Advanced > Server and upgrade to Oracle9i). > > Thanks in advance for your help. Feel free to point me to additional > reading > materials that will clarify this for me. > > Dwayne > > -- > Dwayne Cox > Corporate Database Administrator > Info Tech, Inc. > 5700 SW 34th Street, Suite 1235 > Gainesville, FL 32608 > > email: [EMAIL PROTECTED] > phone: 352.381.4521 fax: 352.381.4444 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Dwayne Cox > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > __________________________________________________ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
