Re: Recover an unrecoverable database

[Peter Gram]

Hi Dan

It should be possible to open that database !

1)     You should restore the databse from tape once more to make sure we start on somthing clean.
2)    Add the _allow_resetlogs_corruption=true to the parameter file (init.ora)
3)    Mount the database and create new controlfiles
4)    Do a fake recovery via
        4.1) recover database;
        4.2) when it asks for a  archive file type 'mogens'
        4.3) cancel the recovery session
5)    Open the database with resetlogs


You migth need to corrupt the Rollback as well with _corrupted_rollback_segments=(xx, xx, xx)
where 'xx' are the names of the rollback segments in the database.

If the database makes a fuzz abut not being in Archive log mode that can be fixed when you create the control file.

There are alwas the the real brut force way : create a database with the same name and that same datafiles, redologfiles, and controlfile
and then copy the header blocks from the datafile's to the old database with dd.

-----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).
    

-- 
/regards

Peter Gram

Mobil : +45 2527 7107
Fax   : +45 4466 8856

Miracle A/S
Kratvej 2
2760 Måløv
http://miracleas.dk

smime.p7s
Description: application/pkcs7-signature