NAS or SAN for Oracle Fail Safe

A client is implementing Oracle Fail Safe. They want to know it if it should be implemented with network-attached storage (NAS) devices or a storage area network (SAN). Do you have any recommendations?

    Requires Free Membership to View

In either case, you want to make sure that you have a good relationship with your disk vendor so that you can sort out any potential disk issues.

Network-attached storage (NAS) devices have suffered from some serious flaws as far as Oracle is concerned. The Oracle database needs to be in near-constant contact with the database datafiles. Network glitches could cause the database to lose contact with those datafiles and cause the database to crash. Many DBAs find this unacceptable and won't even consider use NAS devices for their Oracle Databases. However, one of the more popular NAS vendors, NetApp now has some devices that work well with Oracle. Just make sure that your disk vendor will support Oracle on your NAS disk devices, otherwise, don't even bother with them.

Storage area networks (SAN) are much better and don't have the same problems. While technically on a "network," these devices should be placed on a dedicated switch for your SAN.

This was first published in April 2004

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.