Hi, Dwayne I agree with Rachel's comments. In the past I have laid out databases on RAID1+0, and there are some documents available indicating that this is the disk layout of choice for databases. Now I am faced with SAN and no say in how the disks are configured. So I have just created the normal set of directories, so that I don't have all the files lumped together from a file system perspective. Of course I would really like some separate disks for online redo logs and the archive logs, but I am not going to get them!
Regards Pete -----Original Message----- Sent: 27 March 2003 13:39 To: Multiple recipients of list ORACLE-L 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 <[EMAIL PROTECTED]> 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: [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). > __________________________________________________ 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). ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ********************************************************************** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hitchman, Peter 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).
