Oracle查看RMAN备份大小

原创

已于 2024-11-04 09:39:58 修改 · 2k 阅读

20 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #数据库

于 2024-04-15 17:19:05 首次发布

查看RMAN历史备份情况及大小

select to_char(start_time, 'yyyy-mm-dd') start_time,
       INCREMENTAL_LEVEL,
       BACKUP_TYPE,
       device_type,
       to_char(start_time, 'day') day,
       round(sum(OUTPUT_BYTES) / 1024 / 1024 / 1024, 2) SIZE_GB
  from v$backup_set_details
 group by to_char(start_time, 'yyyy-mm-dd'),
          to_char(start_time, 'day'),
          INCREMENTAL_LEVEL,
          BACKUP_TYPE,device_type
 order by start_time desc;

最后一次全备时间及大小

incremental_level = 0

select *
  from (select to_char(start_time, 'yyyy-mm-dd') start_time,
               INCREMENTAL_LEVEL,
               BACKUP_TYPE,
               device_type,
               to_char(start_time, 'day') day,
               round(sum(OUTPUT_BYTES) / 1024 / 1024 / 1024, 2) SIZE_GB
          from v$backup_set_details
         where incremental_level = 0
         group by to_char(start_time, 'yyyy-mm-dd'),
                  INCREMENTAL_LEVEL,
                  BACKUP_TYPE,
                  device_type,
                  to_char(start_time, 'day')
         order by start_time desc) c
 where rownum = 1;

v$backup_set_details displays information about backup sets from the control file. A backup set record is inserted after the backup set is successfully completed.

Column	Datatype	Description
RECID	NUMBER	Backup set record ID
STAMP	NUMBER	Backup set record stamp
SET_STAMP	NUMBER	Backup set stamp. The backup set stamp and count uniquely identify the backup set. Primary key for theV$BACKUP_SET table, and the foreign key for the following tables: V$BACKUP_PIECE,V$BACKUP_DATAFILE, V$BACKUP_REDOLOG,V$BACKUP_CORRUPTION. 备份集标记。备份集标记和计数唯一地标识了备份集。
SET_COUNT	NUMBER	Backup set count. The backup set count is incremented by one every time a new backup set is started (if the backup set is never completed the number is "lost"). If the control file is re-created then the count is reset to 1.