ORA-600 kccpb_sanity_check_2处理----惜分飞

数据库启动报ORA-600 kccpb_sanity_check_2

SQL> startup mount pfile='d:/pfile.txt' ORACLE 例程已经启动。 Total System Global Area 1258291200 bytes Fixed Size                  1250548 bytes Variable Size             243272460 bytes Database Buffers         1006632960 bytes Redo Buffers                7135232 bytes ORA-00600: ??????, ??: [kccpb_sanity_check_2], [66014], [66011], [0x0], [], [],[], []

重建控制文件报错ora-600 kccsga_update_amx_1

SQL> CREATE CONTROLFILE REUSE DATABASE "zs" NORESETLOGS  NOARCHIVELOG   2      MAXLOGFILES 50   3      MAXLOGMEMBERS 5   4      MAXDATAFILES 100   5      MAXINSTANCES 8   6      MAXLOGHISTORY 226   7  LOGFILE   8    GROUP 1 'd:\zs\redo01.log'  SIZE 50M,   9    GROUP 2 'd:\zs\redo02.log'  SIZE 50M,  10    GROUP 3 'd:\zs\redo03.log'  SIZE 50M  11  DATAFILE  12  'd:\zs\SYSAUX01.DBF', ………………  22  'd:\zs\SYSTEM01.DBF',  23  'd:\zs\UNDOTBS01.DBF',  24  'd:\zs\USERS01.DBF'  25  CHARACTER SET zhs16gbk  26  ; CREATE CONTROLFILE REUSE DATABASE "zs" NORESETLOGS  NOARCHIVELOG * 第 1 行出现错误: ORA-01503: CREATE CONTROLFILE ?? ORA-00600: ??????, ??: [kccsga_update_amx_1], [9], [2920], [292], [], [], [],[]

重启实例，重建ctl成功.尝试恢复库提示需要很久之前的日志，因为有两个数据文件scn异常

---

 

通过oracle recovery tools修改文件头

---

 

再次recover数据库成功顺利open库导出客户需要数据