RE: df shows 100% on a empty filesystem-

  • From: <krish.hariharan@xxxxxxxxxxxx>
  • To: <p4cldba@xxxxxxxxx>, "'Mir M. Mirhashimali'" <mhyder@xxxxxxxx>
  • 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).




Krish Hariharan

President/Executive Architect, Quasar Database Technologies, LLC


From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Prasad
Sent: Wednesday, January 16, 2008 5:01 PM
To: Mir M. Mirhashimali
Cc: oracle-l
Subject: Re: df shows 100% on a empty filesystem-


Hi Mir,

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@xxxxxxxx> 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

Prasad wrote:
> All,
> 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!
> Prasad

> !DSPAM:59,478e896a200741201525439!


Other related posts: