ITPub博客

首页 > 数据库 > Oracle > 关于ora-00600[6006]引发的一系列问题

关于ora-00600[6006]引发的一系列问题

原创 Oracle 作者:jijyoracle 时间:2016-02-18 13:44:57 0 删除 编辑
早晨上班,某友友给我看了一份alter报错()
ORACLE Instance yfsd (pid = 13) - Error 600 encountered while recovering transaction (1, 12) on object 6374.
Errors in file /u01/app/diag/rdbms/yfsd/yfsd/trace/yfsd_smon_18587.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], [], [], [], [], []
参考盖总的文章:
http://www.eygle.com/archives/2011/07/ora-600_6006_recovery.html

看到object_id:
select owner,object_name,object_type from dba_objects where object_id=6374
SYS    WRH$_SYSMETRIC_HISTORY_INDEX    INDEX
select table_name from dba_indexes where index_name='WRH$_SYSMETRIC_HISTORY_INDEX'
WRH$_SYSMETRIC_HISTORY
考虑尝试重建索引:
 alter index WRH$_SYSMETRIC_HISTORY_INDEX rebuild

不巧,这是个oracle的系统基表,当我想问下友友有没有备份的时候,友友已经把这个索引给drop了,竟然没有看是不是特殊对象直接drop!导致下面各种600,花样作死详情如下:
Completed: ALTER DATABASE OPEN
Errors in file /u01/app/diag/rdbms/yfsd/yfsd/trace/yfsd_p000_29219.trc  (incident=74825):
ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xB6C3DBD4], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [0xB6C3DBDC], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/diag/rdbms/yfsd/yfsd/incident/incdir_74825/yfsd_p000_29219_i74825.trc
Block recovery redo apply failed on file 2 block 59560
Block recovery logically corrupted file 2 block 59560
Errors in file /u01/app/diag/rdbms/yfsd/yfsd/trace/yfsd_p000_29219.trc  (incident=74826):
ORA-01578: ORACLE data block corrupted (file # 2, block # 59560)
ORA-01110: data file 2: '/u01/app/oradata/yfsd/sysaux01.dbf'
ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xB6C3DBD4], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [0xB6C3DBDC], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/diag/rdbms/yfsd/yfsd/incident/incdir_74826/yfsd_p000_29219_i74826.trc
Trace dumping is performing id=[cdmp_20160218101802]
Errors in file /u01/app/diag/rdbms/yfsd/yfsd/trace/yfsd_p000_29219.trc:
ORA-01578: ORACLE data block corrupted (file # 2, block # 59560)
ORA-01110: data file 2: '/u01/app/oradata/yfsd/sysaux01.dbf'
ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xB6C3DBD4], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [0xB6C3DBDC], [], [], [], [], [], [], [], [], [], []
Block recovery completed at rba 716.9537.16, scn 0.129172418
Errors in file /u01/app/diag/rdbms/yfsd/yfsd/trace/yfsd_p000_29219.trc  (incident=74827):
ORA-00600: internal error code, arguments: [KSMFPG2], [0xB6C3D000], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [0xB6C3DBDC], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/diag/rdbms/yfsd/yfsd/incident/incdir_74827/yfsd_p000_29219_i74827.trc
Errors in file /u01/app/diag/rdbms/yfsd/yfsd/trace/yfsd_p000_29219.trc:
ORA-00600: internal error code, arguments: [KSMFPG2], [0xB6C3D000], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [0xB6C3DBDC], [], [], [], [], [], [], [], [], [], []
Errors in file /u01/app/diag/rdbms/yfsd/yfsd/trace/yfsd_p000_29219.trc  (incident=74828):
ORA-00600: internal error code, arguments: [KGHALO4], [0x106CF6E0], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [KSMFPG2], [0xB6C3D000], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [0xB6C3DBDC], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/diag/rdbms/yfsd/yfsd/incident/incdir_74828/yfsd_p000_29219_i74828.trc
Thu Feb 18 10:18:03 2016
Sweep [inc][74826]: completed
Errors in file /u01/app/diag/rdbms/yfsd/yfsd/trace/yfsd_p000_29219.trc:
ORA-00600: internal error code, arguments: [KGHALO4], [0x106CF6E0], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [KSMFPG2], [0xB6C3D000], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [0xB6C3DBDC], [], [], [], [], [], [], [], [], [], []
Errors in file /u01/app/diag/rdbms/yfsd/yfsd/trace/yfsd_p000_29219.trc  (incident=74829):
ORA-00600: internal error code, arguments: [KGHALO4], [0x106CF6E0], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [KSMFPG2], [0xB6C3D000], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [0xB6C3DBDC], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/diag/rdbms/yfsd/yfsd/incident/incdir_74829/yfsd_p000_29219_i74829.trc
Thu Feb 18 10:18:04 2016
Trace dumping is performing id=[cdmp_20160218101804]
Errors in file /u01/app/diag/rdbms/yfsd/yfsd/trace/yfsd_p000_29219.trc:
ORA-00600: internal error code, arguments: [KGHALO4], [0x106CF6E0], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [KSMFPG2], [0xB6C3D000], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [0xB6C3DBDC], [], [], [], [], [], [], [], [], [], []
Errors in file /u01/app/diag/rdbms/yfsd/yfsd/trace/yfsd_p000_29219.trc  (incident=74830):
ORA-00600: internal error code, arguments: [KGHFRE2], [0xB6C3CFF4], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [KSMFPG2], [0xB6C3D000], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [0xB6C3DBDC], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/diag/rdbms/yfsd/yfsd/incident/incdir_74830/yfsd_p000_29219_i74830.trc
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x1903091F] [PC:0xF37828D, kghrst()+143] [flags: 0x0, count: 1]
Errors in file /u01/app/diag/rdbms/yfsd/yfsd/trace/yfsd_p000_29219.trc  (incident=74831):
ORA-07445: exception encountered: core dump [kghrst()+143] [SIGSEGV] [ADDR:0x1903091F] [PC:0xF37828D] [Address not mapped to object] []
ORA-00600: internal error code, arguments: [KGHFRE2], [0xB6C3CFF4], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [KSMFPG2], [0xB6C3D000], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17182], [0xB6C3DBDC], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/diag/rdbms/yfsd/yfsd/incident/incdir_74831/yfsd_p000_29219_i74831.trc
Trace dumping is performing id=[cdmp_20160218101805]
Checker run found 1 new persistent data failures
Thu Feb 18 10:18:45 2016
DM00 started with pid=28, OS id=29279, job SYSTEM.POSP1
Thu Feb 18 10:18:52 2016
SMON: slave died unexpectedly, downgrading to serial recovery
Errors in file /u01/app/diag/rdbms/yfsd/yfsd/trace/yfsd_smon_29184.trc  (incident=74768):
ORA-01578: ORACLE data block corrupted (file # 2, block # 59560)
ORA-01110: data file 2: '/u01/app/oradata/yfsd/sysaux01.dbf'
Incident details in: /u01/app/diag/rdbms/yfsd/yfsd/incident/incdir_74768/yfsd_smon_29184_i74768.trc
ORACLE Instance yfsd (pid = 13) - Error 1578 encountered while recovering transaction (1, 12) on object 6373.
Errors in file /u01/app/diag/rdbms/yfsd/yfsd/trace/yfsd_smon_29184.trc:
ORA-01578: ORACLE data block corrupted (file # 2, block # 59560)
ORA-01110: data file 2: '/u01/app/oradata/yfsd/sysaux01.dbf'
之前还没有坏块的?怎么突然出坏块了
select owner from dba_extents where file_id=2 and block_id=59560;
 WRH$_SYSMETRIC_HISTORY_INDEX 
因为之前没有这个坏块,是他删除这个基表的索引这话报的错,现在sysaux01.df系统表空间损失,问是否有备份?没有。

于是友友想到导出应用对象,重建库。这个可以有,在使用数据泵导数据的时候报错(在mos找的一个):
ORA-39006: internal error
ORA-39213: Metadata processing is not available
mos给出的解决方案是:
Run again sys.dbms_metadata_util.load_stylesheets from sqlplus:
connect / as sysdba
execute sys.dbms_metadata_util.load_stylesheets;

sys.dbms_metadata_util.load_stylesheets;:重新加载样式表的权限
During dbms_metadata_util.load_stylesheets we read the directory $ORACLE_HOME/rdbms/xml/xsl and load the XSL files using DBMS_LOB package.

If the files cannot be read (most of cases by missing rwx privileges for oracle user), then we raise the errors above.

Re-load the stylesheets using the dbms_metadata_util.load_stylesheets procedure after the permission issue is solved and then retry DataPump import (impdp).

解决。


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30536096/viewspace-1990546/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2016-01-15

  • 博文量
    25
  • 访问量
    61114