Oracle 视图 V$BACKUP_DATAFILE_DETAILS 官方解释，作用，如何使用详细说明

本站中文解释

视图

V$BACKUP_DATAFILE_DETAILS视图显示的是一个特定的备份的数据文件的细节信息，其中包括每个数据文件的状态和备份时间，以及备份文件在备份中所占用的控件块数。

V$BACKUP_DATAFILE_DETAILS视图可用于跟踪备份活动，允许您轻松地查看所有备份文件的备份时间以及所备份的控件块数量，这允许您更轻松地识别哪些数据文件已备份，并确定哪些数据文件没有得到备份。

V$BACKUP_DATAFILE_DETAILS视图的使用方法：

要使用此视图查看特定的数据文件的备份详细信息，你可以使用如下查询：

SELECT FILE_NAME, STATUS, STATS_TIME, BLOCKS_ALLOCATED
FROM V$BACKUP_DATAFILE_DETAILS
WHERE FILE_NAME = ”;

在此查询中，应替换为要检查的特定数据文件的名称。

另一种方法是，您可以查询所有文件的备份内容：

SELECT FILE_NAME, STATUS, STATS_TIME, BLOCKS_ALLOCATED
FROM V$BACKUP_DATAFILE_DETAILS;

官方英文解释

V$BACKUP_DATAFILE_DETAILS contains information about restorable data files.

It will include all data files backed in the backup set, image copies, and proxy copies.

Column	Datatype	Description
`BTYPE`	`CHAR(9)`	Backup type container. Possible values are: `BACKUPSET`, `IMAGECOPY`, `PROXYCOPY`.
`BTYPE_KEY`	`NUMBER`	Unique identifier for the backup type. For `BACKUPSET`, it is `BS_KEY`.
`SESSION_KEY`	`NUMBER`	Session identifier
`SESSION_RECID`	`NUMBER`	Session record ID
`SESSION_STAMP`	`NUMBER`	Session stamp
`ID1`	`NUMBER`	If `BACKUPSET`, it contains `SET_STAMP`. If `IMAGECOPY` or `PROXYCOPY`, it is `RECID` from the control file.
`ID2`	`NUMBER`	If `BACKUPSET`, it contains `SET_COUNT`. If `IMAGECOPY` or `PROXYCOPY`, it is `STAMP`.
`FILE#`	`NUMBER`	File number
`CREATION_CHANGE#`	`NUMBER`	File creation change SCN
`CREATION_TIME`	`DATE`	File creation time
`RESETLOGS_CHANGE#`	`NUMBER`	Resetlogs change SCN
`RESETLOGS_TIME`	`DATE`	Resetlogs change time
`INCREMENTAL_LEVEL`	`NUMBER`	Normal full backups have a NULL value, level 0 incremental backups have a value of 0, and level 1 incremental backups have a value of 1
`INCREMENTAL_CHANGE#`	`NUMBER`	Incremental change SCN
`CHECKPOINT_CHANGE#`	`NUMBER`	Checkpoint change SCN
`CHECKPOINT_TIME`	`DATE`	Checkpoint change time
`MARKED_CORRUPT`	`NUMBER`	Number of blocks marked corrupt
`FILESIZE`	`NUMBER`	File size, in bytes
`COMPRESSION_RATIO`	`NUMBER`	The ratio between the total blocks in the datafile and the blocks that RMAN backed up. This is not the the ratio from the `AS COMPRESSED BACKUPSET` clause of the `BACKUP` command.
`SPARSE_BACKUP`	`VARCHAR2(3)`	Indicates whether the file is sparse (`YES`) or not (`NO`)
`TS#`	`NUMBER`	Tablespace number
`TSNAME`	`VARCHAR2(30)`	Tablespace name
`FILESIZE_DISPLAY`	`VARCHAR2(4000)`	Same value as the `FILESIZE` column, but converted to a user-displayable format, for example `n`M, `n`G, `n`T, `n`P, and so on
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

Oracle 视图 V$BACKUP_DATAFILE_DETAILS 官方解释，作用，如何使用详细说明

本站中文解释

官方英文解释

相关推荐

热门文章