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

  • From: Lyndon Tiu <ltiu@xxxxxxxxxxxxx>
  • To: mfontana@xxxxxxxxx
  • Date: Mon, 31 Jan 2005 18:48:12 -0800

On January 31, 2005 03:23 pm, Michael Fontana wrote:
> I have been working with Solaris for several years now.  We have had a rare
> but particularly debilitating problem where certain people who will remain
> nameless, in an effort to "clean up" disk space, have nailed a .dbf file or
> two.  I know I should have the solution to this on close at hand, but I
> seem to recall this was difficult, if not impossible, on other Unix
> platforms (such as AIX), because the file would be "locked" or "in use",
> and the nefarious "rm" command would fail.  Alas, Solaris is all too
> willing to comply when asked.
> Is there something that can be done, at the OS or Oracle level, to prevent
> such a thing?  Needless to say, the "whackers" are using root to enter the
> command, so changing permissions would accomplish little.  They are already
> set to only allow "oracle" write access.
> Any help or even ridiculing chuckles and admonitions would be greatly
> appreciated.

Replace the "rm" command with a shell script wrapper that detects a *.dbf file 
and ignore it and prints out a message telling the person trying to delete 
the *.dbf file thet they are very naughty.

Lyndon Tiu

Other related posts: