Топ-100
 
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.jpg

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

Rman log.jpg

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.jpg