Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

1

好友

7

主题
1#
发表于 2013-10-28 10:14:23 | 查看: 3861| 回复: 2
操作系统:aix  数据库 9.2.0.6  三节点rac
情况:节点2宕机,节点1、3没有问题,三个节点都有相关的报错,1、3节点提示有生成trace文件,但是实际上没有生成,找不到生成的trace文件
大家帮忙看看有什么原因导致的,下面是各个节点的日志:
db1:

Sun Oct 27 04:14:56 2013
ARC3: Evaluating archive   log 1 thread 1 sequence 16456
ARC3: Archive destination LOG_ARCHIVE_DEST_2: Previously completed
ARC3: Beginning to archive log 1 thread 1 sequence 16456
Creating archive destination LOG_ARCHIVE_DEST_1: '/oraback/archivlog/1_16456.dbf'
ARC3: Completed archiving  log 1 thread 1 sequence 16456
Sun Oct 27 08:06:17 2013
Trace dumping is performing id=[31027080617]
Sun Oct 27 08:08:24 2013
Errors in file /oracle/app/admin/ora9/bdump/ora91_diag_151672.trc:
ORA-00600: internal error code, arguments: [17182], [0x1192AFF80], [], [], [], [], [], []
Sun Oct 27 08:08:25 2013
Restarting dead background process DIAG
DIAG started with pid=3
Sun Oct 27 08:10:33 2013
Evicting instance 2 from cluster
Sun Oct 27 08:10:38 2013
Reconfiguration started (old inc 15, new inc 16)
List of nodes:
0 2
Sun Oct 27 08:10:39 2013
Reconfiguration started (old inc 15, new inc 17)
List of nodes:
  
db2:

Sun Oct 27 05:26:04 2013
ARC0: Evaluating archive   log 22 thread 2 sequence 12758
ARC0: Archive destination LOG_ARCHIVE_DEST_2: Previously completed
ARC0: Beginning to archive log 22 thread 2 sequence 12758
Creating archive destination LOG_ARCHIVE_DEST_1: '/oraback/archivlog/2_12758.dbf'
ARC0: Completed archiving  log 22 thread 2 sequence 12758
Sun Oct 27 08:06:17 2013
Communications reconfiguration: instance 0
Sun Oct 27 08:06:17 2013
Trace dumping is performing id=[31027080617]
Sun Oct 27 08:10:33 2013
Errors in file /oracle/app/admin/ora9/bdump/ora92_lmon_151766.trc:
ORA-29740: evicted by member 0, group incarnation 16
Sun Oct 27 08:10:33 2013
LMON: terminating instance due to error 29740
Sun Oct 27 08:10:33 2013
Errors in file /oracle/app/admin/ora9/bdump/ora92_lmd0_229810.trc:
ORA-29740: evicted by member , group incarnation
Instance terminated by LMON, pid = 151766
Sun Oct 27 10:57:10 2013
Starting ORACLE instance (normal)
Sun Oct 27 10:57:10 2013

db3:

Sun Oct 27 04:14:56 2013
ARC4: Evaluating archive   log 23 thread 3 sequence 20357
ARC4: Archive destination LOG_ARCHIVE_DEST_2: Previously completed
ARC4: Beginning to archive log 23 thread 3 sequence 20357
Creating archive destination LOG_ARCHIVE_DEST_1: '/oraback/archivlog/3_20357.dbf'
ARC4: Completed archiving  log 23 thread 3 sequence 20357
Sun Oct 27 08:06:17 2013
Trace dumping is performing id=[31027080617]
Sun Oct 27 08:07:08 2013
Errors in file /oracle/app/admin/ora9/bdump/ora93_diag_85922.trc:
ORA-00600: internal error code, arguments: [17182], [0x11034F2F8], [], [], [], [], [], []
Sun Oct 27 08:08:12 2013
Restarting dead background process DIAG
DIAG started with pid=3
Sun Oct 27 08:10:33 2013
Evicting instance 2 from cluster
Sun Oct 27 08:10:39 2013
Reconfiguration started (old inc 15, new inc 16)
List of nodes:
0 2
2#
发表于 2013-10-28 11:23:21
如果网络参数设置没有问题(no -a查看),那么怀疑是Bug 4104619 ,建议升级到9.2.0.8

回复 只看该作者 道具 举报

3#
发表于 2013-10-28 11:45:15
lunar 发表于 2013-10-28 11:23
如果网络参数设置没有问题(no -a查看),那么怀疑是Bug 4104619 ,建议升级到9.2.0.8 ...

能给贴点Bug 4104619 信息吗,没账号,看不了...
还有这个bug不是宕机的原因吧?

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-6-1 22:13 , Processed in 0.048340 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569