| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Database performance monitoring tool for developers.
HEY! I don't feel so bad!
I was working on a VMS (I HATE Eve) and was installing Oracle Designer. The install kept bombing and I kept trying to get it to work. Finally I got angry and decided to just start over.
The designer tables were in my schema. So was the General Ledger system tables that I was designing for the company I was with at the time.
There was an uninstall option on the designer installation, so I told it to uninstall. I don't know EXACTLY what it does, but it does NOT know what it puts into the schema. It removes everything in the schema... EVERY THING... as effective as recreating it.
We did NOT have backups (they weren't backing up the non-operations control parts of the VMS at all at that time) so I lost everything except the re-create scripts that were on my PC. I didn't get fired, and the guy who did our install told my boss that he would rather have me as a DBA after that than most of the people he deals with, because now I know the ramifications of not knowing what something does, and the criticality of a good backup (even of development... which we didn't have before I did that, either).
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
Well-behaved women rarely make history
-----Original Message-----
Sent: Friday, April 18, 2003 5:57 AM
To: Multiple recipients of list ORACLE-L
My philosophy exactly. I try never to make the same mistake twice, that's boring :) I say to people "I will tell you when I mess up because if I do, when I tell you that this time it isn't me, you'll believe me"
True story:
one day early on in my DBA days, I was working on both the dev and production database on two different terminals (back in the dumb terminal days on a VAX). Same database. Same tablespace names. I was dropping and recreating the DEV app. Two tablespaces, one static data, one dynamic. To save time (I thought), I did "alter tablespace <dynamic> offline; drpop tablespace <dynamic> including contents" on one and the same commands for the static tablespace on the other. After I hit send (why you never realize it beforehand I don't know), I realized that the static one I dropped was production.
I went into the app manager, my exact words were "you can kill me later, this is what I did, how do you want to go about fixing it".
Fortunately we had a cold backup from the night before and could rerun the batch.
Never made that mistake again.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: wisernet100_at_yahoo.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: April Wells INET: awells_at_csedge.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Apr 18 2003 - 08:48:54 CDT
 |
 |