Skip Headers
Oracle® Database Backup and Recovery Reference
12c Release 1 (12.1)

E17631-15
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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.