逻辑备库从10202升级到11202后无法同步日志

最新推荐文章于 2025-10-27 09:24:38 发布

转载最新推荐文章于 2025-10-27 09:24:38 发布 · 124 阅读

讨论了在LINUX564BIT环境下，主库与逻辑备库升级后出现同步日志失败的问题，通过重启主库解决了异常情况，分析了可能的原因并提供了解决方案。

LINUX 5 64BIT 主库10202，逻辑备库从10202升级到11021或11202后出现以下错误

备库：
Fri Jun 06 11:30:06 2014
Archive log rejected (thread 1 sequence 153) by RFS clients
Fri Jun 06 11:31:06 2014
Archive log rejected (thread 1 sequence 153) by RFS clients
Fri Jun 06 11:31:22 2014
SERVER COMPONENT id=UTLRP_END: timestamp=2014-06-06 11:31:22
Fri Jun 06 11:32:06 2014
Archive log rejected (thread 1 sequence 153) by RFS clients
Fri Jun 06 11:33:06 2014
Archive log rejected (thread 1 sequence 153) by RFS clients

主库：
Mon Jul 7 03:28:07 2014
ARC2: Archive log rejected (thread 1 sequence 153) at host 'nbutest1_stdby'
Mon Jul 7 03:29:07 2014
ARC2: Archive log rejected (thread 1 sequence 153) at host 'nbutest1_stdby'
Mon Jul 7 03:30:07 2014
ARC2: Archive log rejected (thread 1 sequence 153) at host 'nbutest1_stdby'
Mon Jul 7 03:31:07 2014
ARC2: Archive log rejected (thread 1 sequence 153) at host 'nbutest1_stdby'
Mon Jul 7 03:32:07 2014
ARC2: Archive log rejected (thread 1 sequence 153) at host 'nbutest1_stdby'
Mon Jul 7 03:33:07 2014
ARC2: Archive log rejected (thread 1 sequence 153) at host 'nbutest1_stdby'
Mon Jul 7 03:34:07 2014
ARC2: Archive log rejected (thread 1 sequence 153) at host 'nbutest1_stdby'
Mon Jul 7 03:35:07 2014
ARC2: Archive log rejected (thread 1 sequence 153) at host 'nbutest1_stdby'

经查各类日志，没有发现明显的错误信息，搜索网上也没找到相关解决办法。

最后重启主库后发现逻辑备库恢复正常，可以正常同步日志。万能重启大法？？？？？

由于生产环境在逻辑备库升级后也出现类似问题，所以搭建此测试环境，已经建议生产库重启，希望能解决问题。。。。。

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

转载于:http://blog.itpub.net/280958/viewspace-1176861/