oracle跟踪日志生成问题

请教一下各位大神,最近某个单位有台IBM小型机的oracle数据库有点异常:只要有业务操作,就会产生大量跟踪日志文件,经常导致文件系统被写满,以下为oracle日志文件里面的前200条日志信息,请教一下各位,这究竟是什么情况:# tail -n 200 alert_ITMSDB.logErrors in file /opt/database...显示全部

请教一下各位大神,最近某个单位有台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

#

#

收起
参与13

查看其它 2 个回答itdreamfly的回答

itdreamflyitdreamfly数据库管理员南昌

临时关闭trace日志产生:

alter system set trace_enabled = false;

查看数据库版本是否为:

11.2.0.211.2.0.111.1.0.7

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

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

系统集成 · 2016-06-28
浏览2622

回答者

itdreamfly
数据库管理员南昌

itdreamfly 最近回答过的问题

回答状态

  • 发布时间:2016-06-28
  • 关注会员:3 人
  • 回答浏览:2622
  • X社区推广