Thread: error message when running SQL
05-23-12, 05:54 #1Registered User
- 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.
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
05-23-12, 08:48 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
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.
05-23-12, 08:50 #3Lost Boy
Provided Answers: 5
- Join Date
- Jan 2004
- Croatia, Europe
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.