This view lists all backup files (backup pieces, proxy copies or image copies) that are marked UNAVAILABLE or EXPIRED. You can select a row and, using BTYPE_KEY or FILETYPE_KEY, change the status of a backup set or specific file to AVAILABLE.
This view is primarily intended to be used internally by Enterprise Manager.
The DB_NAME of the database incarnation to which this record belongs.
The primary key for this database in the recovery catalog. Use this column to join with almost any other catalog view.
Session identifier. Use in joins with RC_RMAN_OUTPUT and RC_RMAN_BACKUP_JOB_DETAILS.
Unique key for the row in RC_RMAN_STATUS corresponding to the job that created this file.
The backup type container, which can be BACKUPSET, IMAGECOPY, or PROXYCOPY.
Unique identifier for the backup type. It is BS_KEY/COPY_KEY.
For backups taken as backup sets, this column contains SET_STAMP. For proxy copy or image copy backups, this column contains the RECID from the control file.
For backups taken as backup sets, ID2 contains SET_COUNT. For image copy and proxy copy backups ID2 contains STAMP.
The type of this backup file. Possible values are BACKUPPIECE, COPY, or PROXYCOPY.
Backup piece key if the file is a backup piece, other wise COPY_KEY. You can use this key to directly change the status of the file to available.
Can be either U (for unavailable backups) or X (for expired backups).
Size in bytes of the unusable backup file.
Device type storing this unusable backup file. Possible values are DISK and SBT_TAPE.
A comment that contains further information about the media manager that created this backup.
The number of the media pool in which the backup is stored.