Oracle教程 2023-02-24

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

Oracle视图V$BACKUP_ARCHIVELOG_SUMMARY为用户提供了一种查看归档日志文件备份情况的方法.

该视图中包含备份归档日志文件的状态和情况，主要有：存放的位置、归档的序列号、生成时间、活跃状态、备份进度等信息.

使用方法：

1.登录SQL*Plus，输入如下SQL语句：
select * from V$BACKUP_ARCHIVELOG_SUMMARY

2.运行查询语句可以获得备份归档日志文件的总体状况，以及每个归档日志文件的详细信息。

3.用户可以利用该表来检查归档日志文件是否备份完成，或者查询需要恢复的归档日志文件位置、归档日志文件的生成时间等信息。

V$BACKUP_ARCHIVELOG_SUMMARY provides archive log summary information based on archive logs in the backup set or on proxy copies.

Column	Datatype	Description
`NUM_FILES_BACKED`	`NUMBER`	Number of files backed up
`NUM_DISTINCT_FILES_BACKED`	`NUMBER`	Number of distinct archive log files backed up
`MIN_FIRST_CHANGE#`	`NUMBER`	Lowest SCN range value
`MAX_NEXT_CHANGE#`	`NUMBER`	Highest SCN range value
`MIN_FIRST_TIME`	`DATE`	Lowest SCN range time
`MAX_NEXT_TIME`	`DATE`	Highest SCN range time
`INPUT_BYTES`	`NUMBER`	Total input bytes read
`OUTPUT_BYTES`	`NUMBER`	Output size of backups
`COMPRESSION_RATIO`	`NUMBER`	The ratio between the total blocks in the archive log and the blocks that RMAN backed up. This is not the ratio from the `AS COMPRESSED BACKUPSET` clause of the `BACKUP` command.
`INPUT_BYTES_DISPLAY`	`VARCHAR2(4000)`	Displayable format for input 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

分享到：