RC_BACKUP_FILES

This view lists backups known to the RMAN repository as reflected in the recovery catalog. This view corresponds to the V$BACKUP_FILES control file view.

Note:

It is usually more convenient to access this information using the LIST BACKUP and LIST COPY commands from within RMAN.
You must use DBMS_RCVMAN.SetDatabase to select a database from the recovery catalog schema before you can use this view.

Column	Datatype	Description
`PKEY`	`NUMBER`	The primary key for the backup.
`BACKUP_TYPE`	VARCHAR2(32)	The type of the backup: `BACKUP SET`, `COPY` or `PROXY COPY`.
`FILE_TYPE`	VARCHAR2(32)	Type of the file backed up: `DATAFILE`, `CONTROLFILE`, `SPFILE`, `REDO LOG`, `COPY` (for an image copy backup) or `PIECE` (for a backup piece).
`KEEP`	VARCHAR2(3)	Whether this backup has KEEP attributes set that override the retention policy. Values are `YES` or `NO`.
`KEEP_UNTIL`	DATE	Date after which this backup is considered obsolete.
`KEEP_OPTIONS`	VARCHAR2(13)	"Keep attributes" affecting retention for this backup. Possible values are: `LOGS` (retain all redo logs needed to recover this backup as long as the backup is retained), `NOLOGS` (redo logs may be considered obsolete even if this backup must be retained), and `NULL` (let the configured retention policy apply to this backup).
`STATUS`	VARCHAR2(16)	Status of the backup. Possible values are: `AVAILABLE`, `UNAVAILABLE`, `EXPIRED`.
`FNAME`	VARCHAR2(1024)	Filename of this piece, copy or filename of the file included in this backup set. For example, for row with backup_type is "`BACKUP SET`" and file_type is "DATAFILE", FNAME is the name of the datafile in the backup. On the other hand, if BACKUP_TYPE is "BACKUP SET" and file_type is "PIECE", then fname shows the name of backup piece.
`TAG`	VARCHAR2(32)	The tag for this backup piece or image copy. (Valid only if FILE_TYPE is PIECE or COPY.)
`MEDIA`	VARCHAR2(80)	Media ID for the media on which the backup is stored. Valid only if BACKUP_TYPE is "BACKUP SET" and FILE_TYPE is "PIECE".
`RECID`	NUMBER	Recid of the control file record corresponding to this row.
`STAMP`	NUMBER	Timestamp of the control file record corresponding to this row.
`DEVICE_TYPE`	VARCHAR2(255)	Device type on which this backup is stored. Valid only if FILE_TYPE is PIECE or COPY.
`BLOCK_SIZE`	NUMBER	Block size for the backup or copy (in bytes).
`COMPLETION_TIME`	NUMBER	Time when this backup was completed. Valid only if FILE_TYPE is PIECE or COPY.
`COMPRESSED`	VARCHAR2(3)	Whether the backup piece represented by this row is compressed. Valid only if file-type is PIECE (since image copies cannot be compressed, by definition).
`OBSOLETE`	VARCHAR2(3)	Whether this backup piece or copy is obsolete. Possible value: YES, NO. Valid only if FILE_TYPE is PIECE or COPY
`BYTES`	NUMBER	Size of file described by this row. If FILE_TYPE is BACKUP SET, this represents the total size of the backup set. If FILE_TYPE is PIECE or COPY, then this represents the size of the individual file. If FILE_TYPE is DATAFILE, ARCHIVED LOG, SPFILE or CONTROL FILE, the value represents how much data was incorporated into the backup set (but note that the corresponding backup set may be smaller, if compression was used in creating the backup set).
`BS_KEY`	NUMBER	Backup set key. Valid only if FILE_TYPE is BACKUP SET.
`BS_COUNT`	NUMBER	Backup set count. Valid only if FILE_TYPE is BACKUP SET.
`BS_STAMP`	NUMBER	Backup set timestamp. Valid only if FILE_TYPE is BACKUP SET.
`BS_TYPE`	VARCHAR2(32)	Type of backup set contents (datafiles or archived redo logs). Valid only if FILE_TYPE is BACKUP SET.
`BS_INCR_TYPE`	VARCHAR(32)	Backup set incremental type (full or not). Valid only if FILE_TYPE is BACKUP SET.
`BS_PIECES`	NUMBER	Number of pieces in backup set. Valid only if FILE_TYPE is BACKUP SET.
`BS_COPIES`	NUMBER	Number of copies of this backup set. Valid only if FILE_TYPE is BACKUP SET.
`BS_COMPLETION_TIME`	DATE	Completion time of the backup set. Valid only if FILE_TYPE is BACKUP SET.
`BS_STATUS`	VARCHAR2(16)	Status of the backup set. Possible values are `AVAILABLE`, UNAVAILABLE, EXPIRED, or OTHER. (OTHER means that not all pieces of the backup set have the same status, which can happen if some are `AVAILABLE` and others UNAVAILABLE..) Valid only if FILE_TYPE is BACKUP SET.
`BS_BYTES`	NUMBER	Sum of the sizes of all backup pieces in the backup set. Valid only if FILE_TYPE is BACKUP SET.
`BS_COMPRESSED`	VARCHAR2(3)	Whether the backup pieces of this backup set are compressed. Valid only if FILE_TYPE is BACKUP SET.
`BS_TAG`	VARCHAR2(1024)	Tag or tags of the backup pieces of this backup set. If pieces have different tags, BS_TAGS will contain a comma-separated list of all tags for pieces in the backup set. Valid only if FILE_TYPE is BACKUP SET.
`BS_DEVICE_TYPE`	VARCHAR2(255)	Type of device on which this backup set is stored. If multiple copies of this backup set exist and are stored on different devices, this field will contain a comma-separated list of all device types. For example, for a backup set that is on disk and also backed up on tape, BS_DEVICE_TYPE might contain "DISK, SBT_TAPE". Valid only if FILE_TYPE is BACKUP SET.
`BP_PIECE#`	NUMBER	Number of backup pieces that make up this backup set. Valid only if FILE_TYPE is BACKUP SET.
`BP_COPY#`	NUMBER	Number of copies of this backup set. Valid only if FILE_TYPE is BACKUP SET.
`DF_FILE#`	NUMBER	File number of the datafile described by this row. Valid only if FILE_TYPE is DATAFILE.
`DF_TABLESPACE`	VARCHAR2(30)	Tablespace name for the datafile described by this row. Valid only if FILE_TYPE is DATAFILE.
`DF_RESETLOGS_CHANGE#`	NUMBER	Resetlogs change of the datafile described by this row. Valid only if FILE_TYPE is "DATAFILE".
`DF_CREATION_CHANGE#`	NUMBER	Creation change number of the datafile described by this row. Valid only if FILE_TYPE is "DATAFILE".
`DF_CHECKPOINT_CHANGE#`	NUMBER	Checkpoint change number of the datafile described by this row. Valid only if FILE_TYPE is "DATAFILE".
`DF_CKP_MOD_TIME`	DATE	Checkpoint time of the datafile described by this row. Valid only if FILE_TYPE is "DATAFILE".
`RL_THREAD#`	NUMBER	Redo log thread number of the archived redo log described by this row. Valid only if FILE_TYPE is "ARCHIVED LOG".
`RL_SEQUENCE#`	NUMBER	Redo log sequence number of the archived redo log described by this row. Valid only if FILE_TYPE is "ARCHIVED LOG".
`RL_RESETLOGS_CHANGE#`	NUMBER	Resetlogs change number of the archived redo log described by this row. Valid only if FILE_TYPE is "ARCHIVED LOG".
`RL_FIRST_CHANGE#`	NUMBER	First change number in the archived redo log described by this row. Valid only if FILE_TYPE is "ARCHIVED LOG".
`RL_FIRST_TIME`	DATE	Time of the first change in the archived redo log described by this row. Valid only if FILE_TYPE is "ARCHIVED LOG".
`RL_NEXT_CHANGE#`	NUMBER	Change number after the archived log described by this row. Valid only if FILE_TYPE is "ARCHIVED LOG".
`RL_NEXT_TIME`	DATE	Time of the first change after the archived log described by this row. Valid only if FILE_TYPE is "ARCHIVED LOG".