Oracle教程 2023-02-24

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

V$BACKUP_COPY_SUMMARY视图是数据库备份和恢复操作的视图，显示RMAN命令复制和恢复批处理的总结，供DBA识别失败的操作。

V$BACKUP_COPY_SUMMARY视图可通过如下sql语句被访问：

SELECT * FROM v$backup_copy_summary;

V$BACKUP_COPY_SUMMARY视图的使用主要是为了检查当前正在备份的情况，包括备份起始时间、备份类型，备份的文件等。

使用V$BACKUP_COPY_SUMMARY视图可以查看执行的备份是否失败，从而及时修复备份失败的情况。

V$BACKUP_COPY_SUMMARY provides summary information for the output data file and control file copy.

Column	Datatype	Description
`NUM_COPIES`	`NUMBER`	Number of copies created
`NUM_DISTINCT_COPIES`	`NUMBER`	Number of distinct copies (that contain data files with different checkpoints)
`MIN_CHECKPOINT_CHANGE#`	`NUMBER`	Minimum checkpoint change SCN
`MAX_CHECKPOINT_CHANGE#`	`NUMBER`	Maximum checkpoint change SCN
`MIN_CHECKPOINT_TIME`	`DATE`	Minimum checkpoint change time
`MAX_CHECKPOINT_TIME`	`DATE`	Maximum checkpoint change time
`OUTPUT_BYTES`	`NUMBER`	Total number of output bytes
`OUTPUT_BYTES_DISPLAY`	`VARCHAR2(4000)`	Displayable format for output bytes
`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

分享到：