I ran dbverify on the control files and found one that was corrupt. I edited the init.ora and took out the bad control file(I use two control files). Then I started up the database and it came up just fine. Made a new control file and I'm back up and running.
Dave -----Original Message----- Sent: Tuesday, November 13, 2001 6:16 PM To: Multiple recipients of list ORACLE-L Hmm...well...yikes....if you can place that file back, you might have a chance if what you need is in the online redo...... if you can't, and you need to go to a backup...it'll be a cold one.... <scratching head> -----Original Message----- Sent: Tuesday, November 13, 2001 6:55 PM To: Multiple recipients of list ORACLE-L That is correct -----Original Message----- Sent: Tuesday, November 13, 2001 5:20 PM To: Multiple recipients of list ORACLE-L I think you are in NOARCHIVELOG mode? Can you *see* L:\ORADATA\LV54\DATA\TBL_FCS_FBTS1_01.DBF in Explorer? -----Original Message----- Sent: Tuesday, November 13, 2001 4:45 PM To: Multiple recipients of list ORACLE-L We had a power outage and the network admins found out that the UPS sucks. I have an Oracle 8.0.5 on NT 4.0 that got rudely bounced a couple of times due to loss of power. Now I have a problem in bringing it back up. Here is what I get in my <SID>LGWR file. *** SESSION ID:(3.1) 2001.01.05.21.32.37.250 ORA-01110: data file 12: 'L:\ORADATA\LV54\DATA\TBL_FCS_FBTS1_01.DBF' ORA-01114: IO error writing block to file 12 (block # 1) ORA-27072: skgfdisp: I/O error OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied. error 1242 detected in background process Dump file J:\ORA805\ADMIN\LV54\BDUMP\lv54LGWR.TRC Tue Nov 13 13:55:57 2001 ORACLE V8.0.5.0.0 - Production vsnsta=0 vsnsql=c vsnxtr=3 Windows NT V4.0, OS V5.101, CPU type 586 Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production Windows NT V4.0, OS V5.101, CPU type 586 Instance name: lv54 Redo thread mounted by this instance: 0 <none> Oracle process number: 4 pid: db I cannot get the database to mount. Any ideas!! Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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: Mohan, Ross 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: Farnsworth, Dave 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: Mohan, Ross 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: Farnsworth, Dave 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).
