One primary with two physical standbys exhibiting different behavior with regard to lag
Date: Thu, 3 Jan 2019 13:29:29 -0700
Message-ID: <CAJzM94AxZ=_NqGOcPU40PJU7AigU3Phk-5rCC=nGmq-j6P2NqA_at_mail.gmail.com>
Oracle 12.1.0.2
RHEL7 To begin with, I have not worked much at all with standby databases, so my knowledge is somewhat lacking.
For business reasons, we have a primary database with two physical standbys. Everything is configured in dgmgrl and enabled. Monitoring with EM13c is reporting the lag times, so all looks good for basic setup and monitoring. We seem to have significant lag at times on one of the standbys, as much as 20 minutes. When looking at v$managed_standby, we see the status as "WAIT_FOR_LOG". The other standby never seems to be more that a few seconds behind, if at all, and the status is "APPLYING_LOG".
Is this normal? I've been researching, but haven't found an answer yet. I didn't create or start the standby databases, so I don't have any idea what was actually done that could be causing this behavior. Any suggestions would be appreciated.
Thank you,
--
Sandy B.
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 03 2019 - 21:29:29 CET