ora00600错误问题的解决文档格式.docx

1、log 3 thread 1 sequence 1865Mon Aug 18 08:19:03 2008Thread 1 advanced to log sequence 1867Current log# 1 seq# 1867 mem# 0: E:ORACLEORADATAYXERPMon Aug 18 08:03 2008Current log# 1 seq# 1867 mem# 1: F:ORACLEDATAMon Aug 18 08:04 2008ARC0:log 2 thread 1 sequence 1866Mon Aug 18 08: Beginning to archive l

2、og 2 thread 1 sequence 1866Creating archive destination LOG_ARCHIVE_DEST_1:Mon Aug 18 08:06 2008Thread 1 advanced to log sequence 1868Current log# 5 seq# 1868 mem# 0:ORACLEORADATAYXERP05ACurrent log# 5 seq# 1868 mem# 1:06 2008ARC1:log 2 thread 1 sequence 1866ARC1: Unable to archive log 2 thread 1 se

3、quence 1866Log actively being archived by another processARC1:log 1 thread 1 sequence 1867ARC1: Beginning to archive log 1 thread 1 sequence 1867Creating archive destination LOG_ARCHIVE_DEST_1:ARC1:Log actively being archived by another processMon Aug 18 08:07 2008ARC0:log 2 thread 1 sequence 1866Mo

4、n Aug 18 09:09:57 2008Errors in file e:oracleadminyxerpudump:ORA-00600: 内部错误代码，参数: 12700, 36900, , 8, , 25, , Mon Aug 18 09:28:56 2008Errors in file e: 12700, 36900, , 8, , 25, , 看到ora-00600错误，我仍是比较担忧的，随后就和论坛里的兄弟们沟通二、解决步骤第一步-定为错误：查看trace文件，找到执行这次错误问题ORA-00600: 12700, 36900, , 8, , 25, , ，缘故：sqlSELEC

5、T consult_code, data_type, disp_sequence, disp_type, disp_value, dr, field_code, field_name, id, if_autocheck, if_datapower, if_default, if_desc, if_group, if_immobility, if_must, if_order, if_sum, if_used, max_length, opera_code, opera_name, order_sequence, pk_corp, pk_templet, return_type, table_c

6、ode, table_name, ts, userdefflag, value, resid, isCondition FROM pub_query_condition WHERE pk_templet = 1004AAJ6P and pk_corp in （ , 00011004 ） order by disp_sequence, order_sequence通过metlink里的文档，发觉12700是索引出问题了，有依照上述执行情形保留，核实一下是不是pub_query_condition出问题了？Sql analyze table obj$ validate structure casc

7、ade;Table analyzed analyze table PUB_QUERY_CONDITION validate structure; 你能够先如此确认,不加CASCADE再次查看trace文件，analyze table pub_query_condition validate structure cascadeanalyze table PUB_QUERY_CONDITION validate structure cascadeORA-01499: 表/索引交叉引用失败 - 请参阅跟踪文件第一参阅跟踪文件，再查看表的索引：SQL select tablespace_name, s

8、egment_type, owner, segment_name2from dba_extents where file_id = 11 and 116626 between block_id and block_id + blocks-1;TABLESPACE_NAME SEGMENT_TYPE OWNERSEGMENT_NAME- - - -NNC_DATA01TABLEYXERP1 PUB_QUERY_CONDITIONTrace文件里的（file # 14, block # 47845） thru （file # 14, block # 47845）from dba_extents w

9、here file_id = 14 and 47845 between block_id and block_id + blocks-1;Cannot execute commands nowTABLESPACE_NAMESEGMENT_NAME- - - -NNC_INDEX01INDEX I_PUB_QUERY_CONDIT第二步-查验表空间看是不是在有坏快？C:Documents and SettingsAdministratordbv file=E:oracleoradatayxerp blocksize=8192DBVERIFY: Release . - Production on

10、礼拜一 8月 18 18:32:01 2020Copyright （c） 1982, 2002, Oracle Corporation.All rights reserved.DBVERIFY - 验证正在开始 : FILE = E:oracleoradatayxerpDBVERIFY - 验证完成检查的页总数：896000处理的页总数（数据）：450600失败的页总数（数据）：0处理的页总数（索引）：10095失败的页总数（索引）：0处理的页总数（其它）：275379处理的总页数 （段）: 0失败的总页数 （段） 0空的页总数159926标记为损坏的总页数：0汇入的页总数0Highest b

11、lock SCN 4 第三步-查看表的其他索引select index_name,table_name from dba_indexes where table_name=PUB_QUERY_CONDITION;INDEX_NAMETABLE_NAME- -I_PUB_QUERY_CONDIT PUB_QUERY_CONDITIONPK_PUB_QUERY_CONDI PUB_QUERY_CONDITIONI_PUB_QUERY_CONDIT第四步-依照查询的索引信息，重建I_PUB_QUERY_CONDITalter index ip_pub_query_conti rebuild onli

