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

本站中文解释

Oracle视图V$BACKUP_SET_DETAILS存储备份系统的细节，这样您可以查看每个备份存档的相关信息，例如对象、存档文件，备份集的起始、结束时间以及状态。

使用该视图的Organization查询备份的细节信息：

SELECT CLIENT_NAME, object_type, status
FROM V$BACKUP_SET_DETAILS
ORDER BY client_name;

该查询将检索系统中每个备份存档的客户端名称、对象类型、状态等信息。

官方英文解释

V$BACKUP_SET_DETAILS provides detailed information about the backup set.

This view will contain an extra row for each backup session that invokes BACKUP BACKUPSET (that is, creates new copies for the same backup set or copies backup set information from disk to tape). However, the remaining values of other columns belong to the complete backup set.

Type of device. If the backup set exists on more than one device type, an * is indicated here.

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.

The status of the backup set. It is always A (all backup pieces available), because this view only reflects available backup sets.

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

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_SET_DETAILS 官方解释，作用，如何使用详细说明