Grabowy, Chris, inquired:
Any thoughts? Opinions? Concerns?
Dell Xeon Dual servers using Win2000 for OPS.
Disk layout...
- Channel 0
- A1 = RAID 5 (3 disks, one spare) <<<<< evil. Make this RAID
1, 2 drives.
- OS/pagefile/Oracle software. <<<<< better yet, make it
RAID10.
and put your RBS
here
- Channel 1
- A2 = RAID 5 (4 disks, one spare) << see, both archlogs and
exports are occassional
- Archive logs, exports
- A5 = RAID 0 (1 disk)
- Redo logs A
- Channel 2
- A3 = RAID 5 (4 disks, one spare)
- Data, System tablespace
- A6 = RAID 0 (1 disk)
- Redo logs B
- Channel 3
- A4 = RAID 5 (4 disks, one spare) << and where do you keep
your hot backups?
- Index, rollback, temp, exports << or are you using RMAN?
- A7 = RAID 0 (1 disk)
- Redo logs C
TIA!!!
----------------------------------------------------------------------------
-----------------------
Chris,
Do you have this same DB up currently?
I'd run a script to show I/O by tablespace/datafile.
Pay attention as to what the ration of reads:writes are.
RBS should not go on RAID 5 - too much writes.
I'd also look at redo log generation volume per hour.
if Data and Indexes are pretty much static, RAID 5 not so bad.
WHATEVER else you do - DO NOT SET online redo log volumes to write-back
caching.
I have seen first hand 2 Dell boxes with corrupted databases because of
writefile() errors on online redo logs. Let those sync as WRITE THROUGH.
Where do you keep your on-disk hot and/or cold backups?
You're not *just* using exports for recovery, right?
Without a backup set of datafiles, the archived redo logs might not be so
helpful.
back to my upgrade.
Paul
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Drake
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).