I
would be curious to hear what Oracle Support suggests, Dan.
Regards,
Patrice Boivin
Systems Analyst
(Oracle Certified DBA)
Systems Admin & Operations | Admin. et
Exploit. des syst�mes
Technology
Services | Services
technologiques
Informatics
Branch | Direction de
l'informatique
Maritimes Region,
DFO | R�gion des Maritimes, MPO
E-Mail: [EMAIL PROTECTED]
-----Original Message-----
From: Fink, Dan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 11, 2002 7:19 PM
To: Multiple recipients of list ORACLE-L
Subject: Recover an unrecoverable databaseHere'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.
