Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2013
    Posts
    6

    Unanswered: Oracle no backup and ORA-00376: file 15 cannot be read at this time

    Hi,

    Have this problem:

    ORA-00376: file 15 cannot be read at this time
    ORA-01110: data file 15: 'DB_DISK:[STEMPS.DATA]TS_VB_MEDIUM_DATA_2.DBF'
    00376. 00000 - "file %s cannot be read at this time"
    *Cause: attempting to read from a file that is not readable. Most likely
    the file is offline.
    *Action: Check the state of the file. Bring it online

    Problem is that it is not any valid backup what i have found!

    What to do in this urgent matter.
    Regards,
    //Bjerka

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >What to do in this urgent matter.
    update your resume since you may need to find a new job in the near future.

    post complete results from SQL below


    SELECT * FROM V$VERSION;
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Oct 2013
    Posts
    6
    Problem is that i cant reach the system , because vpn problem so i try to help from "distans".

    I come back whit the result.
    Thanks,

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    if no backup exists, then data within TS_VB_MEDIUM_DATA_2.DBF may be permanently lost
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Oct 2013
    Posts
    6
    I have this posted from logfile.


    Errors in file $1$DGA3:[STEMPS.TRC]STEMPS_BG_CKPT_005.TRC;:
    ORA-01171: datafile 15 going offline due to error advancing checkpoint
    ORA-01122: database file 15 failed verification check
    ORA-01110: data file 15: 'DB_DISK:[STEMPS.DATA]TS_VB_MEDIUM_DATA_2.DBF'
    ORA-01203: wrong incarnation of this file - wrong creation SCN

    How to rescue this.
    //bjerka

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >How to rescue this.
    TS_VB_MEDIUM_DATA_2.DBF file is corrupt & can not be used by Oracle.
    You report you have no backup.
    At best you can minimize the damage, but accept the reality that data has been lost.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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