This view lists information about datafiles in backup sets. It corresponds to the V$BACKUP_DATAFILE
view. A backup datafile is uniquely identified by BDF_KEY
.
Column | Datatype | Description |
---|---|---|
DB_KEY |
NUMBER |
The primary key for the target database. Use this column to form a join with almost any other catalog view. |
DBINC_KEY |
NUMBER |
The primary key for the incarnation of the target database. Use this column to form a join with RC_DATABASE_INCARNATION . |
DB_NAME |
VARCHAR2(8) |
The DB_NAME of the database incarnation to which this record belongs. |
BDF_KEY |
NUMBER |
The primary key of the datafile backup in the recovery catalog. If you issue the LIST command while connected to the recovery catalog, this value appears in the KEY column of the output. |
RECID |
NUMBER |
The backup datafile RECID from V$BACKUP_DATAFILE . RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file. |
STAMP |
NUMBER |
The backup datafile stamp from V$BACKUP_DATAFILE . RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file. |
BS_KEY |
NUMBER |
The primary key of the backup set to which this record belongs in the recovery catalog. Use this column to form a join with RC_BACKUP_SET . |
SET_STAMP |
NUMBER |
The SET_STAMP value from V$BACKUP_SET . SET_STAMP and SET_COUNT form a concatenated key that uniquely identifies the backup set to which this record belongs in the target database control file. |
SET_COUNT |
NUMBER |
The SET_COUNT value from V$BACKUP_SET . SET_STAMP and SET_COUNT form a concatenated key that uniquely identifies the backup set to which this record belongs in the target database control file. |
BS_RECID |
NUMBER |
The RECID from V$BACKUP_SET . |
BS_STAMP |
NUMBER |
The STAMP from V$BACKUP_SET . |
BACKUP_TYPE |
VARCHAR2(1) |
The type of the backup: D (full or level 0 incremental) or I (incremental level 1). |
INCREMENTAL_LEVEL |
NUMBER |
The level of the incremental backup: NULL , 0 , or 1. |
COMPLETION_TIME |
DATE |
The completion time of the backup. |
FILE# |
NUMBER |
The absolute file number of the datafile. Note that when FILE# =0, the record refers to the control file. See the note following this table for special semantics of other columns when FILE# =0. |
CREATION_CHANGE# |
NUMBER |
The creation SCN of the datafile. |
RESETLOGS_CHANGE# |
NUMBER |
The SCN of the most recent RESETLOGS in the datafile header. |
RESETLOGS_TIME |
DATE |
The time stamp of the most recent RESETLOGS in the datafile header. |
INCREMENTAL_CHANGE# |
NUMBER |
The SCN that determines whether a block will be included in the incremental backup. A block is only included if the SCN in the block header is greater than or equal to INCREMENTAL_CHANGE# .
The range of redo covered by the incremental backup begins with |
CHECKPOINT_CHANGE# |
NUMBER |
The checkpoint SCN of this datafile in this backup set. |
CHECKPOINT_TIME |
DATE |
The time associated with CHECKPOINT_CHANGE# . |
ABSOLUTE_FUZZY_CHANGE# |
NUMBER |
The absolute fuzzy SCN. See the note following this table for special semantics when FILE# =0. |
DATAFILE_BLOCKS |
NUMBER |
The number of data blocks in the datafile. |
BLOCKS |
NUMBER |
The number of data blocks written to the backup. This value is often less than DATAFILE_BLOCKS because for full backups, blocks that have never been used are not included in the backup, and for incremental backups, blocks that have not changed are not included in the backup. This value is never greater than DATAFILE_BLOCKS . |
BLOCK_SIZE |
NUMBER |
The size of the data blocks in bytes. |
STATUS |
VARCHAR2(1) |
The status of the backup set: A (all pieces available), D (all pieces deleted), O (some pieces are available but others are not, so the backup set is unusable). |
BS_LEVEL |
NUMBER |
The incremental level (NULL, 0, or 1) specified when this backup was created. This value can be different from the INCREMENTAL_LEVEL column because if you run, for example, a level 1 incremental backup, but no previous level 0 backup exists for some files, a level 0 backup is automatically taken for these files. In this case, BS_LEVEL is 1 and INCREMENTAL_LEVEL is 0. |
PIECES |
NUMBER |
The number of backup pieces in the backup set that contains this backup datafile. |