Spotlight on Oracle 10.5 - Release Notes

The Apply Lag is a description of how far the Standby is behind the Primary. It measures the difference in elapsed time from when the last applied change became visible on the Standby and that same change was first visible on the Primary.

Ensure you set the thresholds of the Apply Lag Alarm according to your business requirements for Recovery Time Objective and Recovery Point Objective. The thresholds define various states of alarm for how far the Standby is behind the Primary in minutes, taking into account any delay you may have specified.

Note: In Oracle versions prior to 11.2 some configurations experience inconsistent or misleading data on the Apply Lag. This is documented as Oracle Knowledge Article [ID 1299000.1].

An Example Scenario: The flow from Remote File Server to Standby Logs to Apply Server to Buffer Cache to Data Files shows no reason for alarm so you would expect the Apply Lag to be low, but the Apply Lag is increasing in contradiction to this. The Apply Lag data is misleading. Disable the Apply Lag Alarm and use the Outstanding Logs to Apply Alarm to check for bottlenecks.

The Apply Server takes data from the Standby Logs and sends it to the Buffer Cache. The MRP numeric indicates the number of Apply Server processes.

• In logical standby from v$logstdby_process
• In physical standby from v$managed_standby.

The Apply Process Running Alarm occurs when there are no Apply Server processes on the Standby. When this alarm is raised there is an impact on Recovery Time Objective as data builds up in the Standby Logs.