RE: Configuring disks on a Windows 2000 server?
I think I would be looking for a new vendor. We run applications that run quite well in a Raid5 environment under W2K Server and/or Advanced Server and have run with other configurations also. Oracle doesnt know or care what is underneath as long as the O/S recognizes it and it can read and write to it. -Original Message- Sent: Thursday, November 14, 2002 3:03 AM To: Multiple recipients of list ORACLE-L Hi all, A 3rd-party software vendor is coming in to install their application on a new Windows 2000 server. This application uses Oracle, so they'll also be installing Oracle 8.1.7 as part of their setup session. However, they've sent our server/hardware guys the following, specifying how they want the disks configuring on the server: - - - - - "As to the RAID recommendations the issue is that Oracle do not support installations where the redo logs are on any sort of a stripped partition. My recommendation would be to create a mirror pair out of two of the disks. This can be partitioned for the system and the redo logs. The remainder of the disks can be RAID 5. Note that the RAID 5 array is where the actual database and archive logs are stored. In theory If you lose both disks on the mirror you would still have enough information on the RAID 5 partition to save the database." - - - - - Now, disk configuration's one of my weakest spots, but I have the following two questions about their instructions: 1. Is their point about Oracle not supporting redo logs on striped partitions true, or are they talking rubbish? All our UNIX servers with Oracle use RAID 0+1 (mirroring plus striping) on all their disks, but is it different for Windows servers? I must say I'd never heard of this restriction before, but I'm willing to be enlightened! Anybody? 2. They're recommending RAID 5 for a transaction-heavy application server, here. Surely that's wrong? I thought I understood that RAID 5 was great for file servers but lousy for servers running transactio-heavy business applications. What's the view of you guys on this? Please give me your views, I know we have some very experienced people on this list! Best regards, Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vincent 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.com -- Author: Tony Johnson 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).
Re: Configuring disks on a Windows 2000 server?
Oracle's recommendation (for what it's worth) is SAME (Stripe All, Mirror Everything). They're blowing smoke about the redo logs. I've never heard anyone, anywhere say that (of course, I'm willing to learn from my errors). RAID 5 is usually recommended against but our recent discussion here (if I followed it correctly) indicated that the write penalty for RAID 5 may go the way of the single extent myth. RAID 5 is cheaper, in terms of number of disks. Paul Vincent @uce.ac.uk> cc: Sent by: root Subject: Configuring disks on a Windows 2000 server? 11/14/2002 05:03 AM Please respond to ORACLE-L Hi all, A 3rd-party software vendor is coming in to install their application on a new Windows 2000 server. This application uses Oracle, so they'll also be installing Oracle 8.1.7 as part of their setup session. However, they've sent our server/hardware guys the following, specifying how they want the disks configuring on the server: - - - - - "As to the RAID recommendations the issue is that Oracle do not support installations where the redo logs are on any sort of a stripped partition. My recommendation would be to create a mirror pair out of two of the disks. This can be partitioned for the system and the redo logs. The remainder of the disks can be RAID 5. Note that the RAID 5 array is where the actual database and archive logs are stored. In theory If you lose both disks on the mirror you would still have enough information on the RAID 5 partition to save the database." - - - - - Now, disk configuration's one of my weakest spots, but I have the following two questions about their instructions: 1. Is their point about Oracle not supporting redo logs on striped partitions true, or are they talking rubbish? All our UNIX servers with Oracle use RAID 0+1 (mirroring plus striping) on all their disks, but is it different for Windows servers? I must say I'd never heard of this restriction before, but I'm willing to be enlightened! Anybody? 2. They're recommending RAID 5 for a transaction-heavy application server, here. Surely that's wrong? I thought I understood that RAID 5 was great for file servers but lousy for servers running transactio-heavy business applications. What's the view of you guys on this? Please give me your views, I know we have some very experienced people on this list! Best regards, Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vincent 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.com -- 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 c
Re: Configuring disks on a Windows 2000 server?
Hello Paul ALL our oracle servers are windows NT/2000 with raid 5 arrays for all the files. 1) The point that Oracle does not support online redo logs on stripped partition seems wrong to me. 2) There was a discussion on the list a while ago about the write speed times between raid 5 and raid 0+1. Anyway, since raid 5 are usually implemented with a big controller cache (backed up by a battery) your database writes to the cache and you get reasonable response time. We have a heavy online application with about 50 users that runs OK on windows NT with 2 processor and 5 disks raid 5 array. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, November 14, 2002 12:03 PM > Hi all, > > A 3rd-party software vendor is coming in to install their application on a > new Windows 2000 server. This application uses Oracle, so they'll also be > installing Oracle 8.1.7 as part of their setup session. However, they've > sent our server/hardware guys the following, specifying how they want the > disks configuring on the server: > > - - - - - > "As to the RAID recommendations the issue is that Oracle do not support > installations where the redo logs are on any sort of a stripped partition. > My recommendation would be to create a mirror pair out of two of the disks. > This can be partitioned for the system and the redo logs. The remainder of > the disks can be RAID 5. Note that the RAID 5 array is where the actual > database and archive logs are stored. In theory If you lose both disks on > the mirror you would still have enough information on the RAID 5 partition > to save the database." > - - - - - > > Now, disk configuration's one of my weakest spots, but I have the following > two questions about their instructions: > > 1. Is their point about Oracle not supporting redo logs on striped > partitions true, or are they talking rubbish? All our UNIX servers with > Oracle use RAID 0+1 (mirroring plus striping) on all their disks, but is it > different for Windows servers? I must say I'd never heard of this > restriction before, but I'm willing to be enlightened! Anybody? > > 2. They're recommending RAID 5 for a transaction-heavy application server, > here. Surely that's wrong? I thought I understood that RAID 5 was great for > file servers but lousy for servers running transactio-heavy business > applications. What's the view of you guys on this? > > Please give me your views, I know we have some very experienced people on > this list! > > Best regards, > > Paul > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Paul Vincent > 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.com -- Author: Yechiel Adar 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).
Configuring disks on a Windows 2000 server?
Hi all, A 3rd-party software vendor is coming in to install their application on a new Windows 2000 server. This application uses Oracle, so they'll also be installing Oracle 8.1.7 as part of their setup session. However, they've sent our server/hardware guys the following, specifying how they want the disks configuring on the server: - - - - - "As to the RAID recommendations the issue is that Oracle do not support installations where the redo logs are on any sort of a stripped partition. My recommendation would be to create a mirror pair out of two of the disks. This can be partitioned for the system and the redo logs. The remainder of the disks can be RAID 5. Note that the RAID 5 array is where the actual database and archive logs are stored. In theory If you lose both disks on the mirror you would still have enough information on the RAID 5 partition to save the database." - - - - - Now, disk configuration's one of my weakest spots, but I have the following two questions about their instructions: 1. Is their point about Oracle not supporting redo logs on striped partitions true, or are they talking rubbish? All our UNIX servers with Oracle use RAID 0+1 (mirroring plus striping) on all their disks, but is it different for Windows servers? I must say I'd never heard of this restriction before, but I'm willing to be enlightened! Anybody? 2. They're recommending RAID 5 for a transaction-heavy application server, here. Surely that's wrong? I thought I understood that RAID 5 was great for file servers but lousy for servers running transactio-heavy business applications. What's the view of you guys on this? Please give me your views, I know we have some very experienced people on this list! Best regards, Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vincent 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).