Can I share a LUN between two servers (Linux/Oracle) and open the same file concurrently?
While a LUN can be shared between two or more servers, actually using the LUN with two or more different servers is another story. For example, for failover purposes, it might be desirable to have a LUN shared between an active and a standby server using some type of failover or clustering software.
The real question is: Can the LUN actually be used (read/write) by two or more servers and a common application like Oracle at the same time and maintain data integrity?
The answer to that question is a qualified "yes," if you are using some form of volume and/or file synchronization software such as a clustered volume manger, a clustered file system (CFXS), a network file system using NFS or CIFS or a clustered application like Oracle Real Application Clusters (RAC).
Without using some form of software on the servers or a NAS device, there is no way of coordinating access to changed data blocks and maintaining data integrity. So, if all you want to do is to have shared access to a group of files or tables, your options are to either use NFS or some type of clustered application or clustered file system.
Dig Deeper on SAN technology and arrays
Related Q&A from Greg Schulz
When cloud durability is added to the mix, cloud providers are able to tout a high number of nines of availability. Continue Reading
Cloud storage can be less expensive from a cost-per-gigabyte perspective, but it's important not to lose sight of other benefits as a value ... Continue Reading
Using solid-state in the cloud can boost performance, but first be sure you look past cost per gigabyte and are aware of any constraints from ... Continue Reading