What could be causing the fluctuation in ReplicaLag every 5 minutes in Oracle RDS?

0

I have a client who has observed the following symptoms: What could be the reason behind the intermittent variations in replication lag observed by a customer utilizing RDS Oracle with a read replica configuration every five minutes?

RouseV
已提问 1 个月前137 查看次数
1 回答
1
已接受的回答

Hello @RouseV,

When the size of the primary online redo log exceeds that of the standby redo log on the replica, it can lead to this issue.

If a standby redo log is utilized, real-time apply can be enabled in the Data Guard configuration, allowing Data Guard to recover redo data from the current standby redo log as it is being written by the RFS process. However, if the primary online redo log size surpasses that of the standby redo log on the replica, the standby redo log cannot be used. Consequently, when an archive log is generated on the primary, it is sent to the standby, and at that moment, the standby is recovered using that archive redo log.

In RDS Oracle, where the archive_lag_target is set to 5 minutes, the ReplicaLag fluctuates up and down every 5 minutes.

AWS
phirani
已回答 1 个月前
profile picture
专家
已审核 1 个月前
profile pictureAWS
专家
已审核 1 个月前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则