联系:手机/微信(+86 17813235971) QQ(107644445)
作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
关于tab$异常的问题,我们在10G(10g数据库遭遇ORA-600 16703),11G(警告:互联网中有oracle介质被注入恶意程序导致—ORA-600 16703)中有发现,近期在12C版本中也发现该问题.再次提醒请注意检查安装介质的md5值和现在运行的库中是否有相关恶意程序
数据库版本
alert日志报错
************************************************************ Warning: The SCN headroom for this database is only 45 days! ************************************************************ ************************************************************ Warning: The SCN headroom for this database is only 45 days! ************************************************************ Picked broadcast on commit scheme to generate SCNs Fri Jan 25 11:34:55 2019 Starting background process TMON Fri Jan 25 11:34:55 2019 TMON started with pid=104, OS id=47282 Fri Jan 25 11:34:55 2019 Thread 1 advanced to log sequence 11942 (thread open) Thread 1 opened at log sequence 11942 Current log# 5 seq# 11942 mem# 0: +DATA/xifenfei/ONLINELOG/redo01_01.log Successful open of redo thread 1 Fri Jan 25 11:34:55 2019 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Fri Jan 25 11:34:55 2019 Network Resource Management enabled for Process LG00 (pid 451491) for Exadata I/O Fri Jan 25 11:34:55 2019 SMON: enabling cache recovery Errors in file /u01/oracle/app/oracle/diag/rdbms/xifenfei/xifenfei1/trace/xifenfei1_ora_46443.trc (incident=394486): ORA-00600: internal error code, arguments: [16703], [1403], [20], [], [], [], [], [], [], [], [], [] Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Fri Jan 25 11:34:56 2019 Errors in file /u01/oracle/app/oracle/diag/rdbms/xifenfei/xifenfei1/trace/xifenfei1_ora_46443.trc: ORA-00704: bootstrap process failure ORA-00600: internal error code, arguments: [16703], [1403], [20], [], [], [], [], [], [], [], [], [] Fri Jan 25 11:34:56 2019 Errors in file /u01/oracle/app/oracle/diag/rdbms/xifenfei/xifenfei1/trace/xifenfei1_ora_46443.trc: ORA-00704: bootstrap process failure ORA-00704: bootstrap process failure ORA-00600: internal error code, arguments: [16703], [1403], [20], [], [], [], [], [], [], [], [], [] Fri Jan 25 11:34:56 2019 Errors in file /u01/oracle/app/oracle/diag/rdbms/xifenfei/xifenfei1/trace/xifenfei1_ora_46443.trc: ORA-00704: bootstrap process failure ORA-00704: bootstrap process failure ORA-00600: internal error code, arguments: [16703], [1403], [20], [], [], [], [], [], [], [], [], [] Fri Jan 25 11:34:56 2019 Error 704 happened during db open, shutting down database USER (ospid: 46443): terminating the instance due to error 704 Fri Jan 25 11:34:57 2019 Instance terminated by USER, pid = 46443
处理思路基本上和其他两个版本一样,都是对tab$进行修复,然后直接open数据库,但是在这次的恢复中遇到ORA-00600 kdfReserveSingle_1错误
ORA-600 kdfReserveSingle_1
SQL> alter database open ; alter database open * ERROR at line 1: ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00600: internal error code, arguments: [kdfReserveSingle_1], [0], [65280], [], [], [], [], [], [], [], [], [] Process ID: 319852 Session ID: 2401 Serial number: 24555 ---alert日志 Starting background process TMON Fri Jan 25 20:51:41 2019 TMON started with pid=94, OS id=322554 Fri Jan 25 20:51:41 2019 Thread 1 advanced to log sequence 11943 (thread open) Thread 1 opened at log sequence 11943 Current log# 6 seq# 11943 mem# 0: +DATA/xifenfei/ONLINELOG/redo02_01.log Successful open of redo thread 1 Fri Jan 25 20:51:41 2019 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Fri Jan 25 20:51:41 2019 Network Resource Management enabled for Process LG00 (pid 319754) for Exadata I/O Fri Jan 25 20:51:41 2019 SMON: enabling cache recovery Fri Jan 25 20:51:41 2019 [319852] Successfully onlined Undo Tablespace 2. Undo initialization finished serial:0 start:88159754 end:88160264 diff:510 ms (0.5 seconds) Verifying minimum file header compatibility (11g) for tablespace encryption.. Verifying 11g file header compatibility for tablespace encryption completed Fri Jan 25 20:51:41 2019 SMON: enabling tx recovery Fri Jan 25 20:51:41 2019 Database Characterset is ZHS16GBK Errors in file /u01/oracle/app/oracle/diag/rdbms/xifenfei/xifenfei1/trace/xifenfei1_ora_319852.trc (incident=466446): ORA-00600: internal error code, arguments: [kdfReserveSingle_1], [0], [65280], [], [], [], [], [], [], [], [], [] Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Fri Jan 25 20:51:42 2019 Errors in file /u01/oracle/app/oracle/diag/rdbms/xifenfei/xifenfei1/trace/xifenfei1_ora_319852.trc: ORA-00600: internal error code, arguments: [kdfReserveSingle_1], [0], [65280], [], [], [], [], [], [], [], [], [] Fri Jan 25 20:51:42 2019 Errors in file /u01/oracle/app/oracle/diag/rdbms/xifenfei/xifenfei1/trace/xifenfei1_ora_319852.trc: ORA-00600: internal error code, arguments: [kdfReserveSingle_1], [0], [65280], [], [], [], [], [], [], [], [], [] Error 600 happened during db open, shutting down database USER (ospid: 319852): terminating the instance due to error 600 Fri Jan 25 20:51:43 2019 Instance terminated by USER, pid = 319852 ORA-1092 signalled during: alter database open… opiodr aborting process unknown ospid (319852) as a result of ORA-1092 Fri Jan 25 20:51:49 2019 ORA-1092 : opitsk aborting process
这个错误主要是由于12c的tab$和以前版本比有一些特殊,导致开始恢复不全,通过继续修复tab$之后数据库正常open.
相关文章汇总
tab$恢复错误汇总
12C数据库遭遇ORA-600 16703
10G数据库遭遇ORA-600 16703
ORA-600 16703故障解析—tab$表被清空
警告:互联网中有oracle介质被注入恶意程序导致—ORA-600 16703