Thursday, September 28, 2023

RMAN BACKUP STATUS REPORT

RMAN BACKUP STATUS REPORT


set linesize 1000
set pagesize 1000
select I.instance_name,R.SESSION_KEY, R.INPUT_TYPE, R.STATUS, R.start_time,R.end_time,"Minutes" 
from (
select
SESSION_KEY, INPUT_TYPE, STATUS,
to_char(START_TIME,'dd/mm/yyyy hh24:mi') start_time,
to_char(END_TIME,'dd/mm/yyyy hh24:mi') end_time,
round((end_time-start_time)*1440,2) "Minutes"
from V$RMAN_BACKUP_JOB_DETAILS
where to_char(start_time,'yyyymmdd') between '20230101' and '20231231' --and input_type='DB INCR'
order by session_key desc
) R, v$instance I 
where rownum < 10;

No comments:

Post a Comment