God morning Dan,
I prefer to read the morning mail, especially from here, before posting an
answer just in case someone else has the same idea. But in this case I saw a
close one, but not the exact one. Where you've got a problem here is that
you've lost the damned control file. In that case you have two options 1) copy
the control file from the existing database (the one your using) which will be
way out in the future from the datafiles or 2) create a new control file. I
think your preferred option will be to dump the existing database control file
to trace. Then restore the backed up database onto another machine, create your
control file & allow the database to open. It should treat it as an instance
failure & read the on-line redo logs only.
The fun here is that Oracle wants all of it's files to match with regards to
SCN. Since your copy of the control file will have a SCN in the future you've
either got to get to that future point with archive redo or go nowhere. If you
create new control file(s) then their SCN is by default 0 and it will move
forwards to the datafiles SCN. (Believe it or not, but I've pulled this rabbit
out of my %^& in the past.)
Dick Goulet
____________________Reply Separator____________________
Author: "Fink; Dan" <[EMAIL PROTECTED]>
Date: 9/11/2002 2:18 PM
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.
<!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>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
