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

From: "Michael Fontana" <mfontana@xxxxxxxxx>
To: <spatenau@xxxxxxxxx>, <stephenbooth.uk@xxxxxxxxx>
Date: Tue, 1 Feb 2005 09:12:07 -0600

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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Steven Patenaude
Sent: Monday, January 31, 2005 5:51 PM
To: stephenbooth.uk@xxxxxxxxx
Cc: davidsharples@xxxxxxxxx; Oracle-L@xxxxxxxxxxxxx
Subject: Re: Accidentally Delete *.dbf Files, OH NO!!!

On Mon, 31 Jan 2005 23:40:10 +0000, stephen booth
<stephenbooth.uk@xxxxxxxxx> wrote:
> On Mon, 31 Jan 2005 23:26:36 +0000, David Sharples
> <davidsharples@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l

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

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

Other related posts: