Re: Re[2]: Big Whoops

I did the same thing a few years ago - client name witheld ;)

I had several windows open and ran a script that dropped a tablespace. After realizing, I wrote a "CREATE CONTROLFILE" script to allow the datafiles to be re-attached to the database.

Since then I color-code my windows (light red on black for production windows)...

Steve, Rachel - you are not alone...

-Ari

On Thu, 25 May 2000, Rachel Carmichael wrote:

> 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).
>
> ________________________________________________________________________
> 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
Received on Fri May 26 2000 - 09:50:36 CDT