12、ne或者drop index i_pub_query_condi create index i_pub_query_conti on pub_query_condition（pk_templet,pk_crop）tablespace NNC_index;第五步-查看警告日记alter database backup controlfile to tablespace1Completed: alter database backup controlfile to tablespacTue Aug 19 21:42:44 2020Wed Aug 20 05:36:13 2020Thread 1 a

13、dvanced to log sequence 1885 Current log# 3 seq# 1885 mem# 0:ORACLEORADATAYXERP03A Current log# 3 seq# 1885 mem# 1:ORACLEDATA14 2020ARC0: Evaluating archive log 4 thread 1 sequence 1884 Beginning to archive log 4 thread 1 sequence 1884 Completed archiving log 4 thread 1 sequence 1884Wed Aug 20 15:11

14、:41 2020Thread 1 advanced to log sequence 1886 Current log# 2 seq# 1886 mem# 0: Current log# 2 seq# 1886 mem# 1:ORACLEORADATAYXERP42 2020 Evaluating archive log 3 thread 1 sequence 1885 Beginning to archive log 3 thread 1 sequence 1885 Completed archiving log 3 thread 1 sequence 1885没有那个错误了，问题解决了。把握

15、Ora-00600 4194错误的解决方式 更新日期：2007-10-26 06:36 出处：网页教学网 站长整理问：我的数据库从头启动后，显现了Ora-00600 4194错误，日记如下：Sat Jan 21 13:55:21 2006Errors in file /opt/oracle/admin/conner/bdump/: internal error code, arguments: 4194, 43, 46, , , , , Sat Jan 21 13:21 2006Errors in file /opt/oracle/admin/conner/udump/: 4194, 45,

16、44, , , , , 请问具体应该如何解决？答：具体的解决方法是通过备份来进行恢复,因为Ora-00600 4194错误的显现说明UNDO段显现了问题，若是你没有备份,业能够通过特殊的初始化参数进行强制启动,下文针对Oracle的隐含参数进行恢复说明（由于你的实际情形可能会有所出入，因此请你进行测试前先行备份）。第一你需要确信当前的回滚段名称，注释：（能够从alert文件中取得） 21 2006Undo Segment 11 OnlinedUndo Segment 12 OnlinedUndo Segment 13 OnlinedSuccessfully onlined Undo Table

17、space 16.注意：对应的AUM （auto undo management） 下的回滚段名称为:_SYSSMU11$,_SYSSMU12$_SYSSMU13$现在你能够修改参数文件，利用Oracle隐含参数_corrupted_rollback_segments将回滚段标记为损坏，然后启动数据库，Oracle那么会跳过关于这些回滚段的相关操作，强制启动数据库。._corrupted_rollback_segments=然后利用参数文件启动数据库:oraclejumper dbs$ sqlplus / as sysdbaSQL*Plus: Release . - Production on

18、 Sat Jan 21 13:56:47 2006Copyright （c） 1982, 2002, Oracle Corporation. All rights reserved.Connected to an idle instance.SQL startup pfile=ORACLE instance started.Total System Global Area bytesFixed Size 451864 bytesVariable Size bytesDatabase Buffers bytesRedo Buffers 667648 bytesDatabase mounted.D

19、atabase opened.此刻数据库正常Open。注意观看alert文件所取得的如下信息:57:03 2006SMON: enabling tx recoverySMON: about to recover undo segment 11SMON: mark undo segment 11 as needs recoverySMON: about to recover undo segment 12SMON: mark undo segment 12 as needs recoverySMON: about to recover undo segment 13SMON: mark undo

20、 segment 13 as needs recoverySat Jan 21 13:03 2006Database Characterset is ZHS16GBKSat Jan 21 13:04 2006Created Undo Segment _SYSSMU1$Undo Segment 1 OnlinedCompleted: ALTER DATABASE OPENaSat Jan 21 14:02:11 2006SMON: mark undo segment 13 as needs recovery此刻你能够从头创建新的UNDO表空间，删除显现问题的表空间，修改参数文件，由参数文件生成新

21、的spfile，然后从头启动数据库： create undo tablespace undotbs1 2 datafile /opt/oracle/oradata/conner/ size 10M;Tablespace created.SQL alter system set undo_tablespace=undotbs1;System altered.SQL drop tablespace undotbs2;Tablespace dropped.请注意现在的alert文件记录的:Sat Jan 21 14:03:29 2006create undo tablespace undotbs1d

22、atafile size 10MSat Jan 21 14:29 2006Created Undo Segment _SYSSMU2$Created Undo Segment _SYSSMU3$Created Undo Segment _SYSSMU4$Created Undo Segment _SYSSMU5$Created Undo Segment _SYSSMU6$Created Undo Segment _SYSSMU7$Created Undo Segment _SYSSMU8$Created Undo Segment _SYSSMU9$Created Undo Segment _SYSSMU10$Created Undo Segment _SYSSMU14$Starting control autobackupControl autobac