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 output 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
