ORA-00600 [13013], [5001]故障處理

startay發表於2016-01-08
ORA-00600 [13013], [5001]故障處理

alert.log 
  1. Thu Jan 07 06:20:40 2016
  2. Errors in file /oracle/app/diag/rdbms/cnpos5qa/cnpos5qa/trace/cnpos5qa_smon_8978724.trc (incident=153713):
  3. ORA-00600: internal error code, arguments: [13013], [5001], [268], [8458146], [5], [8458146], [17], [], [], [], [], []
  4. Incident details in: /oracle/app/diag/rdbms/cnpos5qa/cnpos5qa/incident/incdir_153713/cnpos5qa_smon_8978724_i153713.trc
  5. Use ADRCI or Support Workbench to package the incident.
  6. See Note 411.1 at My Oracle Support for error and packaging details.
  7. Non-fatal internal error happenned while SMON was doing logging scn->time mapping.
  8. SMON encountered 1 out of maximum 100 non-fatal internal errors.
  9. Thu Jan 07 06:20:45 2016
  10. Dumping diagnostic data in directory=[cdmp_20160107062045], requested by (instance=1, osid=8978724 (SMON)), summary=[incident=153713].
  11. Thu Jan 07 06:20:47 2016
  12. Sweep [inc][153713]: completed
  13. Sweep [inc2][153713]: completed
  14. ... ...
  15. Thu Jan 07 07:36:03 2016
  16. Errors in file /oracle/app/diag/rdbms/cnpos5qa/cnpos5qa/trace/cnpos5qa_smon_8978724.trc (incident=160007):
  17. ORA-00600: internal error code, arguments: [13013], [5001], [268], [8458146], [5], [8458146], [17], [], [], [], [], []
  18. Incident details in: /oracle/app/diag/rdbms/cnpos5qa/cnpos5qa/incident/incdir_160007/cnpos5qa_smon_8978724_i160007.trc
  19. Thu Jan 07 07:36:06 2016
  20. PMON (ospid: 15532412): terminating the instance due to error 474
  21. Thu Jan 07 07:36:06 2016
  22. System state dump requested by (instance=1, osid=15532412 (PMON)), summary=[abnormal instance termination].
  23. System State dumped to trace file /oracle/app/diag/rdbms/cnpos5qa/cnpos5qa/trace/cnpos5qa_diag_11404196_20160107073606.trc
  24. Dumping diagnostic data in directory=[cdmp_20160107073606], requested by (instance=1, osid=15532412 (PMON)), summary=[abnormal instance termination].
  25. Instance terminated by PMON, pid = 15532412

解決方法：

ORA-00600: internal error code, arguments: [13013], [5001], [268], [8458146], [5], [8458146], [17], [], [], [], [], []

透過ORA-600報錯引數收集物件資訊， ORA-600 [13013]引數說明如下：
-----------------------------------------------------------------------------------------
ORA-600 [13013] [a] [b] [c] [d] [e] [f] 

Arg [a] Passcount 
Arg [b] Data Object number 
Arg [c] Tablespace Relative DBA of block containing the row to be updated 
Arg [d] Row Slot number 
Arg [e] Relative DBA of block being updated (should be same as [c]) 
Arg [f] Code 
------------------------------------------------------------------------------------------
第二個引數“b”， 對應的是資料庫物件ID

SQL> Select object_name,object_type,owner from dba_objects where data_object_id=268;

OBJECT_NAME        OBJECT_TYPE                            OWNER
---------------  -------------------------------------- ---------------
SMON_SCN_TIME      TABLE                               SYS
SMON_SCN_TO_TIME_AUX  CLUSTER                      SYS

使用validate檢驗表關聯物件的可用性。 使用方法與說明，請參考下面lin
http://blog.itpub.net/17086096/viewspace-1973745/

ORA-01499說明SYS.SMON_SCN_TIME關聯的索引已損壞。
SQL> Analyze table SYS.SMON_SCN_TIME validate structure cascade online ; 
Analyze table SYS.SMON_SCN_TIME validate structure cascade online
*
ERROR at line 1:
ORA-01499: table/index cross reference failure - see trace file   --若報錯資訊未ORA-01498,說明表結果或資料損壞。請參考How to resolve ORA-00600 [13013], [5001] (文件 ID 816784.1)


使用dbms_metadata.get_ddl函式，檢視索引的建立資訊
SQL> Select dbms_metadata.get_ddl('INDEX','SMON_SCN_TIME_TIM_IDX','SYS') from dual;

DBMS_METADATA.GET_DDL('INDEX','SMON_SCN_TIME_TIM_IDX','SYS')
--------------------------------------------------------------------------------
  CREATE UNIQUE INDEX "SYS"."SMON_SCN_TIME_TIM_IDX" ON "SYS"."SMON_SCN_TIME" ("TIME_MP")
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSAUX"

重建索引
SQL> drop index "SYS"."SMON_SCN_TIME_TIM_IDX";
SQL> drop index "SYS"."SMON_SCN_TIME_SCN_IDX";
SQL> CREATE UNIQUE INDEX "SYS"."SMON_SCN_TIME_TIM_IDX" ON "SYS"."SMON_SCN_TIME" ("TIME_MP") tablespace sysaux;
SQL> CREATE UNIQUE INDEX "SYS"."SMON_SCN_TIME_SCN_IDX" ON "SYS"."SMON_SCN_TIME" ("SCN") tablespace sysaux;

再次驗證，物件已恢復正常。
SQL> Analyze table SYS.SMON_SCN_TIME validate structure cascade online ; 

Table analyzed.



可參考METALINK：
Instance Terminated With Error ORA-00474: SMON Process Terminated With Error (文件 ID 1361872.1)
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=421598097050611&id=1361872.1&displayIndex=2&_afrWindowMode=0&_adf.ctrl-state=vtmrhkpov_183

How to resolve ORA-00600 [13013], [5001] (文件 ID 816784.1)
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=422436266526312&id=816784.1&displayIndex=4&_afrWindowMode=0&_adf.ctrl-state=vtmrhkpov_330#aref_section22

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17086096/viewspace-1973750/，如需轉載，請註明出處，否則將追究法律責任。

相關文章