Oracle data guard


Use the Oracle Data Guard page to check standby readiness, redo transport/apply lag, archive destination errors, and managed recovery process state.

Screenshot pending: Mini DBA Oracle Data Guard screenshot placeholder

What Mini DBA shows

  • Database role, open mode, protection mode, maximum sampled lag, destination error count, and managed standby process count.
  • Lag statistics from V$DATAGUARD_STATS, including transport lag, apply lag, datum time, and time computed.
  • Archive/Data Guard destination status from V$ARCHIVE_DEST_STATUS, including destination, recovery mode, gap status, and error text.
  • Managed standby process state from V$MANAGED_STANDBY.
  • Configuration members from V$DATAGUARD_CONFIG.

How to use it

Start with the summary row. A non-zero maximum lag does not always mean an incident, but sustained transport or apply lag should be investigated before it threatens recovery point or failover readiness.

Use Destinations when the page reports destination errors. The error text usually points at network, listener, disk, archive destination, or authentication problems.

Use Managed Standby on standby databases to confirm recovery processes are present and applying redo. A standalone or primary-only database may legitimately show no managed standby rows.

Permissions

The monitoring login needs read access to the Data Guard dynamic performance views. The Oracle permissions modal includes Data Guard-specific checks and DBA SQL guidance.

For Oracle 12c+ multitenant systems, connect Mini DBA to the CDB/root service with a common monitoring user when you want full instance-level HA/DR visibility.