RE: Configuring disks on a Windows 2000 server?

2002-11-14 Thread Tony Johnson
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?

2002-11-14 Thread Thomas Day

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?

2002-11-14 Thread Yechiel Adar
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?

2002-11-14 Thread Paul Vincent
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).