Monitor High Availability Fleet

You can monitor the High Availability and backup details of your fleet of primary and Oracle Data Guard-configured standby CDBs, and the health and performance of Oracle Cloud Infrastructure GoldenGate deployments, in Database Management Diagnostics & Management.

Availability is the degree to which an application, service, or functionality is available on demand and it starts with ensuring that the database is reliable, recoverable, and safe in the event of unforeseen failures. High Availability for a database requires redundant configuration of resources using services such as RAC and Oracle Data Guard, and viable recovery scenarios that rely on database backups. The High Availability fleet summary page under Diagnostics & Management provides insights in a single-pane-of-glass view for all the primary and Oracle Data Guard-configured standby CDBs in a compartment or Database Group. This enables you to quickly identify any outliers in availability metrics or any environments at risk of data loss.

To go to the High Availability fleet summary page and monitor your databases:

1. Sign in to the Oracle Cloud Infrastructure console.
2. Open the navigation menu, click Observability & Management. Under Database Management, click Diagnostics & Management, and then click High Availability in the left pane.

   The High Availability fleet summary page is displayed.

3. Click the Compartment applied filter to select a different compartment, if required.
4. Optionally, in the Search and Filter field, click inside the field to view and select additional filters to apply to the High Availability fleet summary page:
   • Tags: Add a tag filter to filter the list of Oracle Databases by tag. For information on:
     • Tagging concepts and the permissions required to work with tags, see Overview of Tagging.
     • How to filter resources using tags, see To filter a list of resources by a tag.
   • Database group: Select a Database Group to view the Oracle Databases in that group. For information on Database Groups, see Create and Use Database Groups.

The following tabs are displayed on the High Availability fleet summary page and provide important High Availability, backup, and GoldenGate monitoring information for the last seven days:

• Overview tab: The tiles on this tab provide a visual representation of important High Availability and backup metrics for the fleet of primary and Oracle Data Guard-configured standby CDBs in the compartment or Database Group. When GoldenGate deployment information is available for the selected compartment and no Database Group or tag filters are applied, this tab also displays GoldenGate deployment health.

  The tiles include:

  • Last backup: Displays the status of full and incremental backups for the databases. Note that archive log backup failures are not displayed on this tile.
  • Last backup time (days): Displays the completion time and date of the last full or incremental backup.
  • Data Guard: Displays whether Oracle Data Guard is enabled.
  • Backup destination: Displays the type of backup destinations configured for the databases. This tile is displayed when there are no GoldenGate deployments in the selected compartment.
  • GoldenGate health: Displays the number of GoldenGate deployments by health status: Healthy or Not healthy. This tile replaces the Backup destination tile when there are GoldenGate deployments in the selected compartment and no Database Group or tag filters are applied.
  • Open HA Alarms: Displays the total number of open High Availability alarms in the compartment or Database Group, and the number of alarms by severity. These alarms are created to monitor High Availability metrics such as BackupDuration and FRASpaceLimit. Note that an alarm is only displayed on Diagnostics & Management pages if the OCID of the database is specified using the resourceId dimension when creating the alarm. You can click the number of alarms to access the Alarms panel and review the list of open alarms. For more information, see Monitor Alarms for Managed Databases.

  In addition to the tiles on the Overview tab, the Databases section lists all the primary and Oracle Data Guard-configured standby CDBs in the compartment or Database Group along with information such as the status of the last full or incremental backup, backup time, backup type, and fast recovery area usage in percentage. To filter the list of databases, you can either click the options in one or more charts or select from the options listed in the Filters drop-down list. To search for a particular database in the Databases list, enter its name in the Search by name field.

• Data Guard tab: The tiles on this tab display a visual representation of important Data Guard metrics for the primary and standby CDBs that are a part of an Oracle Data Guard configuration, in the compartment or Database Group:
  • Top 10 databases with longest failover time: Displays the top 10 databases with the longest failover time.
  • Data Guard alarms: Displays the total number of open Data Guard alarms in the compartment or Database Group, and the number of alarms by severity. These alarms are created to monitor Data Guard-related metrics such as EstimatedFailoverTime and TransportLag. Note that an alarm is only displayed on Diagnostics & Management pages if the OCID of the database is specified using the resourceId dimension when creating the alarm. You can click the number of alarms to access the Alarms panel and review the list of open alarms. For more information, see Monitor Alarms for Managed Databases.
  • Monitoring status: Displays the current monitoring status of the databases that are a part of an Oracle Data Guard configuration. The monitoring status indicates whether Database Management can collect monitoring metrics for the databases.
  • Fast-start failover: Displays whether fast-start failover is enabled.
  • Protection mode: Displays the protection mode set for the databases.
  • Transport lag: Displays the number of seconds of redo not yet available on the standby databases.
  • Apply lag: Displays the number of seconds the standby databases are behind the primary database.
  • Redo apply rate (mbps): Displays the amount of redo applied on the standby databases.

  In addition to the tiles on the Data Guard tab, the Data Guard enabled databases section lists all the primary and standby CDBs that are a part of an Oracle Data Guard configuration in the compartment or Database Group, along with information such as fast-start failover status and protection mode. To search for a particular database in the Data Guard enabled databases list, enter its name in the Search field.

