Oracle教程

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

本站中文解释

V$UNUSABLE_BACKUPFILE_DETAILS视图是查看当前不可用的备份文件的视图，属于V$BACKUPFILE_DETAILS的扩展。它包含了备份文件的可用性状态和无效原因信息，用于调试错误的时候分析用，也可以用于检查当前备份在RMAN中的不可用状态。

使用方法：

1. 打开SQLPlus会话，使用SYSDBA用户登录；

2. 执行SELECT * FROM v$unusable_backupfile_details语句；

3. 查询结果会显示各个无效备份文件的信息，包括文件名，无效原因等；

4. 如果查询无结果，表明当前备份已经都可以使用；

5. 如果有结果，可以根据无效原因排查相关的错误，然后解决问题。

官方英文解释

V$UNUSABLE_BACKUPFILE_DETAILS displays information about all backup files (backup pieces, proxy copies, or copies) that are marked unavailable and expired. You can select one of the rows and use BTYPE_KEY or FILETYPE_KEY to change the status of a backup file set or a specific file to available.
Column Datatype Description

SESSION_KEY

NUMBER

Session identifier

SESSION_RECID

NUMBER

Session record ID

SESSION_STAMP

NUMBER

Session stamp

RMAN_STATUS_RECID

NUMBER

Record ID of the corresponding row in the control file

RMAN_STATUS_STAMP

NUMBER

Timestamp of the row in the controlfile

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.

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.

FILETYPE

VARCHAR2(15)

Type of file. Possible values are: BACKUPPIECE, COPY, PROXYCOPY.

FILETYPE_KEY

NUMBER

Backup piece key if the file is a backup piece; otherwise COPY_KEY.

STATUS

VARCHAR2(1)

Status of the backup file, either U (unavailable) or X (expired)

FILESIZE

NUMBER

Size of the file

DEVICE_TYPE

VARCHAR2(17)

Type of device on which the file resides

FILENAME

VARCHAR2(513)

Name of the file

MEDIA

VARCHAR2(65)

Name of the media on which the copy resides. This value is informational only. It is not needed for restore.

MEDIA_POOL

NUMBER

Media pool in which the copy resides. This is the same value that was entered in the POOL operand of the Recovery Manager BACKUP command.

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$UNUSABLE_BACKUPFILE_DETAILS 官方解释，作用，如何使用详细说明
分享到：

相关推荐