Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Recover an unrecoverable database

RE: Recover an unrecoverable database

From: Binley Lim <>
Date: Thu, 12 Sep 2002 17:33:21 -0800
Message-ID: <>

If I recall the original problem, you have a backup of the datafiles, and redologs, but no controlfiles. In that case, just specify all the datafiles and redologs (that are in the backup) in the "create controlfile..." statement.

The order does not matter, nor is the list required to be complete. Oracle will compare the file headers with the dictionary, and flag files you have not provided in the create controlfile as "missing". After the "create controlfile", recover database, and alter database open. Everything required for recovery is in the redologs, so a normal recovery is possible. No need for any underscore parameters -- they cause more problems.

>>> DWILLIAMS_at_LIFETOUCH.COM 09/13/02 05:08a.m. >>>
Dan - When you say "recreate a control file" are you meaning the CREATE CONTROLFILE statement? If so, then in answer to that specific issue, the order of the datafiles does not matter. I do this regularly to create test databases and I've never worried about making the order the same. I have even left datafiles off and Oracle just flags those. That doesn't solve your overall problem, though.

Dennis Williams
Lifetouch, Inc. <>

-----Original Message-----
Sent: Thursday, September 12, 2002 11:33 AM To: Multiple recipients of list ORACLE-L

I've tried several approaches to the recovery. So far, no success. I have a feeling that this is a truly unrecoverable db (without having Oracle Field Support use their magic).

The main problem (in my mind) is that the current database physical structure (files and sizes) does not match the backup version, so I have no guide for creating a controlfile. When you recreate a controlfile, the files are listed in a specific order, which I presume matches the file# in sys.file$. So, if you don't know the proper order, the file information in the controlfile and data dictionary will be mismatched and thus the db cannot be opened. Right or wrong?

Thanks to all for the ideas and information.


Please see the official ORACLE-L FAQ:
Author: Binley Lim

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: (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).
Received on Thu Sep 12 2002 - 20:33:21 CDT

Original text of this message