Re: Re[2]: Big Whoops

me....

logged into two terminals, one was production, one was test. In both the tablespaces had the same names. So I think I am going to drop the two tablespaces in test, so I can recreate from production.

I do alter tablespace <xxx> offline;
drop tablespace <xxx> including contents;

and then scream as I realize I dropped a production tablespace. I go into my user's office and tell him he can kill me later, this is what I did, how does he want me to proceed to fix it. fortunately the production one was static data, and could be recreated. we do so.

he then tells me I have used up all my screw-ups for the next 5 years.

everyone does stupid stuff. the trick is to admit it and know how to recover from it

Rachel

>From: "Steve Boyd" <pimaco_oracle_at_hotmail.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Re[2]: Big Whoops
>Date: Thu, 25 May 2000 07:38:38 -0800
>
>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
>the wrong database(thinking you were connected to say the test DB), and
>hosed production?
>
>Steve Boyd
>
>>From: dgoulet_at_vicr.com
>>Reply-To: ORACLE-L_at_fatcity.com
>>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
>>Unix
>>boxes to support an additional manufacturing line. Since the first
>>instance was
>>well tuned, I copied the init.ora file to a new name & did the little
>>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
>>got
>>trashed and the original instance terminated with errors. We had to
>>recover
>>that one from tape since I hadn't backed up the control files to trace for
>>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,
>>or
>>an AW SH%$. First step in the process is to step back, take a deep breath
>>&
>>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
>>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
>> >Reply-To: ORACLE-L_at_fatcity.com
>> >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
>>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
>>of
>> >your
>> >mind? you better be!
>> >
>> >
>> >
>> >
>> >--
>> >Author:
>> > INET: Lisa_Koivu_at_gelco.com
>> >
>> >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
>> >(or the name of mailing list you want to be removed from). You may
>> >also send the HELP command for other information (like subscribing).
>>
>>________________________________________________________________________
>>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>>
>>--
>>Author: Rachel Carmichael
>> INET: carmichr_at_hotmail.com
>>
>>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
>>(or the name of mailing list you want to be removed from). You may
>>also send the HELP command for other information (like subscribing).
>>--
>>Author:
>> INET: dgoulet_at_vicr.com
>>
>>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
>>(or the name of mailing list you want to be removed from). You may
>>also send the HELP command for other information (like subscribing).
>
>________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>--
>Author: Steve Boyd
> INET: pimaco_oracle_at_hotmail.com
>
>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
>(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 Thu May 25 2000 - 20:02:13 CDT