Oracle教程 2023-04-01

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

Oracle 视图V$BACKUP_SPFILE_SUMMARY提供关于最近使用OS系统备份的服务器参数文件汇总信息。汇总信息包括备份开始时间、备份大小、备份对象（SPFILE）等。

使用V$BACKUP_SPFILE_SUMMARY关联V$DATABASE，可以查看指定实例的SPFILE的备份汇总信息，比如备份时间和文件大小：

SELECT b.backup_date, b.backup_size
FROM V$BACKUP_SPFILE_SUMMARY b
JOIN V$DATABASE d ON b.dbkey = d.dbkey;

V$BACKUP_SPFILE_SUMMARY provides summary information for input SP file, based on either a backup job or time range applicable to jobs.

Column	Datatype	Description
`NUM_FILES_BACKED`	`NUMBER`	Number of files backed up
`NUM_DISTINCT_FILES_BACKED`	`NUMBER`	Number of distinct SP files backed up (with modification timestamp)
`MIN_MODIFICATION_TIME`	`DATE`	Minimum modification time
`MAX_MODIFICATION_TIME`	`DATE`	Maximum modification time
`INPUT_BYTES`	`NUMBER`	Total input bytes for all SP files backed up
`INPUT_BYTES_DISPLAY`	`VARCHAR2(4000)`	Displayable format for all input 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

分享到：