RE: datafiles on NFS?

We run exclusively on Netapps here on NFS mounts for our 9i and 10g DBs.  

Normally, the system is great.  

Unfortunately , there is always something to mess "Great" up.  

Moved to individual volumes for each database versus one giant pool of space. This lead to an issue where we missed the growth of the snapshots on one database that ended up eating all the available space in that particular volume. When this happened, datafiles were corrupted.  

Moral of the story is ... Netapps are great as long as you are proactive in your monitoring of space usage. We now have jobs that look for any netapp going above x percentage full on both the snapshots and the data areas.  

I would still recommend this setup for ease of maintenance.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: Wednesday, March 12, 2008 10:43 AM To: mwf_at_rsiz.com
Cc: ORACLE-L
Subject: Re: datafiles on NFS?

On Wed, Mar 12, 2008 at 8:19 AM, Mark W. Farnham <mwf_at_rsiz.com> wrote:

        I suppose system/NFS combination that failed those tests could still be used

        if the DBA staff/sysadmin staff team could be definitively schooled to not

        allow autoextend for those mounts.                  

Getting NetApp here soon. I will add this to my testing.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist


--
http://www.freelists.org/webpage/oracle-l