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: Deep Doo-Doo

RE: Deep Doo-Doo

From: C.S.Venkata Subramanian <csvenkata_at_lycos.com>
Date: Thu, 16 Aug 2001 21:34:33 -0700
Message-ID: <F001.0036E62E.20010816212522@fatcity.com> 






Hi,


I tried to view the TAR posted by you, But it said that I don't have sufficient 
privileges to view the TAR. 



Can u pl send me a copy of the TAR 1766421.999.
TIA



venkat

--

On Thu, 16 Aug 2001 05:10:58  
 Farnsworth, Dave wrote:


>I did this from svrmgrl.  The database was shutdawn at the time.

>

>svrmgrl>STARTUP MOUNT

>svrmgrl>RECOVER DATABASE

>svrmgrl>STARTUP

>

>That was it.  It worked like a charm.  You can also view my TAR(1766421.999)

>for the blow by blow details.

>Oh yea, my dad got out of the hospital last night.  He has an infection but

>they do not know the source.  His temperature is back to normal, it was

>105(fahrenhiet).  Thanks to all for their thoughts!!

>

>Dave

>

>

>-----Original Message-----

>Sent: Thursday, August 16, 2001 3:31 AM

>To: DFarnsworth_at_Ashleyfurniture.com

>

>

>Hi,

>Can u share your experience, what solution did support gave to open the

>database. It will be useful for other databases.

>

>TIA

>Best Regards

>Venkat

>--

>

>On Mon, 13 Aug 2001 11:30:37  

> Farnsworth, Dave wrote:

>>Ron,

>>

>>Thanks, I opened a TAR with Oracle and their support person gave the

>>solution in a fairly quick manner.  I used the "recover database" command.

>>My database came back up and is running fine now.  The network admin is

>>happy to!!  I'll bet that there will ba a tape backup tomorrow!!!

>>

>>Dave

>>

>>-----Original Message-----

>>Sent: Monday, August 13, 2001 1:52 PM

>>To: Multiple recipients of list ORACLE-L

>>

>>

>>Dave,

>>I hope all is okay with your father.

>>It sounds like you still have some datafiles that are still under the

>>control of the os backup script. If you did a cold backup and it was still

>>hung, who started the database up where you had to shutdown abort? Did the

>>alert log show any problems with the startup after the backup time? Was the

>>database shutdown to do the backup?

>>Dig deep and good luck.

>>ROR mª¿ªm

>>

>>>>> DFarnsworth_at_Ashleyfurniture.com 08/13/01 02:10PM >>>

>>I have a very bad situation.  When I got in this morning I saw that the

>>nightly backup was hung up.  I do a cold backup to another server and then

>>the network admins backup my backup to tape.  I did a shutdown abort and

>>then restarted my database.  But during the startup I got this in my

>><SID>alrt.log

>>

>>EMN0 started with pid=19

>>Mon Aug 13 06:46:23 2001

>>KCF: write/open error block=0x1c75 online=1

>>     file=10 E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF

>>     error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to

>>file

>>O/S-Error: (OS 5) Access is denied.'

>>DBW0: terminating instance due to error 1242

>>Instance terminated by DBW0, pid = 457

>>Dump file I:\orant\admin\DISPATCH\bdump\dispatchALRT.LOG

>>

>>I also had a oradim.txt file created with this info;

>>

>>ORA-01113: file 10 needs media recovery

>>ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'

>>

>>ORA-01113: file 10 needs media recovery

>>ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'

>>

>>ORA-01113: file 8 needs media recovery

>>ORA-01110: data file 8: 'E:\ORANT\ORADATA\DISPATCH\CIMDATA01_01.DBF'

>>

>>ORA-01113: file 10 needs media recovery

>>ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF'

>>

>>Now comes the good part.  Guess what part of the backup process was not

>>scheduled as it should have been.  That's right, the tape backups!!  The

>>network admins never scheduled my data for backup to tape.  All I have is

>>last nights backups which are no good.  I opened a TAR but if any of you

>>have any ideas I can try, I'm open for anything.  My database is down.

>>I also just heard that my father is hospitalized.  Today really sucks!!

>>

>>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: Ron Rogers

>>  INET: RROGERS_at_galottery.org

>>

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

>>

>

>

>Get 250 color business cards for FREE!

>http://businesscards.lycos.com/vp/fastpath/

>-- 

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

>



Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: C.S.Venkata Subramanian
  INET: csvenkata_at_lycos.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 Thu Aug 16 2001 - 23:34:33 CDT












Original text of this message













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