RE: df shows 100% on a empty filesystem-

I have seen this happen frequently on various nix's more commonly with dropped tablespace data files, as long as a process that is still running had accessed the file. I used lsof to find the process that was accessing the files, then ps to determine which app, then if it was an oracle process, either had the user exit their session or killed it. Occasionally it was smon/pmon and we had to wait or bounce the instance.  

Ken  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Andrew Kerber
Sent: Wednesday, January 16, 2008 6:31 PM To: p4cldba_at_gmail.com
Cc: oracle-l
Subject: Re: df shows 100% on a empty filesystem-  

Does anything besides oracle write to that file system? If not, try bouncing your instance if you can do that.

On Jan 16, 2008 4:39 PM, Prasad <p4cldba_at_gmail.com > 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!

TIA
Prasad

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.' 



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