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

BTYPE

CHAR(9)

Backup type container. Possible values are BACKUPSET, IMAGECOPY, PROXYCOPY.

BTYPE_KEY

NUMBER

Unique identifier for the backup type, either BS_KEY or COPY_KEY.

SESSION_KEY

NUMBER

Session identifier

SESSION_RECID

NUMBER

Session recid

SESSION_STAMP

NUMBER

Session stamp

ID1

NUMBER

If BACKUPSET, it contains SET_STAMP

If IMAGECOPY or PROXYCOPY, it is RECID from the control file

ID2

NUMBER

If BACKUPSET, it contains SET_COUNT

If IMAGECOPY or PROXYCOPY, it is STAMP

CREATION_TIME

DATE

File creation time

RESETLOGS_CHANGE#

NUMBER

Resetlogs change SCN

RESETLOGS_TIME

DATE

Resetlogs change time

CHECKPOINT_CHANGE#

NUMBER

Checkpoint change SCN

CHECKPOINT_TIME

DATE

Checkpoint change time

FILESIZE

NUMBER

File size, in bytes, for the output of backing up this control file

COMPRESSION_RATIO

NUMBER

The ratio between the total blocks in the datafile and the blocks that RMAN backed up. This is not the the ratio from the AS COMPRESSED BACKUPSET clause of the BACKUP command.

FILESIZE_DISPLAY

VARCHAR2(4000)

Same value as the FILESIZE column, but converted to a user-displayable format, for example nM, nG, nT, nP, and so on

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


数据运维技术 » Oracle 视图 V$BACKUP_CONTROLFILE_DETAILS 官方解释,作用,如何使用详细说明