- 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