RE: datafiles on NFS?

From: Lange, Kevin <>
Date: Wed, 12 Mar 2008 12:19:21 -0400
Message-ID: <>

The value each value for this says


Is that the correct setting to be using ?

-----Original Message-----
From: D'Hooge Freek [] Sent: Wednesday, March 12, 2008 11:14 AM To: Lange, Kevin; ORACLE-L
Subject: RE: datafiles on NFS?


Did you enable the "volume space guarantee" on the used netapp volumes? If so the situation you had should have not been different from a full filesystem. If it was disabled, oracle (or more correct the os) would have thought there is enough space on the volume to complete the write, generating a whole different type of failure. I always recommend to enable the "volume space guarantee" to avoid these kind of issues.


Freek D'Hooge
Oracle Database Administrator
tel +32(0)3 451 23 82

[] On Behalf Of Lange, Kevin Sent: woensdag 12 maart 2008 16:54
Subject: 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.

Received on Wed Mar 12 2008 - 11:19:21 CDT

Original text of this message