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

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.2和11.1需要增加隐含参数”_external_scn_rejection_threshold_hours”=24,在版本11.2上不需要增加这个参数（doc: 1393360.1，1388639.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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26634508/viewspace-720490/