RAID and ORACLE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: RAID and ORACLE

  1. #1
    Join Date
    Oct 2003
    Posts
    65

    RAID and ORACLE

    Hello Guys,

    Currently are running oracle on RAID 5.
    We are planning to move to new server PE 6050 dell servers with SAN storage.The system engineers were asking abt what RAID to be configured for ORACLE.

    Can someone suggest me pls.
    Even though i dont see much probs with RAID 5.I have heard RAID 10 is good for oracle and one more thing all the data,index,rbs,log,control files will be on the same disk.

    thanx in advance.

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    You don't say how many disks.

    In very general terms:
    - RAID-1 Good.
    - Put log files on devices with minimum (preferably zero) other activity.

    I'm not 100% sure about hardware striping - once you've set it up, you're pretty much stuck with it. If your tablespaces are composed of many files, on different devices, Oracle uses them in a round-robin fashion giving you a kind of poor-man's striping. This gives you the option to change your mind about it

  3. #3
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Here's a nice high level overview
    http://www.acnc.com/04_01_10.html
    I'm stmontgo and I approve of this message

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    If you can do it, multiple 0+1 filesystems are best. If budget is a concern, I'd have two 0+1 filesystems for redo and undo and put the rest on raid 5.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Hi.

    Here's something I wrote on the subject a while ago:

    http://www.oracle-base.com/articles/Misc/RAID.php

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width