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


-----Original Message-----
From: Eric Buddelmeijer [mailto:Eric.Buddelmeijer@xxxxxxxxxx] 
Sent: Tuesday, February 01, 2005 11:30 AM
To: mfontana@xxxxxxxxx; Oracle-L@xxxxxxxxxxxxx
Subject: RE: Accidentally Delete *.dbf Files, OH NO!!!

Michael,

I Like one suggestion earlier in this thread about fuser. I have been trying
to get our sa's to incorporate it in some sort of wrapping for rm (alias,
link, function or other). Precisely because fuser will tell you if a user,
and even which one is using a file. Problem is I can't do it myself because
you need root privileges to use fuser, at least on the versions of solaris I
have seen (2.8 and 2.9). And the sa's have not found the time to work around
that. But there is also a chance fuser will not tell you that the file is
being used because it in fact it is not. Oracle might not have each and
every file opened. And the database could be down as well. 
Having said all that, maybe communication with your colleaques is the best
solution. Tell them when you put some essential files in an unlikely place.
So they know the files must not be deleted.

Thoughtful response.

I will look into "fuser".  

Still waiting to hear it verified that AIX does, in fact, tag the files as
in use.

As for putting essential files in unlikely placed - see my comments about
how we're sometimes forced to.  It's never a good idea.  It's sometimes even
done by accident.  For example - we have 5 Siebels running on a server -
named sbladev1, sblkdev1, sblhdev1, sblatng1, sblzdev1.  Some poor DBA who
will remain nameless (it could even be me!!!) might add a datafile for
sbladev1 under the sblkdev1 directory.  Then, someone asks for a refresh of
sblkdev1, and another DBA whacks all the files under sblkdev1.  Whoops!

He would at least get a message back in AIX, but not solaris.

You get the picture?

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

Other related posts: