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
[EMAIL PROTECTED]
-----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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
