RECID |
NUMBER |
Backup datafile record ID |
STAMP |
NUMBER |
Backup datafile record stamp |
SET_STAMP |
NUMBER |
Backup set stamp |
SET_COUNT |
NUMBER |
Backup set count |
FILE# |
NUMBER |
Datafile number; set to 0 for control file |
CREATION_CHANGE# |
NUMBER |
Creation change of the datafile |
CREATION_TIME |
DATE |
Creation timestamp of the datafile |
RESETLOGS_CHANGE# |
NUMBER |
Resetlogs change# of the datafile when it was backed up |
RESETLOGS_TIME |
DATE |
Resetlogs timestamp of the datafile when it was backed up |
INCREMENTAL_LEVEL |
NUMBER |
(0-4) incremental backup level |
INCREMENTAL_CHANGE# |
NUMBER |
All blocks changed after incremental change# is included in this backup; set to 0 for a full backup |
CHECKPOINT_CHANGE# |
NUMBER |
All changes up to checkpoint change# are included in this backup |
CHECKPOINT_TIME |
DATE |
Timestamp of the checkpoint |
ABSOLUTE_FUZZY_CHANGE# |
NUMBER |
Highest change# in this backup |
MARKED_CORRUPT |
NUMBER |
Number of blocks marked corrupt |
MEDIA_CORRUPT |
NUMBER |
Number of blocks media corrupt |
LOGICALLY_CORRUPT |
NUMBER |
Number of blocks logically corrupt |
DATAFILE_BLOCKS |
NUMBER |
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 |
NUMBER |
Size of the backup datafile in blocks. Unused blocks are not copied to the backup. |
BLOCK_SIZE |
NUMBER |
Block size |
OLDEST_OFFLINE_RANGE |
NUMBER |
The RECID of the oldest offline range record in this backup control file. 0 for datafile backups. |
COMPLETION_TIME |
DATE |
The time completed |
CONTROLFILE_TYPE |
VARCHAR2(1) |
B indicates normal copies
S indicates standby copies |