[OpenAFS] Oracle Databases...

Scotty Logan swl@stanford.edu
Tue, 22 Mar 2005 12:50:11 -0800


On Mar 22, 2005, at 9:24 AM, Dexter 'Kim' Kimball wrote:
>> The backend storage for an Oracle database is highly specialized,
>> performance-critical, and cannot be shared among multiple
>> servers.  Thus, it is not a good candidate for storage in _any_ 
>> remote or distributed
>> filesystem, including AFS.
>
> Now that's a definitive response.

But wrong: clustered Oracle 9i and 10g (aka RAC) *require* filesystems 
shared between multiple servers.  The solutions support by Oracle are 
SAN based clustered filesystems (like. Veritas Cluster Filesystem on 
Solaris, or Oracle's own OCFS on Linux) or clustered NFS servers 
(NetApp or EMC Celerra filers).  The backend storage for Oracle 
databases is not highly specialized - general purpose SAN or NAS 
devices are all that is needed (although high performance databases 
need high-end devices and tightly controlled and optimized volume 
layouts).

   Scotty

-- 
Scotty Logan <swl@stanford.edu>
Information Technology Systems and Services, Stanford University