V$DATAFILE_COPY

V$DATAFILE_COPY displays datafile copy information from the control file.

Column	Datatype	Description
`RECID`	`NUMBER`	Datafile copy record ID
`STAMP`	`NUMBER`	Datafile copy record stamp
`NAME`	`VARCHAR2(513)`	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 number of the datafile when the copy was made
`RESETLOGS_TIME`	`DATE`	Resetlogs timestamp of the datafile when the copy was made
`INCREMENTAL_LEVEL`	`NUMBER`	Normal full backups have a NULL value, level 0 incremental backups have a value of 0, and level 1 incremental backups have a value of 1
`CHECKPOINT_CHANGE#`	`NUMBER`	Checkpoint change number 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`	RECID of the oldest offline range record in this control file copy; 0 for datafile copies
`DELETED`	`VARCHAR2(3)`	(`YES`\|`NO`) If set to `YES` the datafile copy has been deleted or overwritten
`STATUS`	`VARCHAR2(1)`	Identifies the status of this datafile copy. Possible values are: `A` - Available `D` - Deleted `U` - Unavailable `X` - Expired
`COMPLETION_TIME`	`DATE`	Time when the copy was completed
`CONTROLFILE_TYPE`	`VARCHAR2(1)`	`B` indicates normal copies `S` indicates standby copies
`KEEP`	`VARCHAR2(3)`	(`YES`/`NO`) Indicates whether or not this backup set has a retention policy that is different than the value for the configure retention policy
`KEEP_UNTIL`	`DATE`	If `KEEP_UNTIL` is specified, this is the date after which the backup becomes obsolete. If this column is null, then the backup never expires.
`KEEP_OPTIONS`	`VARCHAR2(10)`	Lists additional retention options for this backup set. Possible values are: `LOGS` - The logs need to recover this backup are kept `NOLOGS` - The logs needed to recover this backup will not be kept
`SCANNED`	`VARCHAR2(3)`	Indicates whether RMAN scanned the file (`YES`) or not (`NO`)
`IS_RECOVERY_DEST_FILE`	`VARCHAR2(3)`	Indicates whether the file was created in the fast recovery area (`YES`) or not (`NO`)
`RMAN_STATUS_RECID`	`NUMBER`	Owning `V$RMAN_STATUS` record ID
`RMAN_STATUS_STAMP`	`NUMBER`	Owning `V$RMAN_STATUS` record stamp
`CONVERTED_FILE`	`VARCHAR2(3)`	(`YES`/`NO`) Indicates whether or not the datafile copy was created using the RMAN `CONVERT` command
`SAME_ENDIAN`	`VARCHAR2(3)`	If the value of the `CONVERTED_FILE` column is `YES`, then this column indicates whether the datafile copy has the same endianness as the source datafile (`YES`) or not (`NO`); otherwise NULL
`FOREIGN_DBID`	`NUMBER`	Foreign DBID from which this data file came from. The value is 0 if this file is not a foreign database file.
`PLUGGED_READONLY`	`VARCHAR2(3)`	`YES` if this is a transported read-only foreign file; otherwise `NO`.
`PLUGIN_CHANGE#`	`NUMBER`	SCN at which the foreign datafile was transported into the database. The value is 0 if this file is not a foreign database file.
`PLUGIN_RESETLOGS_CHANGE#`	`NUMBER`	The SCN of the `RESETLOGS` operation for the incarnation into which this foreign file was transported. The value is 0 if this file is not a foreign database file.
`PLUGIN_RESETLOGS_TIME`	`DATE`	The time of the `RESETLOGS` operation for the incarnation into which this foreign file was transported. The value is 0 if this file is not a foreign database file.
`BACKED_BY_VSS`	`VARCHAR2(3)`	Whether or not the file has been backed up by Volume Shadow Copy Service (VSS). This column is reserved for internal use.