9.127 V$UNUSABLE_BACKUPFILE_DETAILS

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