Twice recently 1st one myself, 2nd by another dba:
- Wanted to resize a datafile from 1900M to 2049M,
and when I typed 2049, the 9 was the last digit on my
xterm window and the cursor didn't move ahead (as I
remember) so I stretched the window a bit more, did a
backspace (to remove 9) and typed 9 once again and
pressed Enter. After a lo..ng while I got an error
saying out of disk space and cannot resize file to
20499M. Luckily this wasn't production.
- Wanted to refresh a training database using a cold
backup copy of production. The dir structure we have
is something like:
/oradata/test
/oradata/trn
/oradata/dev
At the time of blunder she was in /oradata/test dir,
and in order to refresh trn, she wanted to remove its
existing files first, so:
cd ../trnn
(Again typing error) The cd failed, but didn't bother
to check.
rm *.*
Oops!! Blew up the test database.
Lucked out once again (being a non-prod db)
- Deepak
- Steve Boyd <pimaco_oracle_at_hotmail.com> wrote:
> 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
Received on Fri May 26 2000 - 15:28:10 CDT