Oracle 视图 V$BACKUP_CONTROLFILE_SUMMARY 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图V$BACKUP_CONTROLFILE_SUMMARY是Oracle数据库的动态性能视图,查看控制文件的备份信息。它的成员变量主要有:OFFLINE_RANGE,STATUS,BACKUP_SET_MASTER,BACKUP_MEMBER,BACKUP_PIECE, ENDSCNS, STARTSCNS,FILE_TYPE, START_TIME和END_TIME等。它可以用来检查控制文件是否已成功备份,备份开始结束时间,备份文件类型,备份控制文件SCN号码等各项信息。
使用V$BACKUP_CONTROLFILE_SUMMARY视图可以利用如下SQL查询相关信息:
SELECT OFFLINE_RANGE,STATUS,BACKUP_SET_MASTER,BACKUP_MEMBER, BACKUP_PIECE, ENDSCNS, STARTSCNS,FILE_TYPE, START_TIME,END_TIME FROM V$ BACKUP_CONTROLFILE_SUMMARY;
官方英文解释
V$BACKUP_CONTROLFILE_SUMMARY
provides control file summary information, based on either a backup set of files, image copies, or proxy copies.
Column | Datatype | Description |
---|---|---|
|
|
Number of files backed up for specific criteria |
|
|
Number of distinct files 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:
|