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

本站中文解释

视图

V$BACKUP_DATAFILE_DETAILS视图显示的是一个特定的备份的数据文件的细节信息,其中包括每个数据文件的状态和备份时间,以及备份文件在备份中所占用的控件块数。

V$BACKUP_DATAFILE_DETAILS视图可用于跟踪备份活动,允许您轻松地查看所有备份文件的备份时间以及所备份的控件块数量,这允许您更轻松地识别哪些数据文件已备份,并确定哪些数据文件没有得到备份。

V$BACKUP_DATAFILE_DETAILS视图的使用方法:

要使用此视图查看特定的数据文件的备份详细信息,你可以使用如下查询:

SELECT FILE_NAME, STATUS, STATS_TIME, BLOCKS_ALLOCATED
FROM V$BACKUP_DATAFILE_DETAILS
WHERE FILE_NAME = ”;

在此查询中,应替换为要检查的特定数据文件的名称。

另一种方法是,您可以查询所有文件的备份内容:

SELECT FILE_NAME, STATUS, STATS_TIME, BLOCKS_ALLOCATED
FROM V$BACKUP_DATAFILE_DETAILS;

官方英文解释

V$BACKUP_DATAFILE_DETAILS contains information about restorable data files.

It will include all data files backed 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. For BACKUPSET, it is BS_KEY.

SESSION_KEY

NUMBER

Session identifier

SESSION_RECID

NUMBER

Session record ID

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.

FILE#

NUMBER

File number

CREATION_CHANGE#

NUMBER

File creation change SCN

CREATION_TIME

DATE

File creation time

RESETLOGS_CHANGE#

NUMBER

Resetlogs change SCN

RESETLOGS_TIME

DATE

Resetlogs change time

INCREMENTAL_LEVEL

NUMBER

Normal full backups have a NULL value, level 0 incremental backups have a value of 0, and level 1 incremental backups have a value of 1

INCREMENTAL_CHANGE#

NUMBER

Incremental change SCN

CHECKPOINT_CHANGE#

NUMBER

Checkpoint change SCN

CHECKPOINT_TIME

DATE

Checkpoint change time

MARKED_CORRUPT

NUMBER

Number of blocks marked corrupt

FILESIZE

NUMBER

File size, in bytes

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.

SPARSE_BACKUP

VARCHAR2(3)

Indicates whether the file is sparse (YES) or not (NO)

TS#

NUMBER

Tablespace number

TSNAME

VARCHAR2(30)

Tablespace name

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_DATAFILE_DETAILS 官方解释,作用,如何使用详细说明