Oracle教程

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

本站中文解释

Oracle视图V$BACKUP_ARCHIVELOG_DETAILS视图用于查询归档日志的备份信息。该视图的数据来源是V$BACKUP_ARCHIVELOG和V$BACKUP_FILES_DETAILS视图。

V$BACKUP_ARCHIVELOG_DETAILS表主要用于检索归档日志的备份信息，它描述了每次归档日志备份所用到的输出。它反映了一个归档日志备份运行时所记录下的全部信息。该表视图当前仅包含 RMAN 手动和自动归档日志备份运行时记录的信息。

该视图可以在任何时间检索和查询该归档日志备份信息。例如，可以检索每次归档日志备份所用到输出、所使用的备份媒体、恢复的起始一致性时间，以及发生的错误等等。

使用该视图可以轻松跟踪归档日志备份的作业。

下面是使用该视图的示例：

SELECT * FROM V$BACKUP_ARCHIVELOG_DETAILS;

官方英文解释

V$BACKUP_ARCHIVELOG_DETAILS contains information about all restorable archive logs.

It will include all archived logs backed up in a backup set or proxy copies.

Column Datatype Description

BTYPE

CHAR(9)

Backup type container, either BACKUPSET or 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 recid

SESSION_STAMP

NUMBER

Session stamp

ID1

NUMBER

If BACKUPSET, it contains SET_STAMP

If PROXYCOPY, it is RECID from the control file

ID2

NUMBER

If BACKUPSET, it contains SET_COUNT

If PROXYCOPY, it is STAMP

THREAD#

NUMBER

Thread number

SEQUENCE#

NUMBER

Sequence number

RESETLOGS_CHANGE#

NUMBER

Resetlogs change SCN

RESETLOGS_TIME

DATE

Resetlogs change time

FIRST_CHANGE#

NUMBER

First change SCN

FIRST_TIME

DATE

First change time

NEXT_CHANGE#

NUMBER

Next change SCN

NEXT_TIME

DATE

Next change time

FILESIZE

NUMBER

File size

COMPRESSION_RATIO

NUMBER

The ratio between the total blocks in the archive log and the blocks that RMAN backed up. This is not 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_ARCHIVELOG_DETAILS 官方解释，作用，如何使用详细说明
分享到：

相关推荐