Managing Alert Thresholds with Database Role Changes in Enterprise Manager
(Doc ID 2700743.1)
Last updated on JANUARY 18, 2023
Applies to:
Enterprise Manager for Oracle Database - Version 13.2.2.0.0 and laterEnterprise 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 |