Re: RAID select

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 ----- From: "Thomas Day" <tday6_at_csc.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, July 21, 2003 4:39 PM Subject: Re: RAID select

>
> 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 <ORACLE-L_at_fatcity.com>
> <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: bhabaniindia_at_rediffmail.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: Thomas Day
> INET: tday6_at_csc.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
Received on Tue Jul 22 2003 - 06:53:03 CDT