Data Guard Configuration

Review the database identity, role, protection mode and switchover state that define the current Data Guard member.

SELECT
    name,
    db_unique_name,
    database_role,
    open_mode,
    protection_mode,
    protection_level,
    switchover_status
FROM v$database;

List the unique database names known to the Data Guard configuration through DB_UNIQUE_NAME and LOG_ARCHIVE_CONFIG.

SELECT
    db_unique_name,
    parent_dbun,
    dest_role
FROM v$dataguard_config
ORDER BY db_unique_name;

Inspect configured archive destinations, targets, transport mode, binding and destination status.

SELECT
    dest_id,
    status,
    target,
    db_unique_name,
    binding,
    transmit_mode,
    affirm,
    net_timeout,
    destination
FROM v$archive_dest
WHERE target = 'STANDBY'
ORDER BY dest_id;

Inspect standby redo log groups, threads, sizes and current status on the database where the query is executed.

SELECT
    group#,
    thread#,
    sequence#,
    bytes,
    blocksize,
    used,
    archived,
    status
FROM v$standby_log
ORDER BY
    thread#,
    group#;

Review online redo groups by thread to understand redo thread configuration before comparing standby redo capacity.

SELECT
    thread#,
    group#,
    sequence#,
    bytes,
    archived,
    status
FROM v$log
ORDER BY
    thread#,
    group#;

Inspect DB_UNIQUE_NAME, LOG_ARCHIVE_CONFIG and configured LOG_ARCHIVE_DEST parameters used by Data Guard.

SELECT
    name,
    value
FROM v$parameter
WHERE name = 'db_unique_name'
   OR name = 'log_archive_config'
   OR (
       name LIKE 'log_archive_dest_%'
       AND name NOT LIKE 'log_archive_dest_state_%'
   )
ORDER BY name;