new

 SET LINESIZE 200

COL piece_handle FOR A70

COL level FOR 5

COL size_gb FOR 10

COL start_time FOR A20

COL end_time FOR A20

SELECT

    bp.handle AS piece_handle,

    bset.incremental_level,

    ROUND(bp.bytes / 1024 / 1024 / 1024, 2) AS size_gb,

    TO_CHAR(bset.start_time, 'YYYY-MM-DD HH24:MI:SS') AS start_time,

    TO_CHAR(bset.completion_time, 'YYYY-MM-DD HH24:MI:SS') AS end_time

FROM

    v$backup_piece bp,

    v$backup_set bset

WHERE

    bp.set_stamp = bset.set_stamp

    AND bp.set_count = bset.set_count

    AND bset.incremental_level IS NOT NULL

    AND bset.start_time > SYSDATE - 7

ORDER BY

    bset.start_time DESC;