Re: Big Whoops

Lisa,

I did this same thing the day after I had given my 2 week notice! I just assumed that I would be leaving the company sooner than I had originally planned. Oracle support was telling me that I had 2 options: 1) recover the database 2) purchase a special recovery process they had that might get some of the the data out of the production database and the price started at only $10,000! However, after talking it over with some DBA friends, I was told that the production database was just confused, not hosed. And they were right. All I had to do was stop and restart the production instance. And I got to stay for the full 2 weeks!

Nancy

Lisa_Koivu_at_gelco.com wrote:
>
> 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).
Received on Thu May 25 2000 - 21:33:00 CDT