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

最新推荐文章于 2022-06-02 09:33:03 发布

WarriorTan

最新推荐文章于 2022-06-02 09:33:03 发布

阅读量2.2k

点赞数 1

分类专栏： Oracle动态性能视图|备份相关视图

本文链接：https://blog.csdn.net/jiaping0424/article/details/51337143

版权

Oracle动态性能视图|备份相关视图专栏收录该内容

6 篇文章 0 订阅

订阅专栏

V$BACKUP_PIECE displays information about backup pieces from the control file. Each backup set consists of one or more backup pieces.

V$BACKUP_PIECE显示有关从控制文件的备份片信息。每个备份集包含一个或多个备份片。

Column	Datatype	Description
`RECID`	`NUMBER`	Backup piece record ID
`STAMP`	`NUMBER`	Backup piece record stamp
`SET_STAMP`	`NUMBER`	Backup set stamp
`SET_COUNT`	`NUMBER`	Backup set count
`PIECE#`	`NUMBER`	Backup piece number (1-N)
`COPY#`	`NUMBER`	Indicates the copy number for backup pieces created with duplex enabled. 1 if the backup piece is not duplexed. 表示启用双重备份功能创建的备份片的拷贝数。如果备份片不是双重的则为1。
`DEVICE_TYPE`	`VARCHAR2(17)`	Type of the device on which the backup piece resides. Set to DISK for backup sets on disk. See Also: `V$BACKUP_DEVICE` 在备份片驻留的设备类型。在磁盘上的备份设置为DISK。另请参见：V $ BACKUP_DEVICE。
`HANDLE`	`VARCHAR2(513)`	Backup piece handle identifies the backup piece on restore 备份片句柄定义了转储时的备份片
`COMMENTS`	`VARCHAR2(64)`	Comment returned by the operating system or storage subsystem. Set to NULL for backup pieces on disk. This value is informational only; not needed for restore. 通过操作系统或存储子系统返回的注释，磁盘上的备份片为NULL。设置为null在磁盘上的备份片。此值仅供参考;不需要恢复。
`MEDIA`	`VARCHAR2(65)`	Name of the media on which the backup piece resides. This value is informational only; not needed for restore. 在其上备份片驻留的媒体名称。此值仅供参考;不需要恢复。
`MEDIA_POOL`	`NUMBER`	The media pool in which the copy resides. This is the same value that was entered in the `POOL` operand of the Recovery Manager`BACKUP` command. 副本所在的介质池，这和通过RMAN BACKUP命令进入POOL操作的值相同。
`CONCUR`	`VARCHAR2(3)`	(`YES` \| `NO`) Indicates whether the piece on a media that can be accessed concurrently 表示备份片所在的介质是否可以被并发的访问。
`TAG`	`VARCHAR2(32)`	Backup piece tag. The tag is specified at backup set level, but stored at piece level. 备份片标签，标签在备份集级别指定，但存储在备份片级别。
`STATUS`	`VARCHAR2(1)`	Indicates the status of the piece: `A`(available), `D` (deleted), or `X` (expired) 表示备份片的状态，A为可用，D为已经删除，X为过期。
`START_TIME`	`DATE`	Starting time
`COMPLETION_TIME`	`DATE`	Completion time
`ELAPSED_SECONDS`	`NUMBER`	Number of elapsed seconds
`DELETED`	`VARCHAR2(3)`	(`YES`/`NO`) `NO` indicates that the file still exists.`YES` indicates the file no longer exists because it has been deleted. NO表示文件仍然存在，YES表示文件再在存在，因为它已经被删除。
`BYTES`	`NUMBER`	Size of the backup piece (in bytes) 备份片大小（字节），可以用这个字段统计备份大小信息。
`IS_RECOVERY_DEST_FILE`	`VARCHAR2(3)`	Indicates whether the file was created in the fast recovery area (`YES`) or not (`NO`) 表明文件是否被创建在快速恢复区
`RMAN_STATUS_RECID`	`NUMBER`	Owning `V$RMAN_STATUS` record ID
`RMAN_STATUS_STAMP`	`NUMBER`	Owning `V$RMAN_STATUS` record stamp
`COMPRESSED`	`VARCHAR2(3)`	Indicates whether the backup piece is compressed (`YES`) or not (`NO`) 表示备份片是否被压缩
`BACKED_BY_VSS`	`VARCHAR2(3)`	Whether or not the file has been backed up by Volume Shadow Copy Service (VSS). This column is reserved for internal use. 文件是否被VSS备份，这个列被提供于内部使用。
`ENCRYPTED`	`VARCHAR2(3)`	A value of `YES` means an encrypted backup, otherwise not an encrypted backup. YES表示加密备份，否则为非加密备份。
`BACKED_BY_OSB`	`VARCHAR2(3)`	A value of `YES` means the backup was done to Oracle Secure Backup. Otherwise, backed up by other third party tape library. YES表示备份被设置为Oracle Secure Backup，否则备份为第三方带库。