Re: Recover an unrecoverable database

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 ----- From: "Fink, Dan" <Dan.Fink_at_mdx.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, September 11, 2002 5:54 PM Subject: RE: Recover an unrecoverable database

> 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
Received on Wed Sep 11 2002 - 18:51:17 CDT