Difference between NAS,NFS, and SAN storage for Oracle Database.
Network Attached Storage space is file level computer data storage space which is connected to a computer network of number of computers providing information access to different network computers. NAS is a convenient method of sharing Oracle files among multiple computers. It has many advantages over single Oracle file servers like faster data access, easier administration and simplicity in its configuration. It not only operates as a file server at a central location but also provides connectivity from different data centers. An Oracle database using network attached storage can be connected to local area network using a Ethernet hard drives (SATA, SAS, USB, Fiber channel).
Oracle database using network attached storage allows more than one hard drive, often arranged into logical, redundant storage containers or RAID arrays. Thus it minimizes the task of file serving to the database from other servers over the network. It is highly proffered as an ERP database solution as it can be configured over the network, even using a browser. An Oracle database mounted on network attached storage provides a centralized storage to client computers in environments with large amounts of data. Oracle database over network attached storage can lower cost by load balancing.
Network File System (NFS) is a network file system protocol, which allows a client computer to access files in a manner similar to local storage. The recent network file system (NFS) protocols enables data access parallelism, thus allowing an Oracle database to hold the names of files and their data under the single server. The network file system protocol can be implemented on many operating systems, making the Oracle database highly available at many platforms. NFS is often used with Unix operating systems, classic Mac OS, OpenVMS, Microsoft Windows, Novell NetWare, and IBM AS/400.
An Oracle database using storage area network (SAN) is a network that is dedicated to the database and is accessible to a block level storage. A storage area network are used to make data storage devices accessible to servers, so that the storage unit appears like locally attached devices to the operating system. A database using storage area network has a network of storage devices that are not accessible through the local area network by other devices. The database using storage area network is not proffered for a business implementing an ERP. An oracle database using a storage area network would easily get corrupted because multiple systems were simply to attempt to share virtual hard drives. But of course a database, in which a transaction needs a high speed block level access should use storage area network.
NAS provides both storage and a file system, but SAN supplies only block-based storage space and abscond file system apprehensions on the local manner. Theoretically, NAS emerges to the client operating system as a file server i.e. the client be able to attach network drives to splits on that server side, whereas a local disk obtainable through a SAN still become visible to the client operating system as a disk, visible in disk and volume management utilities (along with client’s local disks), and available to be formatted with a file system and mounted.
This is basics of File systems and every Oracle DBA should need to keep in mind or aware of this knowledge. Without having this kind of knowledge, you never be an expert in database administration. Because when you are going to perform disk I/O tuning for decreasing read/write then you should be aware of this knowledge. You may be find out some more Oracle DBA Tutorials from our blog. This blog runs by Dbametrix.