Oracle Cloud Infrastructure Documentation

Monitor Standby Databases

A standby database is a transactionally consistent copy of the primary database.

Oracle Data Guard configuration can have up to thirty standby databases, which are created using a backup copy of the primary database. Standby databases can be of different types such as physical standby databases and logical standby databases. You can use Database Management Diagnostics & Management to monitor standby databases using various performance criteria.

Topics:

Monitor Standby Database Information and Performance

You can monitor standby databases on the corresponding Managed database details page in Database Management. To go to the Managed database details page, you can use one of the following options:

  • On the Oracle Database fleet summary or High Availability fleet summary page, click the name of the database.
  • On the Managed database details page of the primary database, click Data Guard on the left pane under Resources, and then click the name of the database in the Standby databases section.

On the Managed database details page, you can perform the following tasks for standby databases:

  • View the Database role and the name of the primary database in the Managed database information section.
  • Click Data Guard on the left pane under Resources to view Data Guard-related information and an overview of the performance of the primary and standby databases for the time period selected in the Time period drop-down list. Note that the same metrics are displayed in the Data Guard section for both primary and standby databases. For more information, see Monitor Primary Databases.

Use Alarms to Monitor Standby Databases

You can build metric queries for the standby database metrics in the oracle_oci_database namespace (resource group: oracle_dataguard) and create alarms in the Oracle Cloud Infrastructure Monitoring service. You can monitor the alarms in Database Management and be notified when these metrics meet alarm-specified triggers. For more information, see:

Monitor Data Guard Role Transitions

In Data Guard, the role of a database can be changed from a standby database to a primary database, or from a primary database to a standby database using either a switchover or failover operation. Database Management uses the Oracle Cloud Infrastructure Events service to indicate changes in resources (Oracle Databases). Using events, which are structured messages, you can be notified of a role transition between primary and standby databases.

Here's the Database Management event that you can use to be notified of a role transition.

Event Name Description Event Type
MONITORING.DATABASE_ROLE_CHANGE.INFORMATION This event is emitted when the database role has changed, for example, from PRIMARY to PHYSICAL_STANDBY. com.oraclecloud.databasemanagement.manageddatabase.information

Event Type in the UI: Managed Database - Information

For information on: