Re: RAID select

From: Thomas Day <tday6_at_csc.com>
Date: Mon, 21 Jul 2003 08:40:24 -0400
Message-Id: <25977.338667@fatcity.com>

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

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 Received on Mon Jul 21 2003 - 07:40:24 CDT