Home » Server Options » Data Guard » Standby is not caught up (Oracle 10.2.0.3 IBM AIX 5.3)
Standby is not caught up [message #351583] Wed, 01 October 2008 11:36 Go to next message
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
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?

Regards,
Taj
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: Fri Mar 29 01:16:07 CDT 2024