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