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 mm
>>
>>>>> 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