RMAN BACKUP JOBS STATUS

RMAN BACKUP JOBS STATUS


set serveroutput on
set linesize 150
set pagesize 300
col time_taken_display for a9

select session_key, 
       input_type, 
       status,SESSION_STAMP,
       to_char(start_time,'yyyy-mm-dd hh24:mi') start_time,
       to_char(end_time,'yyyy-mm-dd hh24:mi')   end_time,
       output_bytes_display,
time_taken_display
from v$rman_backup_job_details
order by session_key desc;