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 a 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 a 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 centralized storage to client computers in environments with large amounts of data. Oracle database over network attached storage can lower costs 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 a 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 is 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 a storage area network has a network of storage devices that are not accessible through the local area network by other devices. The database using a 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 high-speed block-level access, should use a storage area network.
NAS provides both storage and a file system, but SAN supplies only block-based storage space and abscond file system apprehensions in a 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 the disk and volume management utilities (along with client’s local disks), and available to be formatted with a file system and mounted.
This is the basics of File systems and every Oracle DBA should need to keep in mind or be 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 on our blog. This blog runs by Dbametrix.
When you want to make a strong Oracle DBA career then you should be aware of database services and other database technology. Without having knowledge of Oracle internals, Oracle performance tuning, and skill of Oracle database troubleshooting you can’t be an Oracle DBA expert.
This expert DBA Team club blog always provides you latest technology news and database news to keep yourself up to date. You should need to be aware of Cloud database technology like DBaaS. All Oracle DBA tips are available in a single unique resource at our orageek. Meanwhile, we are also providing some sql tutorials for Oracle DBA. This is the part of Dbametrix Group and you would enjoy more advanced topics from our partner resource.