top of page
CerebroSQL

Oracle RMAN backup information

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

window structure

rman details operation

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

Rman log

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

Configuration Tab

Viewing and changing backup settings using the RMAN utility

rman configuration info
bottom of page