Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Tough Oracle DBA experience

Re: Tough Oracle DBA experience

From: Rachel Carmichael <wisernet100_at_yahoo.com>
Date: Mon, 25 Aug 2003 02:49:34 -0800
Message-ID: <F001.005CD002.20030825024934@fatcity.com>

  1. Data Unloader. Takes them forever to admit it exists, but once they do, it does save your butt (and your database!). Been there, done that.
    • Yechiel Adar <adar76_at_inter.net.il> wrote:
      > 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).
      >


Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.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).
Received on Mon Aug 25 2003 - 05:49:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US