JAVA J2EE 4 U

 SELECT 

    ROUND(SUM(CASE WHEN bp.status = 'A' THEN 1 ELSE 0 END) * 100.0 / COUNT(*), 2) AS archlog_backup_success_pct,

    COUNT(*) AS total_archlog_backups,

    SUM(CASE WHEN bp.status = 'A' THEN 1 ELSE 0 END) AS successful_archlog_backups,

    SYSDATE AS report_time

FROM 

    v$backup_piece bp

JOIN 

    v$backup_set bs 

    ON bp.set_stamp = bs.set_stamp AND bp.set_count = bs.set_count

WHERE 

    bs.backup_type = 'L'  -- 'L' = Archive log backups

    AND bp.start_time >= SYSDATE - 30;  -- Optional: last 30 days