数据库意外宕机,归档开了,但是归档文件损坏,redo损坏,在强行拉起来之后UNDO报错,设置_corrupted_rollback_segments 跳过不一致的UNDO,重建UNOD表空间,接着报错:SMON encountered 100 out of maximum 100 non-fatal internal errors. 然后数据库自动宕机,报错处理如下:
1ORA-00600: internal error code,arguments: [13013],[5001],[458],[4197442],[6],[3],[],[]
Arg [a] Passcount 错误代码5001
Arg [b] Data Object number 即object_id=458
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 3 update~~
select object_name,owner,object_type from dba_objects where object_id=458 analyze table mon_mods$ validate structure cascade; ALTER INDEX I_MON_MODS$_OBJ REBUILD; create table mod_mods_bak as select * from mon_mods$; truncate table mon_mods$; INSERT INTO MON_MODS$ SELECT * fROM MON_MODS_BAK; select count(*) from mon_mods$;
2 OBJD=267 smon_scn_time报错
Corrupt Block Found
TSN = 1,TSNAME = SYSAUX
RFN = 2,BLK = 133475,RDBA = 8522083
OBJN = 269,OBJD = 267,OBJECT =,SUBOBJECT =
SEGMENT OWNER =,SEGMENT TYPE =
select object_name,object_type from dba_objects where object_id=267; analyze table SMON_SCN_TIME validate structure cascade;
果断报错
select dbms_Metadata.get_ddl('CLUSTER','SMON_SCN_TO_TIME_AUX','SYS') from dual; CREATE CLUSTER "SYS"."SMON_SCN_TO_TIME_AUX" ( "THREAD" NUMBER ) PCTFREE 10 PCTUSED 40 INITRANS 2 MAXTRANS 255 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" PARALLEL (DEGREE 1 INSTANCES 1) select dbms_Metadata.get_ddl('TABLE','SMON_SCN_TIME','SYS') from dual;
CREATE TABLE SYS.SMON_SCN_TIME ( THREAD NUMBER,TIME_MP NUMBER,TIME_DP DATE,SCN_WRP NUMBER,SCN_BAS NUMBER,NUM_MAPPINGS NUMBER,TIM_SCN_MAP RAW(1200),SCN NUMBER DEFAULT 0,ORIG_THREAD NUMBER DEFAULT 0 /* for downgrade */ ) NOCOMPRESS CLUSTER SYS.SMON_SCN_TO_TIME_AUX(THREAD);
3 ORA-00600: internal error code,arguments: [kkpolpd7],[1403],[
],[]
ORA-00600: internal error code,arguments: [kewrose_1],[600]由这个错误产生,mmon进程有关,非关键进程,可以杀掉重启,