RE: datafiles on NFS?

The value each value for this says 

guarantee=volume

Is that the correct setting to be using ? 

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

Kevin,

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.


Regards,


Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer


________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Lange, Kevin
Sent: woensdag 12 maart 2008 16:54
To: ORACLE-L
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.

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

Other related posts: