RE: File/RAID layout for Oracle database???

Hey Paul,

Thanks for taking the time to provide feedback.

This is a proposed system. I'm just "supposed" to install Oracle and get OPS up and running, then the other contractor is going to load there app and data. I can't help but worry about the disk layout, backups(including the types), future monitoring, etc. In an OPS configuration there is a lot more to "worry about", but they want to use it in a fail-over configuration(shaking my head), not a "parallel" configuration.

Thanks for all the warnings!!

Chris
"May Oracle be with you...always"

-----Original Message-----
Sent: Friday, September 21, 2001 6:02 PM To: Multiple recipients of list ORACLE-L

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: drake_at_psscorp.com

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: 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.com
-- 
Author: Grabowy, Chris
  INET: cgrabowy_at_fcg.com

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