RE: Accidentally Delete *.dbf Files, OH NO!!!

Very good of you to pick up on the fact that I mentioned other flavors besides solaris seem to "recognize" that the files are in use.

A lot of people assumed, from my post, that since the "rm" was executed as root, that an SA performed the dirty deeds. In one case, it was another DBA, who simply did not recognize the fact that the .dbf files were part of a live database (for good reason - they were under a misnamed directory!!!).

My point is, that on AIX at least, I believe you are first WARNED that the files are in use.

I was hoping there was some way to achieve that same type of behavior on Solaris. We also use Redhat Linux in my shop. I've yet to determine if Linux also limits deletion of files in use.

Anyone know?

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Steven Patenaude
Sent: Monday, January 31, 2005 5:51 PM
To: stephenbooth.uk_at_gmail.com
Cc: davidsharples_at_gmail.com; Oracle-L_at_freelists.org Subject: Re: Accidentally Delete *.dbf Files, OH NO!!!

On Mon, 31 Jan 2005 23:40:10 +0000, stephen booth <stephenbooth.uk_at_gmail.com> wrote:
> On Mon, 31 Jan 2005 23:26:36 +0000, David Sharples
> <davidsharples_at_gmail.com> wrote:
> > lock down the os account so you cant log in as the owner of the file
>
> Doesn't help when they're logging in as root. Root can delete any
> file regardless of permissions.
>
> Stephen

I've mainly worked on solaris, now starting on linux. It seemed like the original poster said that some other unix flavors actually don't do the rm if the file is in use. I've used fuser on files to make sure they are not in use before rm'ing, is there an alternate version of solaris rm that'll automatically check for file handles?

Note: the fuser trick doesn't seem to work on a clustered file system...

STeven

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

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