ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-00600: internal error code, arguments: [1433], [60], [], [], [], [], [], []

ORA-00600: internal error code, arguments: [1433], [60], [], [], [], [], [], []

原创 Linux操作系统 作者:dcswinner 时间:2013-07-22 10:57:33 0 删除 编辑
今天检查数据库,发现alert日志出现如下错误:
Errors in file /oracle/app/oracle/diag/rdbms/ssdhr/ssdhr1/trace/ssdhr1_arc3_10122.trc  (incident=38753):
ORA-00600: 内部错误代码, 参数: [1433], [60], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracle/app/oracle/diag/rdbms/ssdhr/ssdhr1/incident/incdir_38753/ssdhr1_arc3_10122_i38753.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Fri Jul 19 19:55:06 2013
Errors in file /oracle/app/oracle/diag/rdbms/ssdhr/ssdhr1/trace/ssdhr1_mmon_10075.trc:
Fri Jul 19 19:55:09 2013
Dumping diagnostic data in directory=[cdmp_20130719195509], requested by (instance=1, sid=10075 (MMON)), summary=[abnormal process termination].
Fri Jul 19 19:55:09 2013
Errors in file /oracle/app/oracle/diag/rdbms/ssdhr/ssdhr1/trace/ssdhr1_ora_3342.trc  (incident=38921):
ORA-00600: internal error code, arguments: [1433], [60], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracle/app/oracle/diag/rdbms/ssdhr/ssdhr1/incident/incdir_38921/ssdhr1_ora_3342_i38921.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /oracle/app/oracle/diag/rdbms/ssdhr/ssdhr1/trace/ssdhr1_mmon_10075.trc:
Fri Jul 19 19:55:11 2013
Errors in file /oracle/app/oracle/diag/rdbms/ssdhr/ssdhr1/trace/ssdhr1_ora_3313.trc  (incident=38865):
ORA-00600: 内部错误代码, 参数: [1433], [60], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracle/app/oracle/diag/rdbms/ssdhr/ssdhr1/incident/incdir_38865/ssdhr1_ora_3313_i38865.trc
另外发现还有另外的异常日志:
*************************************************************
ARC3: Error 19504 Creating archive log file to '+DATA'
Errors in file /oracle/app/oracle/diag/rdbms/ssdhr/ssdhr1/trace/ssdhr1_arc3_10122.trc:
ORA-19816: 警告: 文件可能存在于数据库未知的 db_recovery_file_dest 中。
ORA-17502: ksfdcre: 4 未能创建文件 +DATA
ORA-15041: diskgroup "DATA" space exhausted
*************************************************************
WARNING: A file of type ARCHIVED LOG may exist in
db_recovery_file_dest that is not known to the database.
Use the RMAN command CATALOG RECOVERY AREA to re-catalog
any such files. If files cannot be cataloged, then manually
delete them using OS command. This is most likely the
result of a crash during file creation.
*************************************************************
ARC3: Error 19504 Creating archive log file to '+DATA'
Errors in file /oracle/app/oracle/diag/rdbms/ssdhr/ssdhr1/trace/ssdhr1_arc1_10118.trc:
ORA-19816: 警告: 文件可能存在于数据库未知的 db_recovery_file_dest 中。
ORA-17502: ksfdcre: 4 未能创建文件 +DATA
ORA-15041: diskgroup "DATA" space exhausted
*************************************************************
WARNING: A file of type ARCHIVED LOG may exist in
db_recovery_file_dest that is not known to the database.
Use the RMAN command CATALOG RECOVERY AREA to re-catalog
any such files. If files cannot be cataloged, then manually
delete them using OS command. This is most likely the
result of a crash during file creation.
*************************************************************
通过以上日志分析,立刻知道应该是由于磁盘组空间满了,不能归档,导致的数据异常。
查看:
v$recovery_file_dest发现闪回区空间只剩下20M了,另外查看gv$asm_diskgroup,发现磁盘组的空间还剩80来G,因此可以通过修改参数:db_recovery_file_dest_size来扩大闪回区的大小:
alter system set db_recovery_file_dest_size=150G scope=both sid='*';
数据库归档能继续了,但是为了归档再次满了,应该利用午饭时间数据库业务不忙的时候,对数据库进行备份,备份完后将旧的规归档删掉。
至于归档满了,为何能导致600错误,请查案mos:
Archiving Destination Full Causing ORA-600 [1433],[60] and Instance Crash (Doc ID 748885.1)
ORA-00600 [1433] [60] and Instance Crash by ARCH Process (Doc ID 1467091.1)

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

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

注册时间:2009-04-03

  • 博文量
    61
  • 访问量
    504414