Oracle 视图 V$BACKUP_DATAFILE_SUMMARY 官方解释，作用，如何使用详细说明
本站中文解释
Oracle 视图V$BACKUP_DATAFILE_SUMMARY提供了一个总结在备份过程中每个数据文件上涉及的备份块数和重新映射块数的视图。
V$BACKUP_DATAFILE_SUMMARY 的用途：
1. 检查每个文件被备份了多少块。
2. 检查有多少个重新映射块在备份过程中出现。
3. 检查某个文件是否在数据库备份过程中被备份。
如何使用：
可以使用查询如下来查询V$BACKUP_DATAFILE_SUMMARY 视图：
SELECT FILE#,BLOCKS,REMAP_BLKS
FROM V$BACKUP_DATAFILE_SUMMARY;
官方英文解释
V$BACKUP_DATAFILE_SUMMARY provides summary information for a specific criteria set, based on a backup job, a time range applicable to jobs, or a specific data file).
| Column | Datatype | Description |
|---|---|---|
|
| Number of files backed up for specified criteria |
|
| Number of distinct files backed up |
|
| Number of distinct tablespaces backed up |
|
| Minimum checkpoint change number of the data file for specified criteria |
|
| Maximum checkpoint change number of the data file for specified criteria |
|
| Minimum checkpoint time of the data file for specified criteria |
|
| Maximum checkpoint time of the data file for specified criteria |
|
| Total input bytes of files read |
|
| Total output bytes written |
|
| The ratio between the total blocks in the datafile and the blocks that RMAN backed up. This is not the the ratio from the |
|
| Displayable format for input bytes |
|
| Displayable format for output bytes |
|
| The ID of the container to which the data pertains. Possible values include:
|