Home » Server Options » Data Guard » Standby is not caught up (Oracle IBM AIX 5.3)
Standby is not caught up [message #351583] Wed, 01 October 2008 11:36 Go to next message
Messages: 8
Registered: May 2008
Junior Member
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
Re: Standby is not caught up [message #351665 is a reply to message #351583] Thu, 02 October 2008 04:20 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Did you check "alertlog" file of both side when archive log apply process is stop.
Did you find any error message in alertlog?

Previous Topic: Question about Note:387261.1 - MAA - Creating a RAC Logical Standby for a RAC Primary 10gr2
Next Topic: Switchover
Goto Forum:

Current Time: Sat Oct 22 04:43:04 CDT 2016

Total time taken to generate the page: 0.11079 seconds