RE: datafiles on NFS?
Date: Wed, 12 Mar 2008 17:13:53 +0100
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.
Oracle Database Administrator
tel +32(0)3 451 23 82
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
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:13:53 CDT