Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2008

    Unanswered: error message when running SQL


    We recently upgraded Oracle 9i to 10g on a new server by copying the 9i installation over first. Everything is giong fine however, I recently encountered this error message when running a specific query. And only when running that query. If I select data from that particular table in any other way, the queries work. The message below only pops up when running that specific query.

    HTML Code:
    ORA-01578: ORACLE data block corrupted (file # 127, block # 2846)
    ORA-01110: data file 1150: '/OPTDATA1/opt1/ericsson/2g/gprs/ERI_GPRS_D.ora'
    ORA-26040: Data block was loaded using the NOLOGGING option
    I still have access to the old server running Oracle 9i and the query runs fine there.

    Any ideas?


  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    what else can be said?
    26040, 00000, "Data block was loaded using the NOLOGGING option\n"
    //* Cause: Trying to access data in block that was loaded without
    //*        redo generation using the NOLOGGING/UNRECOVERABLE option
    //* Action: Drop the object containing the block.
    bcm@bcm-laptop:~$ oerr ora 1110
    01110, 00000, "data file %s: '%s'"
    // *Cause:  Reporting file name for details of another error. The reported
    //          name can be of the old file if a data file move operation is
    //          in progress.
    // *Action: See associated error message.
    bcm@bcm-laptop:~$ oerr ora 1578
    01578, 00000, "ORACLE data block corrupted (file # %s, block # %s)"
    // *Cause:  The data block indicated was corrupted, mostly due to software
    //	    errors.
    // *Action: Try to restore the segment containing the block indicated. This
    //	    may involve dropping the segment and recreating it. If there
    //	    is a trace file, report the errors in it to your ORACLE
    //	    representative.
    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
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    I'm not an expert, but it appears that "that specific query" selects data that is stored in a damaged part of the data file (maybe even hard disk).

    I'd suggest you to contact both DBA and system administrator who will do whatever is needed in such situations.

Posting Permissions

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