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" <[EMAIL PROTECTED]> 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: '[EMAIL PROTECTED]' > Cc: '[EMAIL PROTECTED]' > > > 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. > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > -----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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
