Same here, the SAN (Hitachi) is configured raid 5 (with 128K strippes i
think) and it's good for everything : Oracle, Sql Server, Novell, Windows,
AIX and maybe the mainframes if they live long enough.
So I would not be wellcomed if I asked how about putting those redo logs on
raid 0+1 ?
Stephane
-----Original Message-----
Carmichael
Sent: Thursday, March 27, 2003 9: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 <DWILLIAMS_at_LIFETOUCH.COM> 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.
> dwilliams_at_lifetouch.com
>
> -----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: dwaynec_at_infotechfl.com
> phone: 352.381.4521 fax: 352.381.4444
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Dwayne Cox
> INET: dwaynec_at_infotechfl.com
>
> 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: ListGuru_at_fatcity.com (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: DWILLIAMS_at_LIFETOUCH.COM
>
> 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: ListGuru_at_fatcity.com (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: wisernet100_at_yahoo.com
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: ListGuru_at_fatcity.com (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: Stephane Paquette
INET: stephane.paquette_at_standardlife.ca
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: ListGuru_at_fatcity.com (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).
Received on Thu Mar 27 2003 - 10:53:39 CST