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 |
ID2 |
NUMBER |
If BACKUPSET, it contains SET_COUNT.
If |
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. |