RE: Deep Doo-Doo
TAR Number 1766421.999 Open Date 13-AUG-01 16:14:03 Support Identifier 3223081 Name Dave Farnsworth Priority 2 Last Update 13-AUG-01 18:02:05 Product Oracle Server - Enterprise Edition Product Version 8i Platform MS Windows NT Detailed Status Soft Close TAR Reference n/a BUG Reference n/a Abstract I have a couple of bad data files and no backups. Resolution History 13-AUG-01 16:14:03 GMT Can you easily recover from, bypass or work around the problem? = NO Does your system or application continue normally after the problem occurs? = NO Are the standard features of the system or application still available; is the loss of service minor? = NO ### Platform and O/S version, including patchset or service pack level? ### NT 4.0 SP6 ### What version and patchset level of the database are you running? ### 8.1.7 ### Please describe your problem: ### During last nights backup something caused the backup to hang. I do a cold backup nightly and the backup is run from a script that is scheduled nightly at midnight. It does a disk to disk copy and then area that is copied to is suppose to go to tape. When I got to work this morning I could not connect to my DB so I went to the server. There were no error messages and no programs(like a DOS window) opened up. I could see that the backups had copied only three of my datafiles to the backup directory. I did a shutdown abort and then did a startup. After it started up I saw in the Alrt.log this error; Errors in file I:\orant\admin\DISPATCH\bdump\dispatchLGWR.TRC: ORA-01110: data file 10: 'E:\ORANT\ORADATA\DISPATCH\DISDATA01_01.DBF' ORA-01114: IO error writing block to file 10 (block # 1) ORA-27072: skgfdisp: I/O error OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied. Restarting dead background process EMN0 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 The DOS session from the nightly backup job must have still been running in the back ground since no DOS session windows were on the server. I tried to do a recovery from the nightly backup but that also gave the same error. It is like something corrupted a data file during the backup. I then thought I would take it off of a tape from Saturday night but was informed that these tapes did not exist(surprise, surprise). So I have a database that is down with no backup that is any good. What are my options?? Thanks, Dave ### If you are receiving errors, please list exact error messages and text: ### ORA-01113: file 10 needs media recovery Text continued in next action... 13-AUG-01 16:15:04 GMT Text continued from previous action... 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' ### Did the error generate a trace file? ### No Remote Diagnostic Agent Unknown ### What was being done at time of error? Any changes since this last worked? ## cold backups. There were no changes to any of the backup scripts. ### Can error be generated if SQL is run in SQL*PLUS or Server Manager? ### Does not apply ### What is the frequency of the error? ### Consistently ### What is the impact to your business because of this problem? ### This is a production database. I need help ASAP. Error : ora-01113 Contact me via : Telephone -> 608-323-6733 13-AUG-01 16:36:30 GMT The OS5 error, I am told, indicates that some other process had the file locked while you were trying to access it. At this point, try bringing the database to a MOUNT state, and issue the RECOVER DATABASE command. There are some log files which may be available and the DB should find them. If not... Calling Dave... goes to vm; left message suggesting above. 13-AUG-01 16:40:58 GMT already assigned 13-AUG-01 16:53:02 GMT New info : Michael, Can you please call. I got your message about the recovery tools that Oracle has. I would appreciate if you can walk me through this process. I am also going to try calling you. Thanks, Dave 13-AUG-01 17:37:29 GMT calling... 13-AUG-01 17:40:22 GMT Client will try to RECOVER and will update TAR. 13-AUG-01 18:02:05 GMT Closed by customer Michael, Thanks a ton!! It worked like a charm. My database is up and running. This TAR can be closed. Thanks, Dave -Original Message- Sent: Friday, August 17, 2001 12:25 AM
RE: Deep Doo-Doo
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: [EMAIL PROTECTED] > > >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 >> > [EMAIL PROTECTED] 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 >>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: [EMAIL PROTECTED] >> >>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] >> >>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: [EMAIL PROTECTED] (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 informatio
RE: Deep Doo-Doo
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: [EMAIL PROTECTED] 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 > [EMAIL PROTECTED] 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 >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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >
RE: Deep Doo-Doo
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 >>> [EMAIL PROTECTED] 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 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Deep Doo-Doo
The unable to write to might simply be because another process has it ... i.e. the backup process. You need to find out if the file is open by another process. If its possible, kill that hold. -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 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Kevin Lange INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Deep Doo-Doo
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 >>> [EMAIL PROTECTED] 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 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Deep Doo-Doo
Hi Dave, Are you in archive log mode? -Rocky --- "Farnsworth, Dave" <[EMAIL PROTECTED]> wrote: > 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 > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Deep Doo-Doo
Dave, First thing I always look at on this is directory/file ownership and permissions. Make sure that Oracle can write there. This is obviously NT. Check your disk administrator tool. I have (in the past) seen where NT on a reboot reassigns drive letters to the various drives (D becomes E, F becomes G, etc.). If that is the case, make sure that all the oracle services are down and then use the disk admin to reassign the drive letters correctly. HTH If you don't mind I'll keep you and your father in prayre today also. Rodd Holman On 13 Aug 2001 10:10:28 -0800, Farnsworth, Dave wrote: > 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 > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). -- Rodd Holman Enterprise Data Systems Engineer LodgeNet Entertainment Corporation (605) 988-1373 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Deep Doo-Doo
Hi Dave, do you use Alter tablespace .. begin backup ?? if yes then ..FWIW ..try mounting the DB and doing a alter tablespace .. end backup for tablespace that might still be in that mode(maybe the one containing file10) hth Deepak --- "Farnsworth, Dave" <[EMAIL PROTECTED]> wrote: > 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 > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Deep Doo-Doo
Hi Dave, do you use Alter tablespace .. begin backup ?? if yes then ..FWIW ..try mounting the DB and doing a alter tablespace .. end backup for tablespace that might still be in that mode(maybe the one containing file10) hth Deepak --- "Farnsworth, Dave" <[EMAIL PROTECTED]> wrote: > 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 > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).