5.12 RC_BACKUP_DATAFILE_DETAILS

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

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

Column	Data Type	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, then this value is the BS_KEY value for the backup set. If BTYPE is IMAGECOPY, then this value is the value of COPY_KEY for the copy.
SESSION_KEY	NUMBER	Session identifier. Use in joins with RC_RMAN_OUTPUT and RC_RMAN_BACKUP_JOB_DETAILS.
SESSION_RECID	NUMBER	With SESSION_STAMP, uniquely identifies output for this backup job from RC_RMAN_OUTPUT.
SESSION_STAMP	NUMBER	With SESSION_RECID, uniquely identifies output for this backup job from RC_RMAN_OUTPUT.
DB_KEY	NUMBER	The primary key for this database in the recovery catalog. Use this column to join with almost any other catalog view.
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 data file.
CREATION_CHANGE#	NUMBER	The checkpoint SCN when this data file was created.
CREATION_TIME	DATE	The time at which this data file was created.
RESETLOGS_CHANGE#	NUMBER	The checkpoint SCN of the most recent RESETLOGS operation affecting this data file.
RESETLOGS_TIME	DATE	The time of the most recent RESETLOGS operation affecting this data file
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 data file at the time it was backed up.
CHECKPOINT_TIME	DATE	The time corresponding to the current checkpoint SCN for the data file at the time it was backed up.
MARKED_CORRUPT	NUMBER	Number of data file blocks marked corrupt.
FILESIZE	NUMBER	The size of the data file at the time it was backed up.
COMPRESSION_RATIO	NUMBER	Compression ratio for this backup.
CON_ID	NUMBER	The ID of the current container: 0: Rows containing data that pertain to the whole multitenant container database (CDB) or a traditional Oracle database (non-CDB) 1: Rows containing data that pertains only to the root n: Where n is the applicable container ID for the rows containing data
PDB_NAME	VARCHAR2(31)	Name of the pluggable database (PDB).
PDB_KEY	NUMBER	The primary key for this PDB in the recovery catalog.
TS#	NUMBER	Tablespace number.
TSNAME	VARCHAR2(30)	The name of the tablespace containing this data file.
FILESIZE_DISPLAY	VARCHAR2(32K)	Same value as FILESIZE, but converted to a user-displayable format, for example, 798.01M or 5.25G.