RE: df shows 100% on a empty filesystem-
Date: Wed, 16 Jan 2008 18:05:18 -0700
We have seen this in our large environments where several hundred gb gets tied up. Removing the files will not work since you are only manipulating the directory entries and unless the inode is released the OS will not release the space and that will happen only when the process that has those file handles open, closes them or is terminated. We end up shutting down the database and on occasion reboot the server. When you move files across file system you are again copying the files and then removing the directory entries in the source file systems. The process that has the files open is not affected by the rename/removal of a file's directory entry.
I have looked at these processes using the files by using fuser but I haven't found that generally useful since it tends to dump all the oracle processes. The other utility that I know of but haven't used is lsof which gives the list of open files.
A long shot: One approach you may be able to take is to issue an archive log stop for a brief period (not sure if this will stop the archiver or not since the alert log says it is deprecated and the processes are still hanging around) and see if it posts/causes the archiver to release the file handles and allow the os the release the space (assuming that you have sufficiently large and a large number of redo log groups such that transaction processing is not arrested).
President/Executive Architect, Quasar Database Technologies, LLC
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Prasad
Sent: Wednesday, January 16, 2008 5:01 PM To: Mir M. Mirhashimali
Subject: Re: df shows 100% on a empty filesystem-
This db is on solaris 8 . it do not have a lost and found . The du -a shows me the correct picture but the problem is i can not take down the db or unmount the file system now.
On Jan 16, 2008 3:51 PM, Mir M. Mirhashimali <mhyder_at_rice.edu> wrote:
I was in a similar situation recently. even after moving files from the directory it was showing 100%. check "lost and found" or ".snapshot" i am on redhat linux so not sure if this applies to you.
Hope this Helps
> The database is 10gR2 db running on solaris 8 .. There was archiver
> hung on archlogs01 filesystem . I moved all the archive logs to the
> backup filesystem . however df still shows archlogs01 100% filled.
> du shows correctly
> du -a /ofs/archlogs01
> 4 /ofs/archlogs01/oracle/PLLS
> 6 /ofs/archlogs01/oracle
> 10 /ofs/archlogs01
> gdf -h shows incorrect
> gdf -h | grep /ofs/archlogs01
> /dev/dsk/c2t0d11s0 2.9G 2.9G 2.0k 100% /ofs/archlogs01
> fuser -c do not show me any active process running on /ofs/archlogs01
> archive log stop also didnt help .
> Any suggestions!