Shareware software
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
