Re: Tough Oracle DBA experience

My worst one was when a datafile autoextend to 4GB boundary and hit a bug in 8.1.6.
Then we discovered that the last backup was taken about 3 weeks ago due to change in tablespaces placing that was not corrected in the backup job.

We did two things in parallel:

1. Called Oracle support, got an answer that there is no way to recover the database. Finally they come with an internal utility that rescued the data from the database.
2. Tried to recover from 3 weeks ago. This failed because some archive logs were missing.

Al last we rebuild a new database and loaded the data that oracle support rescued from the ruined database.
Also we contacted the application supplier to get a script to find how to calculate start value for a sequence.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Saturday, August 23, 2003 3: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: Yechiel Adar
  INET: adar76_at_inter.net.il

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).