RMAN queries

We can use view to check rman backup status.

RAC / NON-RAC / Cloud RDS:

select to_char(start_time,'dd-mm-yyyy hh24:mi:ss') as start_time, to_char(end_time,'dd-mm-yyyy_hh24:mi:ss') as end_time, status, round(mbytes_processed/1024, 2) as GB_processed,object_type,operation,row_type,sid from v$rman_status where start_time >= sysdate-1  order by start_time desc;

set lines 300

select sid,serial#,context,opname,sofar,totalwork,roud(sofar/totalwork*100,2) "%_COMPLETE" from gv$session_longops where opname like 'RMAN%' and totalwork !=0 and sofar != totalwork order by 6 desc;

set pages 2000 

col status format a9

col hrs format 999.99

col start_time for a20

col end_time for a20

set lines 300

select input_type,status,to_char(start_time,'dd-mm-yyyy hh24:mi:ss') as start_time, to_char(end_time,'dd-mm-yyyy_hh24:mi:ss') as end_time, elapsed_seconds/3600 hrs, input_bytes/1024/1024/1024 sum_bytes_backed_in_GB, output_bytes/1024/1024/1024 sum_backup_pieces_in_GB, output_device_type from v$rman_backup_job_details order by session_key;