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: [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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Grabowy, Chris
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).
