SQL Query to find Progress of RMAN Backup

col STATUS format a10

col hrs format 999.99

select SESSION_KEY, INPUT_TYPE, STATUS,to_char(START_TIME,’mm/dd/yy hh24:mi’) start_time,

to_char(END_TIME,’mm/dd/yy hh24:mi’) end_time,elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS

order by session_key;

One thought on “SQL Query to find Progress of RMAN Backup”

zoritoler imol says:

March 10, 2025 at 5:33 am

I very happy to find this web site on bing, just what I was searching for : D besides saved to fav.

Reply