|
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 |