What should I do??
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: What should I do??

  1. #1
    Join Date
    Apr 2001
    Posts
    151
    Hi all,

    I got error as follows,

    Errors in file F:\Orant\rdbms80\trace\berpPMON.TRC:
    ORA-00376: file 39 cannot be read at this time
    ORA-01110: data file 39: 'H:\ORCLBERP\ROLLBACK\RBS3BERP.ORA'

    I did shutdown immediate (it took about 15 mins) and I issued shutdown abort to bring database down. Then I startup mount and do datafile recovery, bring datafile online.
    now my database is up and running.

    My question is, same error happened last weekend (last Sat.) and today, it happened again. (same file) Could it be hardware problem or Oracle problem? How can I prevent this happen again?

    Oralce8.0.5.2.1/NT4.0 -SP6

    Thank you,
    Elin@trend

  2. #2
    Join Date
    Mar 2001
    Posts
    314
    Maybe NT networking problem

    The file appeasrs to be in a mapped drive.


    -amar

  3. #3
    Join Date
    Apr 2001
    Posts
    151
    Hi Amar,

    They are all local drivers. Dell-San box. I looked from event viewer, it says "the driver detected a controller error on device\harddisk6\partition1."

    In that case, would it be hardware not properly config.
    Also, how can I prevent this happen again?
    Elin@trend

  4. #4
    Join Date
    Mar 2001
    Posts
    314
    Please talk to your NT Administrator She/he would be the best person to give an answer to that.

    -amar

  5. #5
    Join Date
    Jan 2001
    Posts
    2,828

    Cool

    Hi

    check the contents of the alert log file for more info on the problems.thats the first place you should normally check for in case of problems.you can also post the contents of the log file here.maybe one of us can help you analyze.

    regards
    hrishy

  6. #6
    Join Date
    Apr 2001
    Posts
    151
    Hi Hrishy,

    ====== alert log file ============
    Wed Jul 04 23:37:19 2001
    KCF: write/open error block=0x30ca online=1
    file=39 H:\ORCLBERP\ROLLBACK\RBS3BERP.ORA
    error=27070 txt: 'OSD-04016: Error queuing an asynchronous I/O request.
    O/S-Error: (OS 1117) The request could not be performed because of an I/O device error.'
    Automatic datafile offline due to write error on
    file 39: H:\ORCLBERP\ROLLBACK\RBS3BERP.ORA
    Wed Jul 04 23:41:03 2001
    Errors in file F:\Orant\rdbms80\trace\berpSMON.TRC:
    ORA-00376: file 39 cannot be read at this time
    ORA-01110: data file 39: 'H:\ORCLBERP\ROLLBACK\RBS3BERP.ORA'

    Wed Jul 04 23:41:04 2001
    Errors in file F:\Orant\rdbms80\trace\berpSMON.TRC:
    ORA-00376: file 39 cannot be read at this time
    ORA-01110: data file 39: 'H:\ORCLBERP\ROLLBACK\RBS3BERP.ORA'

    ======= alert log file =========


    Elin@trend

  7. #7
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hi elintrend

    did you notice something in your log file.see what it says here

    Automatic datafile offline due to write error on
    file 39: H:\ORCLBERP\ROLLBACK\RBS3BERP.ORA

    oracle has taken your data-file offline as the oracle process was not able to write to this file due to some reason.now we have to investigate further i think for some reason (it is my guess though) oracle dbwr or lgwr was not able to write.now check the tarce files this will be in the loaction where you have set the init parameter back_ground_dump_test.there you can find more info and take remedial action.


    regards
    hrishy

  8. #8
    Join Date
    Apr 2001
    Posts
    151
    Hi hrishy,

    You are right, in the alert log file, it did say dbwr and lgwr can't write to my datafile 39, then Oracle took this file offline.

    I did check the trace file, but how can I get info from trace file? There are different trc files: ORA123321.trc, SMON.TRC and CORE.log. Which one can provide me some info for remedial action?

    Thank you
    Elin@trend

  9. #9
    Join Date
    Feb 2001
    Location
    Adelaide, Australia
    Posts
    159
    Check your hardware, sounds like it maybe your disk controller.

    Let us know what you find.

    Best of luck

  10. #10
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    is the server configured in cluster? we have had similar problems with Compaq Clustered NT machines, when it switched from one node to another the RBS always corrupts

Posting Permissions

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



Click Here to Expand Forum to Full Width