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
|