V$BACKUP_DATAFILE displays information about control files and datafiles in backup sets from the control file.
RECID
Backup datafile record ID
STAMP
Backup datafile record stamp
SET_STAMP
Backup set stamp
SET_COUNT
Backup set count
FILE#
Datafile number; set to 0 for control file
CREATION_CHANGE#
Creation system change number (SCN) of the datafile
CREATION_TIME
Creation timestamp of the datafile
RESETLOGS_CHANGE#
Resetlogs system change number (SCN) of the datafile when it was backed up
RESETLOGS_TIME
Resetlogs timestamp of the datafile when it was backed up
INCREMENTAL_LEVEL
(0-4) incremental backup level
INCREMENTAL_CHANGE#
All blocks changed after incremental change# is included in this backup; set to 0 for a full backup
CHECKPOINT_CHANGE#
All changes up to checkpoint change# are included in this backup
CHECKPOINT_TIME
Timestamp of the checkpoint
ABSOLUTE_FUZZY_CHANGE#
Highest change# in this backup
MARKED_CORRUPT
Number of blocks marked corrupt
MEDIA_CORRUPT
Number of blocks media corrupt
LOGICALLY_CORRUPT
Number of blocks logically corrupt
DATAFILE_BLOCKS
Size of the datafile in blocks at backup time. This value is also the number of blocks taken by the datafile restarted from this backup.
BLOCKS
Size of the backup datafile (in blocks). Unused blocks are not copied to the backup.
BLOCK_SIZE
Block size
OLDEST_OFFLINE_RANGE
RECID of the oldest offline range record in this backup control file. 0 for datafile backups.
COMPLETION_TIME
Time completed
CONTROLFILE_TYPE
• B – Normal copies
• S – Standby copies
USED_CHANGE_TRACKING
Indicates whether change tracking data was used to accelerate this incremental backup (YES) or whether change tracking data was not used (NO)
BLOCKS_READ
Number of blocks that were scanned while taking this backup. If this was an incremental backup, and change tracking was used to optimize the backup, then the value of this column will be smaller than DATAFILE_BLOCKS. Otherwise, the value of this column will be the same as DATAFILE_BLOCKS. Even when change tracking data is used, the value of this column may be larger than BLOCKS, because the data read by change tracking is further refined during the process of creating an incremental backup.
