注册登录
提 问
English中文版
系统集成Oracle解决办法跟踪日志

oracle跟踪日志生成问题

请教一下各位大神，最近某个单位有台IBM小型机的oracle数据库有点异常：只要有业务操作，就会产生大量跟踪日志文件，经常导致文件系统被写满，以下为oracle日志文件里面的前200条日志信息，请教一下各位，这究竟是什么情况：

# tail -n 200 alert_ITMSDB.log

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1597640.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3265797862], [], [],

[], [], []

Mon Jun 27 06:57:05 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1581270.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3265797863], [], [],

[], [], []

Mon Jun 27 06:57:22 2016

Thread 1 advanced to log sequence 510239

  Current log# 18 seq# 510239 mem# 0: /dataits/disk1/itms/redo18.log

Mon Jun 27 06:57:29 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1531978.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3265911334], [], [],

[], [], []

Mon Jun 27 06:57:35 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1597648.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3265911411], [], [],

[], [], []

Mon Jun 27 06:57:44 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1597650.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3265911631], [], [],

[], [], []

Mon Jun 27 06:58:03 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1306858.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3265911976], [], [],

[], [], []

Mon Jun 27 06:58:23 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1531996.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3266301761], [], [],

[], [], []

Mon Jun 27 06:58:37 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1454170.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3266319328], [], [],

[], [], []

Mon Jun 27 06:58:59 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1454176.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3266319486], [], [],

[], [], []

Mon Jun 27 06:59:48 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1454188.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3266786753], [], [],

[], [], []

Mon Jun 27 06:59:59 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1490980.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3266786759], [], [],

[], [], []

Mon Jun 27 07:00:08 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1490986.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3266786762], [], [],

[], [], []

Mon Jun 27 07:00:32 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1626288.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3266967557], [], [],

[], [], []

Mon Jun 27 07:00:52 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1490996.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3267139185], [], [],

[], [], []

Mon Jun 27 07:01:00 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1491002.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3267139189], [], [],

[], [], []

Mon Jun 27 07:01:29 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_815130.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3267199828], [], [],

[], [], []

Mon Jun 27 07:01:44 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_815134.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3267199834], [], [],

[], [], []

Mon Jun 27 07:02:05 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1581090.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3267402224], [], [],

[], [], []

Mon Jun 27 07:02:11 2016

Thread 1 advanced to log sequence 510240

  Current log# 20 seq# 510240 mem# 0: /dataits/disk1/itms/redo20.log

Mon Jun 27 07:02:34 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_815156.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3267515422], [], [],

[], [], []

Mon Jun 27 07:02:37 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1581104.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3267515423], [], [],

[], [], []

Mon Jun 27 07:02:47 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1581108.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3267515473], [], [],

[], [], []

Mon Jun 27 07:02:50 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1491034.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3267621934], [], [],

[], [], []

Mon Jun 27 07:02:54 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1581118.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3267621935], [], [],

[], [], []

Mon Jun 27 07:03:30 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_815170.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3267946236], [], [],

[], [], []

Mon Jun 27 07:03:45 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1581138.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3267995246], [], [],

[], [], []

Mon Jun 27 07:03:51 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1613924.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3267995248], [], [],

[], [], []

Mon Jun 27 07:03:53 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1581142.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3267995248], [], [],

[], [], []

Mon Jun 27 07:04:00 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1613926.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3267995305], [], [],

[], [], []

Mon Jun 27 07:04:12 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1532046.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3267995313], [], [],

[], [], []

Mon Jun 27 07:04:19 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1532048.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3267995335], [], [],

[], [], []

Mon Jun 27 07:04:46 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1548468.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3267995346], [], [],

[], [], []

Mon Jun 27 07:04:50 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1532058.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3267995348], [], [],

[], [], []

Mon Jun 27 07:04:52 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1548472.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3267995348], [], [],

[], [], []

Mon Jun 27 07:04:53 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1626354.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3267995349], [], [],

[], [], []

Mon Jun 27 07:05:27 2016

Errors in file /opt/database/admin/itmsdb/udump/itmsdb_ora_1532066.trc:

ORA-00600: internal error code, arguments: [2252], [3492], [3268575461], [], [],

[], [], []

Mon Jun 27 07:08:25 2016

Thread 1 advanced to log sequence 510241

  Current log# 4 seq# 510241 mem# 0: /dataits/disk1/itms/redo04.log

