Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Deep Doo-Doo
Never mind. I found the "recover database" command. It worked like a charm!! The network admin was happy too!!
Dave
-----Original Message-----
Sent: Monday, August 13, 2001 1:10 PM
To: Multiple recipients of list ORACLE-L
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 tofile
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).
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 Mon Aug 13 2001 - 13:16:02 CDT
![]() |
![]() |