Re: Tough Oracle DBA experience

Hi!

My toughest experiences:

5) Once spilled orange juice on my keyboard. Washed it with care, then threw it away.
4) My colleague accidentially hit enter instead of backspace when wanted to erase "*" from rm -rf * . Restored from backup. 3) Blindly assumed that MySQL had ACID properties when was asked to build a small internet app about 5 years ago. Redesigned. (this one is very stupid ;)
2) Once spilled beer on my keyboard. Poured beer back to my glass. Threw away the keyboard.
1) Had to fix a 8.1.6 database, which hadn't worked well, after what the all-knowing CIO hired some ***hole to convert the same app into parallel server. A lot of money was spent, but the app performed even worse. I was called only to say that remove your OPS, remove one redolog member from all redo groups (which were on the same disk), analyze tables and set two parameters.

Good luck with your book.
Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Saturday, August 23, 2003 4:09 PM

> Dear All,
>
> I am collecting (Just writing in a book ) of all tough problems , great
> issues handled with Oracle RDBMS as a DBA.
>
> Request you kindly send us the Top 5 Problems , Difficult scenarios(the
most
> tough problems , with solution u did.)you faced so far in your DBA life.
>
> Hope to see many responses to this , atleast by Monday.
> Thanks a lot.
>
> Regards
> Rajuveera
> **************************************************************************
> This email (including any attachments) is intended for the sole use of the
> intended recipient/s and may contain material that is CONFIDENTIAL AND
> PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying
or
> distribution or forwarding of any or all of the contents in this message
is
> STRICTLY PROHIBITED. If you are not the intended recipient, please contact
> the sender by email and delete all copies; your cooperation in this regard
> is appreciated.
> **************************************************************************
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Veeraraju_Mareddi
> INET: rajuveera_at_satyam.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).