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

本站中文解释

Oracle视图V$BACKUP_PIECE_DETAILS用于查询数据库备份块的信息。在Oracle 11gR2中，可以使用此视图用于监控和检索备份块的信息。

它存储了关于备份和还原操作的所有细节，可以提供诸如完成日期和时间、进度、备份和恢复运行时长、警告、错误等细节。可以使用这些信息来监测备份进度，检查备份性能，查找/解决备份失败和错误等。

使用方法：

要查询V$BACKUP_PIECE_DETAILS视图，可以运行下列SQL查询：

SELECT * FROM V$BACKUP_PIECE_DETAILS

该查询将显示关于所有备份块的详细信息。可以使用where子句限定您感兴趣的备份块，例如：

SELECT * FROM V$BACKUP_PIECE_DETAILS
WHERE STATUS = COMPLETED

这可以返回已成功完成的备份块的信息。

官方英文解释

V$BACKUP_PIECE_DETAILS displays information about all available backup pieces.

Indicates the copy number for backup pieces created with duplex enabled. The value is 1 if the backup piece is not duplexed.

Type of device on which the backup piece resides. Set to DISK for backup sets on disk.

Comments returned by the operating system or storage subsystem. Set to NULL for backup pieces on disk. This value is informational only. It is not needed for restore.

Name of the media on which the backup piece resides. This value is informational only. It is not needed for restore.

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.

(YES|NO) indicates whether or not the piece is on a media that can be accessed concurrently

Backup piece tag. The tag is specified at backup set level, but stored at piece level.

NO indicates that the file still exists. YES indicates that the file no longer exists because it has been deleted.

Indicates whether or not the file was created in the fast recovery area (YES) or not (NO)

Whether or not the file has been backed up by Volume Shadow Copy Service (VSS). This column is reserved for internal use.

A value of YES means the backup was done to Oracle Secure Backup. Otherwise, backed up by other third party tape library.

If the value of FOR_XTTS is YES, then this column indicates whether the backup piece has the same endianess as the current database (YES) or not (NO); otherwise NULL.

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.

我想要获取技术服务或软件
服务范围：MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式：远程服务、电话支持、现场服务，沟通指定方式服务
技术标签：数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题

本站部分文章参考或来源于网络，如有侵权请联系站长。
数据库远程运维 Oracle 视图 V$BACKUP_PIECE_DETAILS 官方解释，作用，如何使用详细说明