DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: SAN or NAS for Oracle?

  1. #1
    Join Date
    Jan 2001
    Posts
    216

    SAN or NAS for Oracle?

    What is preferred for Oracle databases?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    if one was better than the other, then the other wouldnt exist.

    They are both good, depends what your nheeds are - do you understand the differences?

  3. #3
    Join Date
    Jan 2001
    Posts
    216
    Thanks for the quick reply. To be honest, I dont know what the differences are. I would guess, at the very basic, my main interest would be how easy it is to take snapshots of prod db and restore it to test (on the same box or diff server). Can you tell me a good point to start looking at this? There is too much info on the web..

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    It's relatively easy, but SAN and NAS don't come into play either way. True, SAN and NAS have technology that let you break mirrors and get a snapshot of your data, but so do a lot of other storage devices.
    Jeff Hunter

  5. #5
    Join Date
    Nov 2001
    Posts
    335
    SAN storage attached to the server via switch and HBA .
    NAS storage is mounted on the server via another server , almost like NFS.
    Obviously for the system with the high perfromance requirements and expectation SAN is a must. Otherwise NAS will do.
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    and what evidence do you have that NAS is bad for performance?

  7. #7
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    your enterprise storage admin is the weakest link - trust no one Mulder . SANE SAN is must read
    I'm stmontgo and I approve of this message

  8. #8
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    To the OP, just checking you realise this: Oracle only support certain NAS devices: http://www.oracle.com/technology/dep...ndors_nfs.html

  9. #9
    Join Date
    Nov 2001
    Posts
    335
    I could do fancy testging to prove it, but here is the very simple one:

    Try to create a large datafile (above 4Gb) on both systems keeping everything else the same and you will see the difference. It is not unusual to have 10-15Mb per seconde transfer rate on NAS and much high on SAN. If you can live with the slower IO go for NAS, it is cheaper. Otherwise stick with the SAN
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  10. #10
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    creating a tablespace isnt a very good indicator of whether NAS or SAN is good enough for your app. It proves nothing

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