Hi! Definitely do NOT put your rollback segment tablespaces to non-raid disks, if you don't want your database to be down in case of media failure. Also, if your system has to be highly available, I wouldn't put anything except maybe multiplexed online logs, archive logs and possibly some backups and such stuff on non-raid. Even temp shouldn't be on non-redundant disk if you don't want to lose your on disk sorting ability in case of media failure..
Tanel. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 21, 2003 4:39 PM > > Assuming that you have 3 physical devices (NON-RAID, RAID-1, and RAID-0+1) > my quick-and-dirty take on this is: > > NON-RAID > redo logs - mirrored by Oracle > control logs - mirrored by Oracle > ORACLE_HOME > RBS01 > RBS02 > TEMP > STAT(For PERFSTAT) > > > > RAID-1 > SYSTEM > RWEBCONFIG(Less Accessed) > RTRADE(Less Accessed) > Archive destination - move to tape > Backups - copy to tape > > RAID-0+1 > USERS01(Heavily Accessd) > INDEX01(Heavily Accessd) > INDEX02(Heavily Accessd) > > I wouldn't worry about putting the indexes on the same device with the > tables. It is a multi-platter device and each datafile will be stripped > across multiple platters. You may want to look into the stripe size > depending on the number of users who will be concurrently accessing the > database. Basic rule-of-thumb, the more concurrent users the larger the > stripe size. > > > > > "bhabani s > pradhan" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > <bhabaniindia cc: > @rediffmail.com> Subject: RAID select > Sent by: > ml-errors > > > 07/20/2003 12:49 > PM > Please respond > to ORACLE-L > > > > > > > Hi > > I have a DB server with RAID-1 > and RAID-0+1 (There is no RAID-0). > Also the NON-RAID diska are available. > > I have the tablespaces as: > SYSTEM > USERS01(Heavily Accessd) > RWEBCONFIG(Less Accessed) > RTRADE(Less Accessed) > INDEX01(Heavily Accessd) > INDEX02(Heavily Accessd) > RBS01 > RBS02 > TEMP > STAT(For PERFSTAT) > > What could be a suitable configuration for > the datafiles under these tablespaces across > the available RAIDs. Also where the backups > and archive_dest should be. > > Can anybody give me some tips on this > > Thanks and Regards > > > ___________________________________________________ > Download the hottest & happening ringtones here! > OR SMS: Top tone to 7333 > Click here now: > http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: bhabani s pradhan > 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: Thomas Day > 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: Tanel Poder 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).