Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2006
    Posts
    1

    Unhappy Unanswered: Database instance shutdown

    Hi all,

    I got the following message on weekend at this specific time where my database instance was shutdown by itself. I already check it out and there was no other services which is running on the specific time but yet it was shutdown with unknow reason... Anyone of you have this experience before ? The log shown the following message :-

    Mon Jun 26 00:57:01 2006
    KCF: write/open error block=0x59 online=1
    file=2 E:\ORADATA\ORCL\UNDOTBS01.DBF
    error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file
    O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.'
    Mon Jun 26 00:57:01 2006
    Errors in file e:\admin\orcl\bdump\orcl_dbw0_3228.trc:
    ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
    ORA-01114: IO error writing block to file 2 (block # 89)
    ORA-01110: data file 2: 'E:\ORADATA\ORCL\UNDOTBS01.DBF'
    ORA-27072: File I/O error
    OSD-04008: WriteFile() failure, unable to write to file
    O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.

    DBW0: terminating instance due to error 1242

    Rgds
    Lim

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

    I'd say that your hard disk is dead. Buy a new one and recover the database.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    I don't know if I would go as far as saying the hard drive crashed, but the datafile specified has been corrupted and can't be recovered.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •