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

-- 
Rodd Holman
Enterprise Data Systems Engineer
LodgeNet Entertainment Corporation
(605) 988-1373
rodney.holman_at_lodgenet.com



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rodd Holman
  INET: rodney.holman_at_lodgenet.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).