RMAN备份动态性能视图 V$BACKUP_SET
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 the 备份集标记。备份集标记和计数唯一地标识了备份集。 |
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 the
|
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:
|
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中的数据外,还额外记录了备份集的详细信息,比如备份集大小、备份集所在设备等。额外的列也都比较简单,用字面意义理解列定义即可。
下一篇: RMAN备份进度查询