RMAN Database Backup

Review recent RMAN backup jobs, their status, duration, backup type and the amount of data processed.

SELECT
    session_key,
    input_type,
    status,
    start_time,
    end_time,
    ROUND(elapsed_seconds / 60, 1) AS elapsed_minutes,
    input_bytes_display,
    output_bytes_display
FROM v$rman_backup_job_details
ORDER BY start_time DESC
FETCH FIRST 20 ROWS ONLY;

Inspect finished and currently running RMAN operations and identify warnings or failures.

SELECT
    session_recid,
    session_stamp,
    operation,
    status,
    start_time,
    end_time,
    input_bytes,
    output_bytes,
    output_device_type
FROM v$rman_status
WHERE row_level = 1
ORDER BY start_time DESC
FETCH FIRST 20 ROWS ONLY;

Review completed backup sets, their type, incremental level, piece count and completion time.

SELECT
    set_stamp,
    set_count,
    backup_type,
    incremental_level,
    pieces,
    start_time,
    completion_time,
    elapsed_seconds
FROM v$backup_set
ORDER BY completion_time DESC
FETCH FIRST 20 ROWS ONLY;

Inspect backup piece handles, device type, status, size and completion time when tracing backup files.

SELECT
    set_stamp,
    set_count,
    piece#,
    copy#,
    device_type,
    handle,
    status,
    bytes,
    completion_time
FROM v$backup_piece
ORDER BY completion_time DESC
FETCH FIRST 20 ROWS ONLY;

Compare input and output sizes, throughput and compression across recent RMAN backup jobs.

SELECT
    session_key,
    input_type,
    status,
    input_bytes_display,
    output_bytes_display,
    input_bytes_per_sec_display,
    output_bytes_per_sec_display,
    compression_ratio
FROM v$rman_backup_job_details
ORDER BY start_time DESC
FETCH FIRST 20 ROWS ONLY;

Review messages reported by active RMAN operations when additional runtime context is needed.

SELECT
    session_key,
    sid,
    recid,
    stamp,
    output
FROM v$rman_output
ORDER BY stamp DESC
FETCH FIRST 50 ROWS ONLY;