RE: Oracle 9.2 setup
- From: "Freeman, Donald" <dofreeman@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 5 Mar 2004 15:25:26 -0500
My fault, I didn't read what I wrote. The recommendation from HP is:
a. RAID 1 (shadowing) for REDO and ARCHIVE LOG datafiles.
b. RAID 0+1 (striping+shadowing) for all other files including control
files and , TEMP, USER and SYSTEM datafiles. All application data should go
here as well.
c. It is strongly recommended that RAID 5 should not be implemented for
Oracle database instances. It has a detrimental impact on overall performance.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Stephen Murphy
Sent: Friday, March 05, 2004 12:46 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: Oracle 9.2 setup
If you put all your redo and control files on a raid 0 and that drive stops,
so does your DB. What does the HP rep suggest you do then?
--
*---------------------------------------------------------------------------
*
Stephen T. Murphy
Manager, Database and Technical Support
ITS - University Applications Development
MSC-100
The University at Albany, S.U.N.Y.
Albany, New York 12222
Phone: (518) 437-4523 Fax: (518) 437-4540
MailTo: SMurphy@xxxxxxxxxxxxxxxxx AIM: SMurphy199
-----Original Message-----
From: Freeman, Donald [mailto:dofreeman@xxxxxxxxxxx]
Sent: Friday, March 05, 2004 12:06 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Oracle 9.2 setup
We are doing pretty much the same thing. However, the HP reps are
recommending 1 volume raid 0 for redo and archive logs and all the data and
control files on the raid 10 volume.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Birkir Bjornsson
Sent: Friday, March 05, 2004 11:10 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Oracle 9.2 setup
Hi
Im setting up Oracle 9.2 on Windows 2003, the machine is a Blade Server
connected to a SAN diskbox with 14x36GB disk.
I was thinking setting this disks up as one Volume with Raid 10 that is
stripe it over the disk and then mirror it. Doesnt that give me
the best I/O performance?
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts: