How to store Oracle DBF files in STorage Using SAN?

Posted on 2009-02-09
Last Modified: 2013-12-18
Here is the scenario
Oracle server contains only Server Binaries only, and the Database files i.e dbf,ctl etc.. to be stored in storage using SAN
how the above scenario work, what is the procedure, how to go about it?

Question by:umesh4exp
    LVL 13

    Accepted Solution

    Should be a simple case of attaching the Oracle server to the SAN (you dont say what hardware is involved so cant be much more specific)

    Present a LUN on the SAN to the Oracle server (via your SAN management tools, again depends on what you have)

    Point the Oracle install at that LUN and tell Oracle to store its databases there

    You will, of course, need to ensure you have a good backup regime as simply putting files on a SAN doesnt guarantee their data!

    LVL 7

    Expert Comment

    it is advisable to put Oracle binaries on local disks of your server and put the data files on SAN disks.

    Author Closing Comment

    logical unit number or LUN

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    How to update Firmware and Bios in Dell Equalogic PS6000 Arrays and Hard Disks firmware update.
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now