Mon Jun 27 07:10:57 2016

Thread 1 advanced to log sequence 510242

  Current log# 1 seq# 510242 mem# 0: /dataits/disk1/itms/redo01.log

Mon Jun 27 07:13:20 2016

Thread 1 advanced to log sequence 510243

  Current log# 2 seq# 510243 mem# 0: /dataits/disk1/itms/redo02.log

Mon Jun 27 07:15:08 2016

Thread 1 advanced to log sequence 510244

  Current log# 3 seq# 510244 mem# 0: /dataits/disk1/itms/redo03.log

Mon Jun 27 07:16:53 2016

Thread 1 advanced to log sequence 510245

  Current log# 5 seq# 510245 mem# 0: /dataits/disk1/itms/redo05.log

Mon Jun 27 07:19:44 2016

Thread 1 advanced to log sequence 510246

  Current log# 6 seq# 510246 mem# 0: /dataits/disk1/itms/redo06.log

Mon Jun 27 07:22:35 2016

Thread 1 advanced to log sequence 510247

  Current log# 7 seq# 510247 mem# 0: /dataits/disk1/itms/redo07.log

Mon Jun 27 07:25:06 2016

Thread 1 advanced to log sequence 510248

  Current log# 8 seq# 510248 mem# 0: /dataits/disk1/itms/redo08.log

Mon Jun 27 07:27:56 2016

Thread 1 advanced to log sequence 510249

  Current log# 9 seq# 510249 mem# 0: /dataits/disk1/itms/redo09.log

Mon Jun 27 07:30:49 2016

Thread 1 advanced to log sequence 510250

  Current log# 10 seq# 510250 mem# 0: /dataits/disk1/itms/redo10.log

Mon Jun 27 07:33:44 2016

Thread 1 advanced to log sequence 510251

  Current log# 12 seq# 510251 mem# 0: /dataits/disk1/itms/redo12.log

Mon Jun 27 07:40:02 2016

Thread 1 advanced to log sequence 510252

  Current log# 11 seq# 510252 mem# 0: /dataits/disk1/itms/redo11.log

Mon Jun 27 07:46:19 2016

Thread 1 advanced to log sequence 510253

  Current log# 13 seq# 510253 mem# 0: /dataits/disk1/itms/redo13.log

Mon Jun 27 07:52:17 2016

Thread 1 advanced to log sequence 510254

  Current log# 14 seq# 510254 mem# 0: /dataits/disk1/itms/redo14.log

Mon Jun 27 07:58:48 2016

Thread 1 advanced to log sequence 510255

  Current log# 15 seq# 510255 mem# 0: /dataits/disk1/itms/redo15.log

Mon Jun 27 08:05:08 2016

Thread 1 advanced to log sequence 510256

  Current log# 16 seq# 510256 mem# 0: /dataits/disk1/itms/redo16.log

Mon Jun 27 08:11:18 2016

Thread 1 advanced to log sequence 510257

  Current log# 17 seq# 510257 mem# 0: /dataits/disk1/itms/redo17.log

Mon Jun 27 08:17:50 2016

Thread 1 advanced to log sequence 510258

  Current log# 19 seq# 510258 mem# 0: /dataits/disk1/itms/redo19.log

Mon Jun 27 08:23:57 2016

Thread 1 advanced to log sequence 510259

  Current log# 18 seq# 510259 mem# 0: /dataits/disk1/itms/redo18.log

Mon Jun 27 08:29:52 2016

Thread 1 advanced to log sequence 510260

  Current log# 20 seq# 510260 mem# 0: /dataits/disk1/itms/redo20.log

Mon Jun 27 08:36:16 2016

Thread 1 advanced to log sequence 510261

  Current log# 4 seq# 510261 mem# 0: /dataits/disk1/itms/redo04.log

Mon Jun 27 08:38:48 2016

Thread 1 advanced to log sequence 510262

  Current log# 1 seq# 510262 mem# 0: /dataits/disk1/itms/redo01.log

Mon Jun 27 08:41:26 2016

Thread 1 advanced to log sequence 510263

  Current log# 2 seq# 510263 mem# 0: /dataits/disk1/itms/redo02.log

Mon Jun 27 08:44:01 2016

Thread 1 advanced to log sequence 510264

  Current log# 3 seq# 510264 mem# 0: /dataits/disk1/itms/redo03.log

