RECID |
NUMBER |
Datafile copy record ID |
STAMP |
NUMBER |
Datafile copy record stamp |
NAME |
VARCHAR2(512) |
Filename of the datafile copy. The maximum length of the name is OS dependent |
TAG |
VARCHAR2(32) |
Datafile copy tag |
FILE# |
NUMBER |
Absolute datafile number |
RFILE# |
NUMBER |
Tablespace relative datafile number |
CREATION_CHANGE# |
NUMBER |
Datafile creation change# |
CREATION_TIME |
DATE |
Datafile creation timestamp |
RESETLOGS_CHANGE# |
NUMBER |
Resetlogs change# of the datafile when the copy was made |
RESETLOGS_TIME |
DATE |
Resetlogs timestamp of the datafile when the copy was made |
INCREMENTAL_LEVEL |
NUMBER |
The incremental level |
CHECKPOINT_CHANGE# |
NUMBER |
Checkpoint change# of the datafile when the copy was made |
CHECKPOINT_TIME |
DATE |
Checkpoint timestamp of the datafile when the copy was made |
ABSOLUTE_FUZZY_CHANGE# |
NUMBER |
Highest change seen when the datafile was copied |
RECOVERY_FUZZY_CHANGE# |
NUMBER |
Highest change written to the file by media recovery |
RECOVERY_FUZZY_TIME |
DATE |
Timestamp of the highest change written to the file by media recovery |
ONLINE_FUZZY |
VARCHAR2(3) |
YES | NO . If set to YES , this is a copy taken using an operating system utility after a crash or offline immediate (or an invalid copy taken while datafile was online and the database open). Recovery will need to apply all redo up to the next crash recovery marker to make the file consistent |
BACKUP_FUZZY |
VARCHAR2(3) |
YES | NO . If set to YES , this is a copy taken using the BEGIN BACKUP/END BACKUP technique. Recovery will need to apply all redo up to the end backup marker to make this copy consistent |
MARKED_CORRUPT |
NUMBER |
Number of blocks marked corrupt by this copy operation. That is, blocks that were not marked corrupted in the source datafile, but were detected and marked as corrupted during the copy operation |
MEDIA_CORRUPT |
NUMBER |
Total number of media corrupt blocks. For example, blocks with checksum errors are marked media corrupt |
LOGICALLY_CORRUPT |
NUMBER |
Total number of logically corrupt blocks. For example, applying redo for unrecoverable operations will mark affected blocks logically corrupt |
BLOCKS |
NUMBER |
Size of the datafile copy in blocks (also the size of the datafile when the copy was made) |
BLOCK_SIZE |
NUMBER |
Block size of the datafile |
OLDEST_OFFLINE _RANGE |
NUMBER |
The RECID of the oldest offline range record in this control file copy. 0 for datafile copies |
COMPLETION_TIME |
DATE |
Time when the copy was completed |
DELETED |
VARCHAR2(3) |
YES | NO . If set to YES the datafile copy has been deleted or overwritten |