RE: df shows 100% on a empty filesystem-
Date: Wed, 16 Jan 2008 19:34:45 -0500
Message-ID: <A96B6F6348B14C9A99334C18714C635E@KenPC>
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-lReceived on Wed Jan 16 2008 - 18:34:45 CST