• Cloud backup details and External backup details tabs: The tiles on these tabs display a visual representation of important backup metrics for Oracle Cloud or External CDBs in the compartment or Database Group:
  Note
  
  In the Cloud backup details and External backup details tabs, you can select a time period in the Time period applied filter to view backup details for the selected period.
  • Automatic backup: Displays whether automatic backup is enabled.

    Note that this tile is not available on the External backup details tab.

  • Recovery window (days): Displays the number of days within which the databases can be recovered.
  • Retention period (days): Displays the number of days for which database backups are retained.
  • Backup destination: Displays the type of backup destinations configured for the databases.
  • Backup size (GB): Displays the size of the backups for the databases.

    Note that this tile is not available on the Cloud backup details tab.

  • Total backups: Displays the total number and status of the backups for each database. In the upper-right corner of the Total backups chart, you can click the link adjacent to Total failed backups and Total failed archive log backups to filter the list of databases and only view the databases with failed backups.

  In addition to the tiles on the Cloud backup details and External backup details tabs, the Oracle Cloud or External CDBs in the compartment or Database Group are also listed. To filter the list of databases, you can either click the options in one or more charts or select from the options listed in the Filters drop-down list. To search for a particular database, enter its name in the Search by name field.

• GoldenGate tab: Displays monitoring information for GoldenGate deployments in the selected compartment. The deployments displayed are independent of the databases monitored by Database Management. GoldenGate monitoring uses existing GoldenGate metrics available through the Oracle Cloud Infrastructure Monitoring service and does not query the source or target databases. No additional database-user privileges are required. Oracle Cloud Infrastructure Identity and Access Management (IAM) permissions are required to view metrics and alarms and to access GoldenGate deployment details. To view deployment details in OCI GoldenGate, your user group must have permission to read GoldenGate deployments in the relevant compartment.

  For information on:

  • GoldenGate permissions, see Oracle Cloud Infrastructure GoldenGate Policies.
  • Metric definitions, availability, and access prerequisites, see Oracle Cloud Infrastructure GoldenGate Metrics.

  The tiles on this tab display the following information:

  • GoldenGate monitoring status: Displays the number of deployments by health status: Healthy or Not healthy.
  • Extract status: Displays the number of Extract processes that are running or not running.
  • Replicat status: Displays the number of Replicat processes that are running or not running.
  • Open alerts: Displays the number of open alarms for GoldenGate deployments in the selected compartment, grouped by severity: Critical, Error, Warning, and Information.
    Note
    
    This view displays firing alarms for metrics in the oci_goldengate namespace in the selected compartment. The database resourceId dimension is not required for alarms to appear in this tile.
  • Receiver path status: Displays the number of receiver paths that are running or not running.
  • Distribution path status: Displays the number of distribution paths that are running or not running.
  • Extract lag: Displays the distribution of Extract lag across the following ranges: 0–1 second, greater than 1 second and up to 5 seconds, greater than 5 seconds and up to 10 seconds, and greater than 10 seconds.
  • Replicat lag: Displays the distribution of Replicat lag across the same ranges.

  In addition to the tiles, the GoldenGate deployments section lists the deployments in the selected compartment, along with their health status, running-process counts, and maximum lag for Extract, Replicat, receiver paths, and distribution paths. The table also displays CPU and memory utilization, deployment OCPUs, and the time the information was last updated. To search for a deployment, enter its name in the Search by name field. Click a deployment name to open its details page in the GoldenGate service.

On monitoring the fleet of primary and Oracle Data Guard-configured standby CDBs on the High Availability fleet summary page, you can click the name of a CDB to go to the Managed database details page and monitor the backups in the Backup section. For information, see Monitor Backups for a Specific Managed Database.