RC_BACKUP_DATAFILE_DETAILS

RC_BACKUP_DATAFILE_DETAILS provides detailed information about available datafile backups for databases registered in the recovery catalog.

This view is primarily intended to be used internally by Enterprise Manager.

Column	Datatype	Description
`BTYPE`	`CHAR(9)`	The backup type container, which can be BACKUPSET, IMAGECOPY or PROXYCOPY.
`BTYPE_KEY`	`NUMBER`	Unique identifier for the backup type. If BTYPE is BACKUPSET, this value is the BS_KEY value for the backup set. If BTYPE is IMAGECOPY, this value is the value of COPY_KEY for the copy.
`SESSION_KEY`	`NUMBER`	Session identifier. Use in joins with RC_RMAN_OUTPUT.
`SESSION_RECID`	`NUMBER`	Together with SESSION_STAMP, uniquely identifies output for this backup job from RC_RMAN_OUTPUT.
`SESSION_STAMP`	`NUMBER`	Together with SESSION_RECID, uniquely identifies output for this backup job from RC_RMAN_OUTPUT.
`DB_KEY`	`NUMBER`	The primary key for this database.
`DB_NAME`	`VARCHAR2(8)`	The `DB_NAME` of the database incarnation to which this record belongs.
`ID1`	`NUMBER`	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.
`ID2`	`NUMBER`	For backups taken as backup sets, this column contains SET_COUNT. For proxy copy or image copy backups, this column contains STAMP.
`FILE#`	`NUMBER`	The number of this datafile.
`CREATION_CHANGE#`	`NUMBER`	The checkpoint SCN at the time that this datafile was created.
`CREATION_TIME`	`DATE`	The time at which this datafile was created.
`RESETLOGS_CHANGE#`	`NUMBER`	The checkpoint SCN of the most recent RESETLOGS operation affecting this datafile.
`RESETLOGS_TIME`	`DATE`	The time of the most recent RESETLOGS operation affecting this datafile
`INCREMENTAL_LEVEL`	`NUMBER`	For incremental backups, the level of the incremental backup (0 or 1). Otherwise, NULL.
`INCREMENTAL_CHANGE#`	`NUMBER`	For incremental backups, the incremental backup SCN. Otherwise, NULL.
`CHECKPOINT_CHANGE#`	`NUMBER`	The current checkpoint SCN for the datafile at the time it was backed up.
`CHECKPOINT_TIME`	`DATE`	The time corresponding to the current checkpoint SCN for the datafile at the time it was backed up.
`MARKED_CORRUPT`	`NUMBER`	Number of datafile blocks marked corrupt.
`FILESIZE`	`NUMBER`	The size of the datafile at the time it was backed up.
`COMPRESSION_RATIO`	`NUMBER`	Compression ratio for this backup.
`TS#`	`NUMBER`	Tablespace number.
`TSNAME`	`VARCHAR2(30)`	The name of the tablespace containing this datafile.
`FILESIZE_DISPLAY`	`VARCHAR2(4000)`	Same value as `FILESIZE`, but converted to a user-displayable format, for example nM, nG, nT, nP.