Tchater maintenant avec le support
Tchattez avec un ingénieur du support

Spotlight on Oracle 11.0 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Troubleshooting: Connection Problems

Standby Processes Panel

 

The Standby Processes panel:

Panel components

Apply Lag

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.

Apply Server

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.

Remote File Server The Remote File Server receives data from the Primary and sends it to the Standby Logs. The RFS numeric indicates the number of Remote File Server processes.
Standby Type The type of Standby database – physical or logical.

Data flows

(Network) From Log Network Server The rate SQL*Net bytes are received by the Remote File Server.
(Network) From Archiver The rate log files are copied from the Archiver to the Remote File Server averaged over 5 minutes.

Remote File Server to Standby Logs

The rate data is written to the Standby logs.
Standby Logs to the Apply Server and Buffer Cache

The rate data is transferred to Apply Server processes and the Buffer Cache.

Dependent on the type of Standby database:

  • Physical Standby - The “redo blocks read for recovery”
  • Logical Standby - The “db block changes”

 

Related Topics

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation