Monitor Oracle Data Guard

You can monitor the primary and physical standby databases that are a part of an Oracle Data Guard configuration, in Database Management.

Database Management supports Data Guard monitoring for External Databases and Oracle Cloud Databases. A Data Guard configuration contains one primary database and multiple standby databases, which are copies of the primary database. This configuration ensures high availability, data protection, and disaster recovery for enterprise data. Using Diagnostics & Management features in Database Management, you can monitor standby databases, in addition to the primary database. This allows you to monitor the overall health and performance of the configuration, and ensures that standby databases are available for disaster recovery and failover events. For information on Data Guard, see Introduction to Oracle Data Guard in Oracle Data Guard Concepts and Administration.

Here are a few points and prerequisite tasks to keep in mind before you enable and use Diagnostics & Management to monitor primary and standby databases:

  • For External Databases, a Management Agent 240508.1440 or later is required to monitor primary and standby databases.
  • If you're enabling Diagnostics & Management for a database in a Data Guard configuration that contains a physical standby database in mounted state, you must ensure that the monitoring user has the SYSDG privilege. For more information, see Enable Diagnostics & Management for External Databases or Enable Diagnostics & Management for Oracle Cloud Databases.
  • If you've recently started using Diagnostics & Management to monitor your primary and standby databases, you must run the SQL script to assign the required privileges to the monitoring user again. This is required to obtain and monitor the new metrics for primary and standby databases. For information on the SQL script, see Creating the Oracle Database Monitoring Credentials for Database Management (Doc ID 2857604.1) in My Oracle Support.

On obtaining the required privileges and enabling Diagnostics & Management, you can monitor the primary and standby databases on the corresponding Managed database details page. Using Diagnostics & Management, you can view Data Guard-specific attributes and performance metrics. In addition, it provides advanced functionalities such as:

  • Alarms to be notified when Data Guard metrics in the oracle_oci_database namespace (resource group: oracle_dataguard) meet specified triggers.
  • Events to be notified when role transitions occur.

For information on the availability of the other Diagnostics & Management features for primary and standby databases, see Diagnostics & Management Feature Support Matrix for Oracle Databases.