Oracle-L: RE: Block Corruption from SQL

From: MacGregor, Ian A. <ian_at_SLAC.Stanford.EDU>
Date: Wed, 13 Mar 2002 19:03:41 -0800
Message-ID: <F001.00428972.20020313190341@fatcity.com>

Okay, is it a logical or a physical corruption problem? Any disk errors this time? Do you have a backup from before the corruption occurred?

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_SLAC.Stanford.edu

-----Original Message-----
Sent: Wednesday, March 13, 2002 2:25 PM
To: Multiple recipients of list ORACLE-L

Anyone seen this one...

I have a user running SQL against a database, she keeps getting disconnected. After the 3'rd time we get a block corruption error. I was actually getting disconnected from a database yesterday while re-running catproc.sql. The db was hosed and so was soem disk so we decided to rebuild since it was not previously under our control, I ignored it for the time being. This is a completey different database and server (8.1.6 on Sun). I think she was running SQL*Plus on her client.

Here is the corrupted segment...

TABLESPACE_NAME                SEGMENT_TYPE       OWNER
------------------------------ ------------------
------------------------------

SEGMENT_NAME

SYSTEM                         INDEX              SYS

I_ICOL1

Error log...

Wed Mar 13 15:35:31 2002
Errors in file /oracle/app/oracle/admin/XY80/udump/XY80_ora_22473.trc: ORA-07445: exception encountered: core dump [kghsrch()+56] [SIGSEGV]
[Address not mapped to object] [4294967288] [] []
Wed Mar 13 15:35:35 2002
Errors in file /oracle/app/oracle/admin/XY80/udump/XY80_ora_22473.trc: ORA-07445: exception encountered: core dump [kghalf()+676] [SIGSEGV]
[Address not mapped to object] [4294967288] [] []

ORA-00607: Internal error occurred while making a change to a data block
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [kghsrch()+56] [SIGSEGV]

[Address not mapped to object] [4294967288] [] []
Wed Mar 13 15:36:32 2002
Recovery of Online Redo Log: Thread 1 Group 2 Seq 447 Reading mem 0 Mem# 0 errs 0: /db56/oracle/XY80/redo02a.dbf Recovery of Online Redo Log: Thread 1 Group 2 Seq 447 Reading mem 0 Mem# 0 errs 0: /db56/oracle/XY80/redo02a.dbf Recovery of Online Redo Log: Thread 1 Group 2 Seq 447 Reading mem 0 Mem# 0 errs 0: /db56/oracle/XY80/redo02a.dbf Recovery of Online Redo Log: Thread 1 Group 2 Seq 447 Reading mem 0 Mem# 0 errs 0: /db56/oracle/XY80/redo02a.dbf

SQL that was running...

CREATE UNIQUE INDEX PS_BUS_UNIT_TBL_FS ON PS_BUS_UNIT_TBL_FS

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1
ORA-01578: ORACLE data block corrupted (file # 1, block # 19386)
ORA-01110: data file 1: '/db61/oracle/XY80/system01.dbf'

*******************  Here is what is in the core file...

---collect: backup %d bytes

---before: icharn=%d; after: icharn=%d
---%stoken found.
no epsilon diacriticloc %ld: @U.%d.%d@
match : found matchtable with exceptionaltstable (no exceptionalts)found match: abort exceptionalt searchexhaust
ed exceptionalt chainepsilon after nidmove to alt:gentable: table entry matches exceptionoutput:
apply_fst_inverse entry: fstloc=%d fstbyte=%d tablelabel=%d alphabase=%d
failbacktrack: icharn=%d nextocharn=%d fstloc=%d fstbyte=%d pc=%d

to
input_epsilongentable_exceptedgentable_unexceptedoutput_epsilonoutput_matcho utputoperandoutput_nonidn
onid epsilonbacktrack: bad PC on returnoutput: icharn=%d nextocharn=%d fstloc=%d fstbyte=%d

matchedp=%d

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Post, Ethan
  INET: Ethan.Post_at_ps.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: MacGregor, Ian A.
  INET: ian_at_SLAC.Stanford.EDU

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Mar 13 2002 - 21:03:41 CST