RE: datafiles on NFS?
Date: Wed, 12 Mar 2008 17:13:53 +0100
Message-ID: <AF9ECF804B2F294BB43BC5063302658F0A5B5248BE@ws03-exch07.iconos.be>
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_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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-lReceived on Wed Mar 12 2008 - 11:13:53 CDT