Oracle RMAN backup information

The window allows you to view detailed information about the backup using the RMAN utility.

window structure

Field "For the last" - display entries for N days

List "List backup" - a list of backup operations with the status of the operation

SELECT end_time,
input_type||' ('||
case when status = 'RUNNING WITH WARNINGS' then 'RWW'
when status = 'RUNNING WITH ERRORS' then 'RWE'
when status = 'COMPLETED' then 'C'
when status = 'COMPLETED WITH WARNINGS' then 'CWW'
when status = 'COMPLETED WITH ERRORS' then 'CWE'
when status = 'FAILED' then 'F'
else status
end||')' "Type",
status,
session_key,
session_recid,
session_stamp,
command_id,
start_time,
time_taken_display,
input_type,
output_device_type,
input_bytes_display,
INPUT_BYTES_PER_SEC_DISPLAY,
output_bytes_display,
output_bytes_per_sec_display
FROM (SELECT end_time,
status,
session_key,
session_recid,
session_stamp,
command_id,
start_time,
time_taken_display,
input_type,
output_device_type,
input_bytes_display,
INPUT_BYTES_PER_SEC_DISPLAY,
output_bytes_display,
output_bytes_per_sec_display
FROM v$rman_backup_job_details
WHERE start_time> sysdate - 10
ORDER BY start_time DESC)

block "Information" - detailed information about the selected record. The data is displayed by the same query as the information for the list "List backup"

Details tab

The tab displays detailed information about backing up database files, file sizes and the start time of the processing operation.

select a.STATUS,
to_char(open_time,'dd.mm.yyyy hh24:mi') timebegin,
round(BYTES/1024/1024,2)|| ' Mb' mbbegin,
a.type,
filename
from v$backup_async_io a
where not a.STATUS in ('UNKNOWN')
and open_time >= to_date(<Time_start>,'dd.mm.yyyy hh24:mi:ss')
and close_time <= to_date(<Time_end>,'dd.mm.yyyy hh24:mi:ss')+10/86400
order by open_time

Log Tab

Detailed RMAN session execution log

select output from V$RMAN_OUTPUT where session_stamp = $$session_stamp

Configuration Tab

Viewing and changing backup settings using the RMAN utility