Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Power outage

RE: Power outage

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Wed, 14 Nov 2001 06:42:37 -0800
Message-ID: <F001.003C490C.20011114063157@fatcity.com>

Congrats on pulling yer A** out of the fire......

Amazing that it was a control file...given that L:\ORADATA\LV54\DATA\TBL_FCS_FBTS1_01.DBF was showing as being unwriteable.....

Nice work....

-----Original Message-----
Sent: Tuesday, November 13, 2001 7:35 PM To: Multiple recipients of list ORACLE-L

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.

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).
--

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 Wed Nov 14 2001 - 08:42:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US