oracle 宕机后文件损坏resetlogs后处理

前端之家收集整理的这篇文章主要介绍了oracle 宕机后文件损坏resetlogs后处理前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

数据库意外宕机,归档开了,但是归档文件损坏,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进程有关,非关键进程,可以杀掉重启,

原文链接:https://www.f2er.com/oracle/205913.html

猜你在找的Oracle相关文章