RE: df shows 100% on a empty filesystem-
Date: Wed, 16 Jan 2008 19:34:45 -0500
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.
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
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:
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 .
-- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 16 2008 - 18:34:45 CST