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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: