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

True of anyone not logged in to root if you can edit their .profile.

A really good SA has no aliases in root's .profile....and as such, me putting an alias in oracle's .profile will have no effect on any other user....

-----Original Message-----
From: David [mailto:thump_at_cosmiccooler.org]=20 Sent: Tuesday, February 01, 2005 9:03 AM To: ltiu_at_alumni.sfu.ca; 'Hollis, Les'
Cc: mfontana_at_verio.net; Oracle-L_at_freelists.org Subject: RE: Accidentally Delete *.dbf Files, OH NO!!!

Just alias rm to be rm -I

Don't need root for that

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Lyndon Tiu
Sent: Monday, January 31, 2005 7:10 PM
To: Hollis, Les
Cc: mfontana_at_verio.net; Oracle-L_at_freelists.org Subject: Re: Accidentally Delete *.dbf Files, OH NO!!!

On January 31, 2005 07:05 pm, Hollis, Les wrote:
> You know all of these helpful suggestions of replacing the rm command=20
> are great IF you happen to have root privileges. Most shops that have

> SA's and DBA's typically the DBA does not have root privs., so=20
> replacing rm would be an impossible task.....
>
>
> rydsup16:/bin> ls -l rm
> -r-xr-xr-x 1 root bin 18384 Jan 5 2000 rm
>
>
>
>
> The best set of suggestions was that of DOCUMENTING to COO, CIO, and=20
> GOD what has happened on not just this once but several occasions and=20
> be sure and keep a copy yourself. How much down time you had and=20
> asking them what the cost was to their business for the stupidity of=20
> an uneducated SA. (BTW I have been an SA in past lives so I do have=20
> somewhat of a concept of the job...that was until I encountered the=20
> 'force' and switched to a DBA)
>
> Do include the SA's and their managers.
>
> As also suggested let them know that your oracle filesystems do not=20
> need monitored for % usage and that as was mentioned you may damn well

> run them to 100%....I have MANY filesystems at 100%. At least the=20
> SA's I have are smart enough to understand the growth requirements and

> sanctity of my Oracle file systems. In fact, our monitoring software=20
> will page me when one of our filesystems (like $ORACLE_HOME or my=20
> Archive
> destination) hits 100%. It also ignores the rest of my FS's where
> datafiles reside because we have told it to ignore them)

You only have to get to this point if you cannot work with the people who
have=20
root permissions and who delete your database files.

Communication and edication is best. Working as a team is important.

Question?

Do you talk to the people who delete your dbf files? If so, why not take the

chance to talk to them about your grief, if not, why not? They are only=20 people.

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




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