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).
