Tru64 5.1 8.1.7.3 We had a disk controller fail last week, but redundant hardware let the system stay up until it could be replaced over the weekend. The production database restarted without any problems, trace files, or alert log errors.
The problem is that the reporting copy of production, taken from a disk mirror break (hot backup, mounted on a seperate system) will not recover. I get an ORA-1190 'controlfile or data file 1 is from before the last RESETLOGS' but the last resetlogs was over a month ago. First attempt to solve was to use a slightly older copy of the SYSTEM datafile from an earlier backup disk mirror break (hot backup). Results were the same. I then assumed something was wrong with the controlfile, so I tried to rebuild that. No luck, the Create controlfile command returned a ORA1189 'file is from a different RESETLOGS than previous files' against file#2 (even though I replaced the file# 1's datafile with the original [neither copy of #1 was opened]). My worries are two-fold; 1) that there is a subtle error in the control file or SYSTEM datafile that only an attempted recovery exposes and 2) any backup taken after the hardware failure last week will not be viable. Any suggestions as how to proceed to either prove or disprove this. Thanks, Mike Hand Polaroid Corp P.S. I had hoped to go on vacation at the end of the week leaving a stable database behind (for a change). This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
