db.hadr_op_status - HADR Operational Status health indicator

This health indicator tracks the high availability disaster recovery (HADR) operational state of the database. The state between primary and standby servers can be one of the following values: Connected, Congested or Disconnected. A change from Connected to another state might generate an Attention alert.

Important: The health monitor, health indicators, and related components have been discontinued with the exception of the HEALTH_MON database manager configuration parameter, the GET HEALTH SNAPSHOT command and the HADR health indicators (db.hadr_op_status and db.hadr_delay), which remain deprecated.
Identifier
db.hadr_op_status
Health monitor level
Database
Category
High availability disaster recovery
Type
State-based
Unit
Not applicable

db.hadr_delay - HADR Log Delay health indicator

This health indicator tracks the current average delay (in minutes) between the data changes on the primary database and the replication of those changes on the standby database.

With a large delay value, data loss can occur when failing over to the standby database after a failure on the primary database. A large delay value can also mean longer downtime when takeover is required, because the primary database is ahead of the standby database.
Important: The health monitor, health indicators, and related components have been discontinued with the exception of the HEALTH_MON database manager configuration parameter, the GET HEALTH SNAPSHOT command and the HADR health indicators (db.hadr_op_status and db.hadr_delay), which remain deprecated.
Identifier
db.hadr_delay
Health monitor level
Database
Category
High availability disaster recovery
Type
Upper-bounded threshold-based
Unit
Minutes