| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Recover an unrecoverable database
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C259D9.16D75020
Content-Type: text/plain;
charset="iso-8859-1"
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.
------_=_NextPart_001_01C259D9.16D75020
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4616.200" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=071531221-11092002>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. </SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=071531221-11092002>Business request -
Retrieve a schema that has since been dropped from the
database.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=071531221-11092002></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=071531221-11092002>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.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=071531221-11092002></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=071531221-11092002>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.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=071531221-11092002></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=071531221-11092002>All assistance is
appreciated.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=071531221-11092002></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=071531221-11092002></SPAN></FONT> </DIV></BODY></HTML>
Received on Wed Sep 11 2002 - 16:20:44 CDT
 |
 |