Mon Jun 27 08:46:19 2016

Thread 1 advanced to log sequence 510265

  Current log# 5 seq# 510265 mem# 0: /dataits/disk1/itms/redo05.log

Mon Jun 27 08:48:53 2016

Thread 1 advanced to log sequence 510266

  Current log# 6 seq# 510266 mem# 0: /dataits/disk1/itms/redo06.log

Mon Jun 27 08:51:00 2016

Thread 1 advanced to log sequence 510267

  Current log# 7 seq# 510267 mem# 0: /dataits/disk1/itms/redo07.log

Mon Jun 27 08:53:45 2016

Thread 1 advanced to log sequence 510268

  Current log# 8 seq# 510268 mem# 0: /dataits/disk1/itms/redo08.log

Mon Jun 27 08:56:36 2016

Thread 1 advanced to log sequence 510269

  Current log# 9 seq# 510269 mem# 0: /dataits/disk1/itms/redo09.log

Mon Jun 27 08:59:34 2016

Thread 1 advanced to log sequence 510270

  Current log# 10 seq# 510270 mem# 0: /dataits/disk1/itms/redo10.log

#

#

关注3
评论
参与13

3同行回答
|
按赞同排序
按时间排序

itdreamflyitdreamfly数据库管理员南昌
临时关闭trace日志产生： alter system set trace_enabled = false;查看数据库版本是否为：11.2.0.211.2.0.111.1.0.7如果存在上述版本建议小版本升级数据库。查看AIX系统时间和数据库的时间是否一致，如果不一致，建议重置AIX系统时间。...显示全部

临时关闭trace日志产生：

alter system set trace_enabled = false;

查看数据库版本是否为：

11.2.0.211.2.0.111.1.0.7

如果存在上述版本建议小版本升级数据库。

查看AIX系统时间和数据库的时间是否一致，如果不一致，建议重置AIX系统时间。

收起
系统集成 · 2016-06-28
浏览2604
查看赞同的人
评论
lscomeonlscomeon其它收割者
数据库版本发一下这种错误尽快解决最好 ORA-600 [2252] can be reported when the system time has been changed  or is very different from what the database is aware of.  If the Known Issues section below does not help in terms of ident...显示全部

数据库版本发一下

这种错误尽快解决最好

 ORA-600 [2252] can be reported when the system time has been changed  or is very different from what the database is aware of.  If the Known Issues section below does not help in terms of identifying  a solution, please submit the trace files and alert.log to Oracle   Support Services for further analysis.
收起
国防军队 · 2016-06-28
浏览2466
查看赞同的人
评论
草榴君草榴君网络工程师某某科技公司
[此回答已删除]
浏览2001
评论

提问者

草榴君
草榴君003
网络工程师某某科技公司
擅长领域： 存储，灾备，软件定义存储
关注
回答16
评论69

相关问题

  • 国产分布式数据库真的能全面替换核心业务吗？Oracle为何没有向分布式发力？
  • 现在入行数据库，选择Oracle数据库为切入点，是对是错呢？
  • 金融行业里，从性能、容量等角度来看，PostgreSQL适合替换什么规模的Oracle数据库？
  • 国产数据库同Oracle数据库的能力差别在哪里？国产数据全面开始替代Oracle等数据库我们还需要再那些方面努力？
  • Oracle迁移至PG，如何保障数据库的高可用和可持续性？

    • 相关资料

  • 中国银行数据库改造之路：Oracle to MySQL迁移实践
  • Redhat7.6 Oracle 19C RAC部署手册
  • Redhat7.0 Oracle 12C RAC部署手册
  • Oracle数据库日常维护手册v1.8
  • Redhat7.5 Oracle 18C RAC部署手册

    • 相关文章

  • 某大型银行手机银行等重要交易系统不做大幅改造整体去IOE最佳实践-技术路线选择篇
  • 数据库租户能力大调研
  • Oracle 兼容性面面观
  • Oracle数据库日常巡检指令
  • 一次Oracle bug的故障排查过程思考

    • 问题状态

  • 发布时间：2016-06-28
  • 关注会员：3 人
  • 问题浏览：3901
  • 最近回答：2016-06-28

    • 关于TWT使用指南社区专家合作厂商入驻社区企业招聘投诉建议版权与免责声明联系我们
    © 2024talkwithtrend — talk with trend,talk with technologist京ICP备09031017号-30

    X社区推广