RE: Power outage

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Tue, 13 Nov 2001 16:29:59 -0800
Message-ID: <F001.003C4071.20011113161533@fatcity.com>

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: DFarnsworth_at_Ashleyfurniture.com

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: ListGuru_at_fatcity.com (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: MohanR_at_STARS-SMI.com

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: ListGuru_at_fatcity.com (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: DFarnsworth_at_Ashleyfurniture.com

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: ListGuru_at_fatcity.com (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: MohanR_at_STARS-SMI.com

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: ListGuru_at_fatcity.com (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 Tue Nov 13 2001 - 18:29:59 CST