Monitor Primary Databases

An Oracle Data Guard configuration contains one production database, also referred to as the primary database, that functions in the primary role.

The primary database can either be a single instance Oracle Database or a RAC database. To monitor a primary database, click the name of the database on the Oracle Database fleet summary page and go to the corresponding Managed database details page.

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

  • View the Database role in the Managed database information section. You can also click More details to view whether Flashback is enabled or not.
  • Click Data Guard on the left pane under Resources to view Data Guard-related information and the following charts that provide an overview of the performance of the primary and standby databases for the time period selected in the Time period drop-down list.
    Note

    • Database Management only displays the details and performance metrics of a Data Guard configuration within the region. For instance, in the case of a cross-regional Data Guard configuration, if the standby databases are in a different region, then the performance metrics and other information for the standby databases will not be displayed. Similarly, if you change the region, the performance metrics and other information for the primary database will not be displayed.
    • Database Management currently does not support the monitoring of Data Guard per Pluggable Database (DGPDB).
    • Primary database: The charts in this section display the following performance metrics for the primary database:
      • Committed: The number of committed transactions.
      • Rollback: The number of rolled back transactions.
      • Redo generation rate: The amount of redo that was generated.
    • Standby databases: The charts in this section display the following performance metrics for all the standby databases in the selected compartment:
      • Apply lag: The number of seconds the standby databases are behind the primary database.
      • Transport lag: The number of seconds of redo not yet available on the standby databases.
      • Redo apply rate: The amount of redo applied on the standby databases.

    Below the performance charts, the list of standby databases for the primary database, along with the mean values of their performance metrics is displayed. You can click the name of the standby database to go to the Managed database details page of the standby database.