温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

DG 主库和备库日志大小不一样,无法实时同步数据

发布时间:2020-07-31 05:08:33 来源:网络 阅读:2396 作者:llc018198 栏目:大数据

一朋友搭建DG,参数没有错误,但是就是无法进行实时同步,,

主库日志:

Destination LOG_ARCHIVE_DEST_2 is SYNCHRONIZED
Destination LOG_ARCHIVE_DEST_2 no longer supports SYNCHRONIZATION

Thread 1 advanced to log sequence 1099 (LGWR switch)
  Current log# 1 seq# 1099 mem# 0: /data/oradata/sch/redo01.log
Sat Dec 26 11:20:20 2015
Archived Log entry 146 added for thread 1 sequence 1098 ID 0xad22dc32 dest 1:

备库日志:

Media Recovery Waiting for thread 1 sequence 1099 (in transit)
Sat Dec 26 11:39:42 2015
Archived Log entry 49 added for thread 1 sequence 1099 rlc 880215476 ID 0xad22dc32 dest 2:
RFS[3]: No standby redo logfiles available for thread 1
RFS[3]: Opened log for thread 1 sequence 1100 dbid -1390233806 branch 880215476
Sat Dec 26 11:39:43 2015
Media Recovery Log /u01/archivelog/arch_880215476_1_1099.arc
Media Recovery Waiting for thread 1 sequence 1100 (in transit)


后来检查发现,主库日志大小为512M,而他备库设置成500M...







向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI