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 DBA Lifetouch, Inc. [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -----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. Dan -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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).
