which process is still using deleted files

[GTFSpanneer]

Hi All,

We have deleted some files but the file system space is not getting reclaimed. how to check which process is still using deleted files in hp ux


Thanks in advance.

Panneer

[AnthonySN]

which files have you deleted, are they any datasbase files or normal text files?

[GTFSpanneer]

Hi SASj,

database file.

tbs1_tmp01.dbf

[rariasn]

Hi:

Restart application.

Use lsof utility.

http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=110362

rgs,

[Asif Sharif]

Hi,

shutdown/Start up your database will solve your issue.

Regards,
Asif Sharif

[AnthonySN]

and how did u delete that file doing rm -rf, which is not the correct way of doing it.
you need to restart db.

[Berd]

I would use lsof utility.

[Viktor Balogh]

Hi,

Use this command to identify the processes which use the already deleted files:

# lsof +D / +L1

Look for the files with NLINK count of zero.

Regards,
Viktor

[Elmar P. Kolkman]

And if you don't have lsof installed but a working version of glance, you could use that.

But in this case, you know which file it is, so you might also know which database had that file. That means that you or your DBA should be able to find which database and which databases process is using the file (possibly all processes of the database, if it's the temporary tablespace for your oracle database, for instance). Restarting the database should solve your issue from a Sysadmin point of view, though I suspect it means the database is broken from a DBA point of view...