Monitoring a Data Guard Configuration (Doc ID 2064281.1)

Last updated on JUNE 20, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Goal

 When monitoring Data Guard configurations a DBA must be able to be alerted to conditions that may potentially risk violating the business recovery point objects and/or the recover time objective requirements.  Monitoring a Data Guard environment involves monitoring both the primary and all associated standby databases.  This note outlines basic methods to monitoring a Data Guard configuration.

This Document discusses

Detecting a Transport or Apply Lag using SQL.
Detecting a Transport or Apply Lag using Dataguard broker.
Monitoring Data Guard Configuration Health Using the Broker.
Monitoring Data Guard Configuration Health Using the SQL.

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms