欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

RMAN备份动态性能视图 V$BACKUP_SET

程序员文章站 2022-04-06 09:59:45
...

V$BACKUP_SET 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 se


V$BACKUP_SET 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. Therefore the count must be used with the stamp to uniquely identify a 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

备份集计数。每次一个新的备份集开始备份集计数会增加1。(如果备份集从来没有完成则编号“丢失”)。如果控制文件被重新创建则计数重置为1,因此计数必须和标记一起使用来唯一地标识一个备份集。

BACKUP_TYPE VARCHAR2(1) Type of files that are in this backup. If the backup contains archived redo logs, the value is L. If this is a datafile full backup, the value is D. If this is an incremental backup, the value is I.
CONTROLFILE_INCLUDED VARCHAR2(3) Set to YES if there is a control file included in this backup set, otherwise set to NO
INCREMENTAL_LEVEL NUMBER Location where this backup set fits into the database's backup strategy. Set to NULL for full datafile, archivelog, controlfile, and spfile backups, set to 0 for incremental level 0 datafile backups, and set to 1 for incremental level 1 datafile backups.
PIECES NUMBER Number of distinct backup pieces in the backup set
START_TIME DATE Starting time
COMPLETION_TIME DATE Time that this backup set completed
ELAPSED_SECONDS NUMBER The number of elapsed seconds
BLOCK_SIZE NUMBER Block size of the backup set
INPUT_FILE_SCAN_ONLY VARCHAR2(3) YES indicates no actual backup is performed, but the datafiles are read. NO indicates a normal backup is performed.
KEEP VARCHAR2(3) (YES/NO) Indicates whether or not this backup set has a retention policy that is different than the value for the configure retention policy
KEEP_UNTIL DATE If KEEP_UNTIL_TIME is specified, this is the date after which the backup becomes obsolete. If this column is null, then the backup never expires.
KEEP_OPTIONS VARCHAR2(10) Lists additional retention options for this backup set. Possible values are:

LOGS - The logs need to recover this backup are kept

NOLOGS - The logs needed to recover this backup will not be kept

BACKUP_LOGS - An archive log backup exists to support this backup set

MULTI_SECTION VARCHAR2(3) Indicates whether or not this backup set is a multi-section backup. Valid values are YES andNO. A multi-section backup is a backup in which multiple backup pieces are produced independently in parallel by multiple channels.

该视图查看的信息与RMAN中命令LIST BACKUP类似,只不过表示形式不同。其中BACKUP_TYPE列标记该备份集中包含的文件类型,有下列几个值:

L:表示包含归档重做日志文件;

D:表示数据文件完全备份;

I:表示增量备份。

还有一个常用的关联视图V$BACKUP_SET_DETAILS,该视图除了包含V$BACKUP_SET中的数据外,还额外记录了备份集的详细信息,比如备份集大小、备份集所在设备等。额外的列也都比较简单,用字面意义理解列定义即可。