Standby is not caught up [message #351583] |
Wed, 01 October 2008 11:36 |
mnlv00
Messages: 8 Registered: May 2008
|
Junior Member |
|
|
Hi,
We have a production primary and a physical standby. It's in real time apply mode, LGWR ASYNC. But sometimes we will see the apply process stops. If I query against the v$archived_log, I see some logs to be applied. It doesn't automatically apply those unless I do these
alter database recover managed standby database cancel;
alter database recover managed standby database using current logfile disconnect;
Q is why do I have to run this everytime this happens ? Pl help
TIA
mnlv
|
|
|
|