RAC Instance Status

View instance number, name, host, status and startup time across the cluster.

SELECT
    inst_id,
    instance_number,
    instance_name,
    host_name,
    status,
    startup_time,
    database_type
FROM gv$instance
ORDER BY inst_id;

Confirm which RAC instances are currently mounted and review their instance numbers and names.

SELECT
    inst_number,
    inst_name
FROM v$active_instances
ORDER BY inst_number;

Compare instance startup times to identify recent restarts or differences between RAC nodes.

SELECT
    inst_id,
    instance_name,
    host_name,
    startup_time,
    ROUND((SYSDATE - startup_time) * 24, 2) AS uptime_hours
FROM gv$instance
ORDER BY startup_time DESC;

Review status, instance role, active state and service blocking state for each RAC instance.

SELECT
    inst_id,
    instance_name,
    host_name,
    status,
    instance_role,
    active_state,
    blocked
FROM gv$instance
ORDER BY inst_id;

Check the database type reported by each instance and verify the cluster is running as RAC.

SELECT DISTINCT
    database_type
FROM gv$instance
ORDER BY database_type;

Quickly summarize the number of RAC instances by current instance status.

SELECT
    status,
    COUNT(*) AS instance_count
FROM gv$instance
GROUP BY status
ORDER BY status;