With a single RAID-5 device, you can't place the database files on
separate physical disks.
Having said that, just as a means of documenting the database, I would
still generate an OFA-compliant set of directories and place the
various database objects in the separate directories. You won't get any
benefit of separating files (which may or may not be beneficial in any
case) but you will be able to easily distinguish which files are which
type and the database they belong to.
I presume that you, like me, have no say in how your disk system is
configured?
Rachel
- Dwayne Cox <dwaynec_at_infotechfl.com> wrote:
> 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).
>
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).
Received on Thu Mar 27 2003 - 07:38:36 CST
