ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 3套库同时碰到相同的问题,何其壮观!

3套库同时碰到相同的问题,何其壮观!

原创 Linux操作系统 作者:Xuan_Baby 时间:2012-04-06 09:48:23 0 删除 编辑

Version:10.2.0.4.0

故障后台报警:

Thu Apr  5 14:40:41 2012

Rejected the attempt to advance SCN over limit by 88 hours worth to 0x0b95.bea75f9c, by distributed transaction remote begin, remote DB: YSDB.

 Client info : DB logon user CUSTOM, machine loopback, program , and OS user weblogic

Thu Apr  5 14:40:41 2012

Rejected the attempt to advance SCN over limit by 88 hours worth to 0x0b95.bea75f9c, by distributed transaction remote end, remote DB: YSDB.

 Client info : DB logon user CUSTOM, machine loopback, program , and OS user weblogic

Thu Apr  5 14:40:42 2012

Rejected the attempt to advance SCN over limit by 88 hours worth to 0x0b95.bea76114, by distributed transaction remote begin, remote DB: KFDX.

 Client info : DB logon user CUSTOM, machine eda-yxqd, program oracle@eda-yxqd (J000), and OS user oracle

Thu Apr  5 14:40:42 2012

Rejected the attempt to advance SCN over limit by 88 hours worth to 0x0b95.bea76116, by distributed transaction remote end, remote DB: KFDX.

 Client info : DB logon user CUSTOM, machine eda-yxqd, program oracle@eda-yxqd (J000), and OS user oracle

Thu Apr  5 14:40:42 2012

Errors in file /ora10/admin/custom/bdump/custom_reco_26738738.trc:

ORA-00600: internal error code, arguments: [18348], [0x000000000], [485331304561], [], [], [], [], []

Thu Apr  5 14:40:43 2012

Errors in file /ora10/admin/custom/bdump/custom_reco_26738738.trc:

ORA-00600: internal error code, arguments: [18348], [0x000000000], [485331304561], [], [], [], [], []

Thu Apr  5 14:40:43 2012

RECO: terminating instance due to error 476

Instance terminated by RECO, pid = 26738738

 

分析及处理步骤:

1、根据日志文件中的ORA-19706: invalid SCN错误信息,在ORACLE METALINK进行错误信息确认,Oracle建议在版本10.211.1需要增加隐含参数”_external_scn_rejection_threshold_hours”=24,在版本11.2上不需要增加这个参数(doc: 1393360.11388639.1

2、根据ORACLE METALINK进行如下操作;

Alter system set “_external_scn_rejection_threshold_hours”=24 scope=spfile sid=’SID_NAME’;

3、重启数据库。
结束语:
这么多的库同时碰到同一个问题,着实有压力,还好只停了一个小时的业务.

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

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

注册时间:2012-03-09

  • 博文量
    12
  • 访问量
    30523