Oracle 视图 V$BACKUP_CONTROLFILE_DETAILS 官方解释,作用,如何使用详细说明
本站中文解释
V$BACKUP_CONTROLFILE_DETAILS是Oracle数据库中的一个动态视图,用于报告控制文件的备份参数。它由V$RMAN_BACKUP_CONTROLFILE_DETAILS视图继承而来,其中包含有关控制文件备份的关键信息,包括每次备份的文件名、备份开始和结束时间、备份类型(最新备份、全备份或增量备份)、完成备份的SCN号等等。
可以使用这个视图来检查备份控制文件的状态,例如是否需要新的备份,比如上次的备份是几小时之前的,存在视图V$BACKUP_CONTROLFILE_DETAILS中的上次备份时间可以帮助DBA实现此功能。
例如,在SQL查询中使用以下语句可以查询最新的控制文件备份的完成时间:
SELECT MAX(END_TIME) FROM V$BACKUP_CONTROLFILE_DETAILS;
官方英文解释
V$BACKUP_CONTROLFILE_DETAILS
contains information about restorable control files.
It will include all the control files backed up in the backup set, image copies, and proxy copies.
Column | Datatype | Description |
---|---|---|
|
|
Backup type container. Possible values are |
|
|
Unique identifier for the backup type, either |
|
|
Session identifier |
|
|
Session recid |
|
|
Session stamp |
|
|
If If |
|
|
If If |
|
|
File creation time |
|
|
Resetlogs change SCN |
|
|
Resetlogs change time |
|
|
Checkpoint change SCN |
|
|
Checkpoint change time |
|
|
File size, in bytes, for the output of backing up this control file |
|
|
The ratio between the total blocks in the datafile and the blocks that RMAN backed up. This is not the the ratio from the |
|
|
Same value as the |
|
|
The ID of the container to which the data pertains. Possible values include:
|