Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Deep Doo-Doo

Re: Deep Doo-Doo

From: Deepak Thapliyal <deepakthapliyal_at_yahoo.com>
Date: Mon, 13 Aug 2001 10:35:36 -0700
Message-ID: <F001.00368E70.20010813103145@fatcity.com>

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"
<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: Deepak Thapliyal
  INET: deepakthapliyal_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:35:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US