I unfortunately deleted the message Connor sent this morning pointing to a page on Tom Kyte's site.
While reading through the page I saw something that made me smile -- Tom's comment on disk layouts and how he no longer worries about them as the system people do their magic while he is out having lunch (or words to that effect) and it's done. sounds a lot like how things go around here :) --- "Hitchman, Peter" <[EMAIL PROTECTED]> wrote: > 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). > __________________________________________________ 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).
