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

网络编程 Oracle 视图 V$BACKUP_ARCHIVELOG_DETAILS 官方解释，作用，如何使用详细说明 10-15

本站中文解释

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 `n`M, `n`G, `n`T, `n`P, 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

编辑：广州鸿名健康科技有限公司