Топ-100
 
CerebroSQL

RMAN backup information

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

Window structure
rman details operation.jpg

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

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

-> Request to retrieve data <-

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 backup"

Details Tab

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

-> Request to retrieve data <-

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 log of the RMAN session execution

Rman log.jpg

-> Request to retrieve data <-

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

-----

Configuration Tab

View and Change Backup Settings Using RMAN Utility

rman configuration info.jpg