My Oracle Support Banner

Managing Alert Thresholds with Database Role Changes in Enterprise Manager (Doc ID 2700743.1)

Last updated on SEPTEMBER 16, 2020

Applies to:

Enterprise Manager for Oracle Database - Version 13.2.2.0.0 and later
Enterprise Manager Base Platform - Version 13.2.2.0.0 and later
Information in this document applies to any platform.

Purpose

 

Overview

Switchover and Failover are features that assist, respectively, with the scheduled and unscheduled downtime of Oracle databases in a Data Guard configuration.  Databases in a Data Guard configuration have a designated role – either as a primary database or as a standby database.  Enterprise Manager monitors these databases with the Data Guard Performance metric group which contains the set of metrics for primary and standby databases.  Based on the database’s current role, Enterprise Manager monitors the appropriate subset of metrics for the database.  This is summarized in the Table 1.
 
 


Data Guard Performance Metrics for Primary and Standby Databases

 

Table 1 lists the set of threshold-able metrics under the Data Guard Performance metric group that are mutually exclusive for primary and standby databases.  The table shows the subset of metrics that will be collected based on the database’s current role.

Table 1 Metric Group: Data Guard Performance

Metrics monitored in Enterprise Manager

Database Role = Primary

Database Role = Standby

Redo Generation Rate (KB/second)

Yes

No

Estimated Failover Time (seconds)

No

Yes

Apply Lag (seconds)

No

Yes

Transport Lag (seconds)

No

Yes

Redo Applied (blocks)

No

Yes

Redo Apply Rate (KB/second)

No

Yes

Apply Lag Data Refresh Time

No

Yes

Transport Lag Data Refresh Time

No

Yes

 

Users can specify thresholds for these metrics that will generate alerts in Enterprise Manager. 

 

At some point, primary and standby databases can have their roles changed using the Switchover or Failover features in Data Guard Management.  When a role change occurs, i.e., the primary becomes the standby and the standby becomes the primary, Enterprise Manager must detect this role change and now monitor the databases using with a different set of metrics (and thresholds) that are applicable for their new roles.   

This document will provide guidance on how to use Enterprise Manager to support a database role change that takes into account the corresponding change of metric thresholds.  

 


 

Details

To view full details, sign in with your My Oracle Support account.

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


In this Document
Purpose
 Overview
 
Data Guard Performance Metrics for Primary and Standby Databases
 
Details
 Decide how to manage Data Guard metric thresholds
 
Perform a Switchover using Enterprise Manager
 
 Using Administration Groups and Template Collection
  Step 1 : Define the administration group hierarchy
  Step 2 : Create the monitoring templates and template collections
  Step 3 : Associate the Template Collections with the Administration Groups
  Step 4 : Add the Database targets to the Administration Groups
 
Scenarios using Administration Groups and Template Collections
  Scenario 1 : Primary and Standby Databases in the same Administration Group
  Scenario 2 : Primary and Standby Databases in different Administration Groups
  Scenario 3 : Only Primary Database or Only Standby Database is part of an Administration Group
 
Appendix A.  Verifying thresholds after the database has been added to an Administration Group
 

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.