Re: Recover an unrecoverable database

Steve,

no one will ever have a copy of data unloader because Oracle does not sell IT but sells the service of running it for you.

It's not urban legend, I've used it. It's from Field Support, not Tech Support, it's expensive as all getout and they are reluctant to use it.

It will generate either dump files that import can read or flat files that sqlldr can read, It helps if you have the SYSTEM tablespace, but it is not essential.

I would not suggest even trying to get Oracle to come in with this unless the data is so critical that you will lose enormous amounts of money if you don't use it (yes, it was for us)

Dan, if you want more info on it, email me offline.

Rachel

• Steve Perry <sperry_at_sprynet.com> wrote:
  > If you can't recover it, Oracle has, or had, a utility called DUL
  > (Data
  > UnLoader ???) that will read the datafiles and create files usable
  > by
  > sqlldr.
  > I haven't used it, but I heard about it several times.
  > It's still urban legend until I get a copy :)
  >
  > Anybody have a copy I can borrow for AIX or NT???
  >
  > Steve
  >
  > ----- Original Message -----
  > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
  > Sent: Wednesday, September 11, 2002 5:54 PM
  >
  >
  > > I have a colleague working the 'Official' approach with Oracle
  > support. I
  > am
  > > not certain what he will learn nor how quickly, so I'm taking the
  > shotgun
  > > approach.
  > >
  > > Dan
  > >
  > > -----Original Message-----
  > > Sent: Wednesday, September 11, 2002 3:26 PM
  > > To: 'ORACLE-L_at_fatcity.com'
  > > Cc: 'Dan.Fink_at_mdx.com'
  > >
  > >
  > > Dan - May be a good Oracle Support question. I've had pretty good
  > luck
  > with
  > > them on really challenging recoveries. My suggestion would be to
  > try
  > again.
  > > Load the files again from tape, but allow recovery when the
  > database comes
  > > up. Since the database was shutdown abort, Oracle will want to
  > automatically
  > > recover the database when it tries to start. The recovery
  > information is
  > > probably in the redo logs (good reason to back them up).
  > >
  > >
  > > Dennis Williams
  > > DBA
  > > Lifetouch, Inc.
  > > dwilliams_at_lifetouch.com <mailto:dwilliams_at_lifetouch.com>
  > >
  > > -----Original Message-----
  > > Sent: Wednesday, September 11, 2002 5:19 PM
  > > To: Multiple recipients of list ORACLE-L
  > >
  > >
  > > Here's the scenario - A backup was done of a database that had been
  > shutdown
  > > with the abort option. The redo logs (no archiving) are also backed
  > up.
  > The
  > > controlfiles have since been lost.
  > > Business request - Retrieve a schema that has since been dropped
  > from the
  > > database.
  > >
  > > Attempted solution - restore the backups, open the db without
  > performing
  > > recovery (resetlogs and readonly corruption allowed).
  > Unfortunately, this
  > > resulted in an ORA-00600 when it attempted to read the SYSTEM
  > datafile.
  > >
  > > Does anyone have any ideas of how to open this db so we can get the
  > data
  > out
  > > of the schema? We don't care if it is not consistent.
  > >
  > > All assistance is appreciated.
  > >
  > >
  > > --
  > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
  > > --
  > > Author: Fink, Dan
  > > INET: Dan.Fink_at_mdx.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).
  >
  > --
  > Please see the official ORACLE-L FAQ: http://www.orafaq.com
  > --
  > Author: Steve Perry
  > INET: sperry_at_sprynet.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).
  

  ---