V$BACKUP_DATAFILE_DETAILS

最新推荐文章于 2025-08-20 12:28:59 发布

原创最新推荐文章于 2025-08-20 12:28:59 发布 · 481 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

博客介绍了V$BACKUP_DATAFILE_DETAILS，它包含可恢复数据文件的信息，涵盖备份集中备份的所有数据文件、映像副本和代理副本等信息技术相关内容。

V$BACKUP_DATAFILE_DETAILS

V$BACKUP_DATAFILE_DETAILS contains information about restorable datafiles. It will include all datafiles 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`	Incremental level
`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`	Compression ratio
`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