Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re[2]: Big Whoops
Similar bonehead move here. I had made copies of a 100MB production data =
file onto several different servers because I wanted to test a theory =
about I/O throughput on the different boxes. Later, as I was cleaning up =
the extra data files the boss called. I gave him his alloted 5 minutes of =
my undivided attention, then started doing stuff on the side while =
muttering "uh-huh" into the phone. Sure enough, just as I hit the enter =
key I realized I was DELETING THE LIVE DATA FILE! After a few minutes =
sheer panic I figured out there fortunately were only indexes in that data =
file, and the data dictionary still had the information necessary to =
recreate the indexes. Took me a while to recreate everything, and I had =
to eat some serious crow over that one. Even though I knew better at the =
time now I REALLY don't do anything like that. All in all not too painful =
a way to learn a very important lesson.
>>> waysonkw_at_mail.milwaukee.k12.wi.us 05/25/00 02:51PM >>>
You expect us to admit this in public? <g>
O.K. - I deleted a datafile (Unix rm command), but the vendor software was so un-stable at the time that I just let everyone assume it was a software problem and not a human error problem. Now that the software is (more) stable, so am I. I hope.
Kent
>I'd like to post a question for everyone on the list.
>
>How many of you have ever dropped a table, or done something like that =
in=20
>the wrong database(thinking you were connected to say the test DB), =
and=20
>hosed production?
>
>Steve Boyd
>
>>From: dgoulet_at_vicr.com=20
>>Reply-To: ORACLE-L_at_fatcity.com=20
>>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>>Subject: Re[2]: Big Whoops
>>Date: Thu, 25 May 2000 06:40:46 -0800
>>
>>A couple of years ago I was trying to create a new instance on one of =
our=20
>>Unix
>>boxes to support an additional manufacturing line. Since the first=20
>>instance was
>>well tuned, I copied the init.ora file to a new name & did the little=20
>>editing
>>that I believed necessary, like a new db_name. What I forgot was the
>>control_file line. You can guess what happen next, yes the control =
files=20
>>got
>>trashed and the original instance terminated with errors. We had to=20
>>recover
>>that one from tape since I hadn't backed up the control files to trace =
for=20
>>some
>>time, but I do now at every shutdown. We live & learn from our =
mistakes,
>>hopefully NOT on a production server.
>>
>>
>>BTW: My advice to any new DBA out there is that when an emergency hits =
you,=20
>>or
>>an AW SH%$. First step in the process is to step back, take a deep =
breath=20
>>&
>>calm down. Adrenaline and instant reaction are your worst enemies.
>>
>>Dick Goulet
>>Senior Oracle DBA
>>Vicor Corporation
>>
>>____________________Reply Separator____________________
>>Author: "Rachel Carmichael" <carmichr_at_hotmail.com>
>>Date: 5/24/00 6:16 PM
>>
>>Lisa,
>>
>>You have backups? Restore from backup. Otherwise..... recreate and =
import=20
>>is
>>the way to go.
>>
>>I gotta say, the fact that you did this, figured out how to fix it, and
>>didn't freak out about it, would impress me MUCH more on an interview =
than
>>the fact that you have your OCP :)
>>
>>Rachel
>>
>>
>> >From: Lisa_Koivu_at_gelco.com=20
>> >Reply-To: ORACLE-L_at_fatcity.com=20
>> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>> >Subject: Big Whoops
>> >Date: Wed, 24 May 2000 14:44:29 -0800
>> >
>> >This is by far the funniest thing I have ever done. I began running =
the
>> >create
>> >database scripts (ON A TEST MACHINE) when the $ORACLE_SID was set to a
>> >currently
>> >running database. It's now completely and totally hosed. I'm just
>> >wondering if
>> >there is any possible way of recovering from this. I am just =
recreating
>> >the
>> >database and reimporting the data - it's not a big deal, but for =
future
>> >reference, I wonder if this really does mean THE END OF THE DATABASE =
AS=20
>>WE
>> >KNOW
>> >IT. My gut feel is YES.
>> >
>> >I just can't stop laughing. I finish my OCP exams and completely =
TRASH a
>> >large
>> >database in the same day (and dump pink ice cream on my white sweater
>> >simultaneously)! Like Kirti said, Who *WANTS* to be a DBA? Are you =
out=20
>>of
>> >your
>> >mind? you better be!
>> >
>> >
>> >
>> >
--=20
Author: Kent Wayson
INET: waysonkw_at_mail.milwaukee.k12.wi.us=20
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------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 Received on Thu May 25 2000 - 13:29:03 CDT
![]() |
![]() |