Problém:
Wed May 03 07:00:57 2017 Errors in file /oracle/oraspis/diag/rdbms/orcl/orcl/trace/orcl_j000_25092.trc (incident=670713): ORA-00600: kód vnitřní chyby, argumenty: [13011], [210842], [8609317], [7], [8566307], [0], [], [], [], [], [], [] Incident details in: /oracle/oraorcl/diag/rdbms/orcl/orcl/incident/incdir_670713/orcl_j000_25092_i670713.trc Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details.
Analýza:
SYS@orcl> select object_name,object_type,owner from dba_objects where data_object_id=210842; OBJECT_NAME OBJECT_TYPE OWNER ----------------------------------- ------------------------- --------------- MGMT_SYSTEM_PERFORMANCE_LOG TABLE SYSMAN SYS@orcl> analyze table sysman.MGMT_SYSTEM_PERFORMANCE_LOG validate structure cascade; analyze table sysman.MGMT_SYSTEM_PERFORMANCE_LOG validate structure cascade * ERROR na radku 1: ORA-08100: neplatny index - diagnostiku najdete v sledovacim souboru
Řešení:
SYS@orcl> select index_name from dba_indexes where table_name = 'MGMT_SYSTEM_PERFORMANCE_LOG';
INDEX_NAME
-------------------------
MGMT_SYSTEM_PERF_LOG_IDX_01
MGMT_SYSTEM_PERF_LOG_IDX_02
SYS@orcl> set heading off
set echo off
set flush off
set pagesize 9999
set linesize 9999
set long 9999
SYS@orcl> select dbms_metadata.get_ddl('INDEX', 'MGMT_SYSTEM_PERF_LOG_IDX_01', 'SYSMAN') from dual;
CREATE INDEX "SYSMAN"."MGMT_SYSTEM_PERF_LOG_IDX_01" ON "SYSMAN"."MGMT_SYSTEM_PERFORMANCE_LOG" ("JOB_NAME", "TIME", "NAME")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS COMPRESS 3
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"
SYS@orcl> select dbms_metadata.get_ddl('INDEX', 'MGMT_SYSTEM_PERF_LOG_IDX_02', 'SYSMAN') from dual;
CREATE INDEX "SYSMAN"."MGMT_SYSTEM_PERF_LOG_IDX_02" ON "SYSMAN"."MGMT_SYSTEM_PERFORMANCE_LOG" ("TIME")
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"
SYS@orcl> drop index sysman.MGMT_SYSTEM_PERF_LOG_IDX_01;
Index zrusen.
SYS@orcl> drop index sysman.MGMT_SYSTEM_PERF_LOG_IDX_02;
Index zrusen.
SYS@orcl> CREATE INDEX "SYSMAN"."MGMT_SYSTEM_PERF_LOG_IDX_01" ON "SYSMAN"."MGMT_SYSTEM_PERFORMANCE_LOG" ("JOB_NAME", "TIME", "NAME")
2 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS COMPRESS 3
3 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
4 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
5 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
6 TABLESPACE "SYSAUX";
Index vytvoren.
SYS@orcl> CREATE INDEX "SYSMAN"."MGMT_SYSTEM_PERF_LOG_IDX_02" ON "SYSMAN"."MGMT_SYSTEM_PERFORMANCE_LOG" ("TIME")
2 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
3 4 5 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
6 TABLESPACE "SYSAUX";
Index vytvoren.
SYS@orcl> analyze table sysman.MGMT_SYSTEM_PERFORMANCE_LOG validate structure cascade;
Tabulka analyzovana.
MOS
ORA-00600 [13011] (Doc ID 1547827.1)
ORA-00600 [13011] when delete from MGMT_SYSTEM_PERFORMANCE_LOG table (Doc ID 2227027.1)