JAVA J2EE 4 U

 SELECT 

    d.name AS db_name,

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

FROM 

    rc_backup_set bs

JOIN 

    rc_database d ON bs.db_key = d.db_key

WHERE 

    bs.backup_type = 'I'  -- Incremental

    AND bs.start_time >= SYSDATE - 30

GROUP BY 

    d.name;

SELECT 

    d.name AS db_name,

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

FROM 

    rc_backup_set bs

JOIN 

    rc_database d ON bs.db_key = d.db_key

WHERE 

    bs.backup_type = 'L'  -- Archive Log

    AND bs.start_time >= SYSDATE - 30

GROUP BY 

    d.name;