Hi Dave,
Are you in archive log mode?
-Rocky
- "Farnsworth, Dave" <DFarnsworth_at_Ashleyfurniture.com> 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: 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).
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: rockyw_99_at_yahoo.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 Mon Aug 13 2001 - 12:48:06 CDT