【Oracle数据库恢复】ORA-00600[25027]错误解析

ORA-00600[25027]错误的触发原因是ORACLE检测到一个无效的表空间号TSN Tablespace Number或者相对文件号Relative File Number。

该ORA-00600[25027]的2个变量各代表：

arg[a] Tablespace Number表空间号

arg[b] 十进制的相对数据块号Relative Data Block Address (RDBA)

该ORA-00600[25027]错误相关的模块为Kernel File management Tablespace component，其影响为可能的物理块损坏。

当该错误触发后如果 arg[b] 即RDBA为0，则该错误可能由于索引问题引起。

可以使用如下查询来获得有问题的索引：

 select do.owner,do.object_name, do.object_type,sysind.flags
     from dba_objects do, sys.ind$ sysind
     where do.object_id = sysind.obj#
     and bitand(sysind.flags,4096)=4096;

如果上面的查询返回了数据行，则建议用户进一步检查查询所获得的对象，并考虑drop这些对象来绕过错误。

进一步可以对trace文件中指向的表做一个analyze table validate structure cascade，来进一步确认该问题。

与ORA-00600[25027]相关的一些BUG列表如下：

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线： 13764045638 QQ号:47079569 邮箱：service@parnassusdata.com

NB	Bug	Fixed	Description
	14010183	11.2.0.3.BP22, 11.2.0.4.BP03, 12.1.0.2, 12.2.0.0	ORA-600 [ktspfundo:objdchk_kcbgcur_3] in SMON after failed temp segment merge load
	13503554	11.2.0.4, 12.2.0.0	Various ORA-600 errors crashing the apply process in a downstreams environment
	13785716	11.2.0.4, 12.1.0.1	Intermittent ORA-600 [25027] during upgrade from 10.2 to 11.2
	11661824	11.2.0.1.BP09	Assorted Dumps by SQL*LOADER using DIRECT and PARALLEL after exadata bp8 is applied
	10067246	12.2.0.0	ORA-600 [25027] ORA-7445 [kauxs_do_dml_cooperation] by CREATE INDEX ONLINE
	14138130	11.2.0.3.5, 11.2.0.3.BP13, 11.2.0.4, 12.1.0.1	SGA memory corruption / ORA-7445 when modifying uncompressed blocks of an HCC-compressed segment
	13330018	11.2.0.4, 12.1.0.1	ora-600 [ktspfmb_add1], [4294959240] occurred, then cannot recover with ora-600[25027]
	13103913	11.2.0.2.BP15, 11.2.0.3.3, 11.2.0.3.BP03, 11.2.0.4, 12.1.0.1	ORA-600 [25027] [ts#] [1] or false ORA-1 during dml while index is being rebuilt online
	10394825	11.2.0.3, 12.1.0.1	ORA-600[25027] [..] [0] inserting to ASSM segment
	10329146	11.2.0.1.BP10, 11.2.0.2.2, 11.2.0.2.BP03, 11.2.0.2.GIBUNDLE02, 11.2.0.2.GIPSU02, 11.2.0.3, 12.1.0.1	Lost write in ASM with multiple DBWs and a disk is offlined and then onlined
+	10209232	11.1.0.7.7, 11.2.0.1.BP08, 11.2.0.2.1, 11.2.0.2.BP02, 11.2.0.2.GIBUNDLE01, 11.2.0.3, 12.1.0.1	ORA-1578 / ORA-600 [3020] Corruption. Misplaced Blocks and Lost Write in ASM
+	9399991	11.1.0.7.5, 11.2.0.1.3, 11.2.0.1.BP04, 11.2.0.2, 12.1.0.1	Assorted Internal Errors and Dumps (mostly under kkpa/kcb) from SQL against partitioned tables
*	9145541	11.1.0.7.4, 11.2.0.1.2, 11.2.0.2, 12.1.0.1	OERI[25027]/OERI[4097]/OERI[4000]/ORA-1555 in plugged datafile after CREATE CONTROLFILE in 11g
	8837919	11.2.0.2, 12.1.0.1	DBV / RMAN enhanced to detect ASSM blocks with ktbfbseg but not ktbfexthd flag set as in Bug 8803762
	8803762	11.1.0.7.6, 11.2.0.1.2, 11.2.0.1.BP06, 11.2.0.2, 12.1.0.1	ORA-600[kdsgrp1], ORA-600[25027] or wrong results on 11g database upgrade from 9i
	8716064	11.2.0.2, 12.1.0.1	Analyze Table Validate Structure fails on ADG standby with several errors
+	8597106	11.2.0.1.BP06, 11.2.0.2, 12.1.0.1	Lost Write in ASM when normal redundancy is used
	7251049	11.2.0.1.BP08, 11.2.0.2, 12.1.0.1	Corruption in bitmap index introduced when using transportable tablespaces
	8437213	10.2.0.4.3, 10.2.0.5, 11.1.0.7.7, 11.2.0.1	ASSM first level bitmap block corruption
	8356966	11.2.0.1	ORA-7445 [kdr9ir2rst] by DBMS_ADVISOR or false ORA-1498 by ANALYZE on COMPRESS table
*	8198906	10.2.0.5, 11.2.0.1	OERI [kddummy_blkchk] / OERI [5467] for an aborted transaction of allocating extents
*	7263842	10.2.0.4.2, 10.2.0.5, 11.1.0.7.1, 11.2.0.1	ORA-955 during CTAS / OERI [ktsircinfo_num1] / dictionary inconsistency for PARTITIONED Tables
	6666915	10.2.0.5, 11.1.0.7, 11.2.0.1	OERI[25027] / dictionary corruption from concurrent partition DDL
	6025993	10.2.0.5, 11.1.0.6	ORA-600 [25027] in flashback archiving queries
	4925342	9.2.0.8, 10.2.0.3, 11.1.0.6	OERI [25027] / OERI [25012] on IOT analyze estimate statistics
*	7190270	10.2.0.4.1, 10.2.0.5	Various ORA-600 errors / dictionary inconsistency from CTAS / DROP
	4310371	9.2.0.8, 10.2.0.2	OERI [25027] from concurrent startup / shutdown in RAC
	4177651	10.2.0.1	Row migration within a MERGE may OERI[25027]
	4020195	10.1.0.5, 10.2.0.1	OERI 25027 can occur in RAC accessing transported tablespace
	4000840	9.2.0.7, 10.1.0.4, 10.2.0.1	Update of a row with more than 255 columns can cause block corruption
	3963135	10.1.0.5, 10.2.0.1	OERI[kcbgcur_3] / OERI:25027 during bitmap index updates
	3829900	10.1.0.4, 10.2.0.1	OERI[25027] possible accessing index in 10g
	2942185	9.2.0.6, 10.1.0.4, 10.2.0.1	Corruption occurs on direct path load into IOT with ADDED columns
	3085057	10.1.0.2	ORA-600: [25027] from ALTER TABLE .. SHRINK SPACE CASCADE
	2926182	9.2.0.5, 10.1.0.2	OERI[25027] / ORA-22922 accessing LOB columns in IOT in AFTER UPDATE trigger

Comments

Ask_Maclean_liu_Oracle says

2014/04/17 at 16:34

ORA-31693: Table data object “orauser”.”TASKEVENTDATA” failed to load/unload and is being skipped due to error:ORA-02354: error in exporting/importing dataORA-00600: internal error code, arguments: [25027], [11], [8459115], [], [], [], [], [] . . exported “orauser”.”SAVEDQUERY” 111.2 MB 16364 rows. . exported “orauser”.”WORKITEM” 1.673 GB 2016446 rowsORA-31693: Table data object “orauser”.”ORAPARTUSAGELINK” failed to load/unload and is being skipped due to error:ORA-02354: error in exporting/importing dataORA-00600: internal error code, arguments: [25027], [11], [8632279], [], [], [], [], [] . . exported “orauser”.”ORADOCUMENT” 8.654 GB 5243236 rows

回复
jingang says

2014/09/18 at 16:12

也遇到ORA-00600[25027]错误，但用上面的select检查索引无数据返回， analyze table wrh$_sql_plan validate structure cascade 也没有返回信息。请教这个问题该如何解决？谢谢！数据库版本：APPLY PSU 11.2.0.4.3Release: 2.6.32-431.23.3.el6.x86_64Version: #1 SMP Wed Jul 16 06:12:23 EDT 2014Machine: x86_64VM name: VMWare Version: 6Instance name: devRedo thread mounted by this instance: 1Oracle process number: 94Unix process pid: 21774, image: oracle@xxxx (M000)*** 2014-09-18 14:27:00.559*** SESSION ID:(655.59993) 2014-09-18 14:27:00.559*** CLIENT ID:() 2014-09-18 14:27:00.559*** SERVICE NAME:(SYS$BACKGROUND) 2014-09-18 14:27:00.559*** MODULE NAME:(MMON_SLAVE) 2014-09-18 14:27:00.559*** ACTION NAME:(Auto-Flush Slave Action) 2014-09-18 14:27:00.559Incident 84759 created, dump file: /u01/app/oracle/diag/rdbms/dev/dev/incident/incdir_84759/dev_m000_21774_i84759.trcORA-00600: internal error code, arguments: [25027], , [0], [], [], [], [], [], [], [], [], []*** KEWROCISTMTEXEC – encountered error: (ORA-00600: internal error code, arguments: [25027], , [0], [], [], [], [], [], [], [], [], []) *** SQLSTR: total-len=1936, dump-len=240, STR={INSERT INTO wrh$_sql_plan sp (snap_id, dbid, sql_id, plan_hash_value, id, operation, options, object_node, object#, object_owner, object_name, object_alias, object_type, optimizer, parent_id, depth, positi}Incident 84760 created, dump file: /u01/app/oracle/diag/rdbms/dev/dev/incident/incdir_84760/dev_m000_21774_i84760.trcORA-00600: internal error code, arguments: [kewrose_1], [600], [ORA-00600: internal error code, arguments: [25027], , [0], [], [], [], [], [], [], [], [], []], [], [], [], [], [], [], [], [], []*** KEWRAFM1: Error=600 encountered by kewrfteh*** KEWRAFM1: Error=600 encountered by kewrfteh*** KEWRAFS: Error=600 encountered by Auto Flush Slave.KEBM: MMON slave action policy violation. kewrmafsa_; viol=0; err=600*** 2014-09-18 14:27:04.483ORA-00600: internal error code, arguments: [kewrose_1], [600], [ORA-00600: internal error code, arguments: [25027], , [0], [], [], [], [], [], [], [], [], []], [], [], [], [], [], [], [], [], []OPIRIP: Uncaught error 447. Error stack:ORA-00447: fatal error in background processORA-00600: internal error code, arguments: [kewrose_1], [600], [ORA-00600: internal error code, arguments: [25027], , [0], [], [], [], [], [], [], [], [], []], [], [], [], [], [], [], [], [], []

回复

【Oracle数据库恢复】ORA-00600[25027]错误解析

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 ： 13764045638 QQ号:47079569 邮箱：service@parnassusdata.com

Comments

Comment 取消回复

服务热线： 13764045638 QQ号:47079569 邮箱：service@parnassusdata.com