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 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 Database 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 Database 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 Database Management for External Databases or Enable Database Management for Oracle Cloud Databases.
  • If you've recently started using Database 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 Database Management, you can monitor the primary and standby databases on the corresponding Managed database details page. Database Management displays Data Guard-specific attributes and performance metrics and provides advanced functionalities that allow you to use:

  • 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 and when role transitions occur.

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