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: Farnsworth, Dave <DFarnsworth_at_Ashleyfurniture.com>
Date: Thu, 16 Aug 2001 05:01:59 -0700
Message-ID: <F001.0036CC75.20010816051058@fatcity.com>

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).
Received on Thu Aug 16 2001 - 07:01:59 CDT

Original text of this message

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