Oracle查看RMAN备份情况

查看近两天的备份情况

set linesize 180 pagesize 200
col inc_lev for 9999
col device_type for a8
col bs_key for 99999
col elap_MIN FOR 999999
SELECT bs.recid bs_key
  , DECODE(backup_type, 'L', 'Archived Redo Logs', 'D', 'Datafile Full Backup', 'I', 'Incremental Backup') backup_type
  ,  device_type  
  ,  DECODE(bs.controlfile_included, 'NO', '-', bs.controlfile_included)    controlfile_included
  , bs.incremental_level inc_lev ,  bs.start_time, bs.completion_time, bs.elapsed_seconds/60   elap_MIN                                                                                        
FROM
    v$backup_set    bs
  , (select distinct set_stamp, set_count, tag, device_type
     from v$backup_piece
     where status in ('A', 'X'))           bp
WHERE bs.start_time>sysdate-2 
  AND bs.set_stamp = bp.set_stamp
  AND bs.set_count = bp.set_count
ORDER BY bs.recid;

BS_KEY BACKUP_TYPE          DEVICE_T CON INC_LEV START_TIME   COMPLETION_T ELAP_MIN
------ -------------------- -------- --- ------- ------------ ------------ --------
 61758 Incremental Backup   DISK     -         1 03-DEC-21    03-DEC-21           0
 61759 Datafile Full Backup DISK     YES         03-DEC-21    03-DEC-21           0
 61760 Datafile Full Backup DISK     YES         03-DEC-21    03-DEC-21           0
 61761 Datafile Full Backup DISK     YES         03-DEC-21    03-DEC-21           0
 61762 Incremental Backup   DISK     -         1 03-DEC-21    03-DEC-21           0
 61763 Datafile Full Backup DISK     YES         03-DEC-21    03-DEC-21           0
 61764 Datafile Full Backup DISK     YES         03-DEC-21    03-DEC-21           0
 61765 Datafile Full Backup DISK     YES         03-DEC-21    03-DEC-21           0
 61766 Incremental Backup   DISK     -         1 03-DEC-21    03-DEC-21           0
 61767 Datafile Full Backup DISK     YES         03-DEC-21    03-DEC-21           0
 61768 Datafile Full Backup DISK     YES         03-DEC-21    03-DEC-21           0
 61769 Datafile Full Backup DISK     YES         03-DEC-21    03-DEC-21           0
 61770 Incremental Backup   DISK     -         1 03-DEC-21    03-DEC-21           8
 61771 Datafile Full Backup DISK     YES         03-DEC-21    03-DEC-21           0
 61772 Datafile Full Backup DISK     YES         03-DEC-21    03-DEC-21           0
 61773 Datafile Full Backup DISK     YES         03-DEC-21    03-DEC-21           0
 61774 Incremental Backup   DISK     -         1 03-DEC-21    03-DEC-21           0
 61775 Datafile Full Backup DISK     YES         03-DEC-21    03-DEC-21           0
 61776 Datafile Full Backup DISK     YES         03-DEC-21    03-DEC-21           0
 61777 Datafile Full Backup DISK     YES         03-DEC-21    03-DEC-21           0

查看备份详细信息，如备份时长，备份速率等

col TIME_TAKEN_DISPLAY for a10
col INPUG_SIZE for a10
col OUTPUG_SIZE for a10
col "output/s" for a10
col status for a10
col OUT_P for a5
select start_time,time_taken_display,status, input_type, 
output_device_type OUT_P, input_bytes_display INPUG_SIZE, output_bytes_display OUTPUG_SIZE, output_bytes_per_sec_display as "output/s"
     from v$rman_backup_job_details
     where start_time>sysdate-2
     order by start_time DESC;

START_TIME   TIME_TAKEN STATUS     INPUT_TYPE    OUT_P INPUG_SIZE OUTPUG_SIZ output/s
------------ ---------- ---------- ------------- ----- ---------- ---------- ----------
04-DEC-21    06:00:19   COMPLETED  DB FULL       DISK      1.65T    356.09G     16.87M
04-DEC-21    00:00:42   COMPLETED  DB INCR       DISK      6.47G    179.70M      4.28M
04-DEC-21    00:25:03   COMPLETED  DB INCR       DISK    863.60G      3.31G      2.26M
04-DEC-21    00:00:34   COMPLETED  DB INCR       DISK      1.50G    178.20M      5.24M
04-DEC-21    00:05:43   COMPLETED  DB INCR       DISK    213.78G    178.29M    532.27K
04-DEC-21    00:01:03   COMPLETED  DB INCR       DISK     11.72G    177.88M      2.82M
04-DEC-21    00:07:59   COMPLETED  DB INCR       DISK    280.83G    178.94M    382.53K
04-DEC-21    00:00:54   COMPLETED  DB INCR       DISK     14.79G    203.09M      3.76M
04-DEC-21    00:00:43   COMPLETED  DB INCR       DISK      4.29G    178.66M      4.15M
04-DEC-21    00:00:31   COMPLETED  DB INCR       DISK      2.25G    178.18M      5.75M
03-DEC-21    00:00:42   COMPLETED  DB INCR       DISK      6.47G    178.53M      4.25M
03-DEC-21    00:28:43   COMPLETED  DB INCR       DISK    862.26G      3.34G      1.99M
03-DEC-21    00:00:34   COMPLETED  DB INCR       DISK      1.50G    178.24M      5.24M
03-DEC-21    00:06:04   COMPLETED  DB INCR       DISK    213.78G    178.28M    501.54K
03-DEC-21    00:01:03   COMPLETED  DB INCR       DISK     11.72G    177.96M      2.82M
03-DEC-21    00:08:04   COMPLETED  DB INCR       DISK    280.83G    184.77M    390.91K
03-DEC-21    00:00:54   COMPLETED  DB INCR       DISK     14.79G    256.85M      4.76M
03-DEC-21    00:00:44   COMPLETED  DB INCR       DISK      4.29G    178.77M      4.06M
03-DEC-21    00:00:35   COMPLETED  DB INCR       DISK      2.25G    178.29M      5.09M

19 rows selected.