V$DATAFILE_COPY definition in Oracle Database 11.2
V$DATAFILE_COPY
select
RECID, -- RECID NUMBER
STAMP, -- STAMP NUMBER
NAME, -- NAME VARCHAR2(513)
TAG, -- TAG VARCHAR2(32)
FILE#, -- FILE# NUMBER
RFILE#, -- RFILE# NUMBER
CREATION_CHANGE#, -- CREATION_CHANGE# NUMBER
CREATION_TIME, -- CREATION_TIME DATE
RESETLOGS_CHANGE#, -- RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME, -- RESETLOGS_TIME DATE
INCREMENTAL_LEVEL, -- INCREMENTAL_LEVEL NUMBER
CHECKPOINT_CHANGE#, -- CHECKPOINT_CHANGE# NUMBER
CHECKPOINT_TIME, -- CHECKPOINT_TIME DATE
ABSOLUTE_FUZZY_CHANGE#, -- ABSOLUTE_FUZZY_CHANGE# NUMBER
RECOVERY_FUZZY_CHANGE#, -- RECOVERY_FUZZY_CHANGE# NUMBER
RECOVERY_FUZZY_TIME, -- RECOVERY_FUZZY_TIME DATE
ONLINE_FUZZY, -- ONLINE_FUZZY VARCHAR2(3)
BACKUP_FUZZY, -- BACKUP_FUZZY VARCHAR2(3)
MARKED_CORRUPT, -- MARKED_CORRUPT NUMBER
MEDIA_CORRUPT, -- MEDIA_CORRUPT NUMBER
LOGICALLY_CORRUPT, -- LOGICALLY_CORRUPT NUMBER
BLOCKS, -- BLOCKS NUMBER
BLOCK_SIZE, -- BLOCK_SIZE NUMBER
OLDEST_OFFLINE_RANGE, -- OLDEST_OFFLINE_RANGE NUMBER
DELETED, -- DELETED VARCHAR2(3)
STATUS, -- STATUS VARCHAR2(1)
COMPLETION_TIME, -- COMPLETION_TIME DATE
CONTROLFILE_TYPE, -- CONTROLFILE_TYPE VARCHAR2(1)
KEEP, -- KEEP VARCHAR2(3)
KEEP_UNTIL, -- KEEP_UNTIL DATE
KEEP_OPTIONS, -- KEEP_OPTIONS VARCHAR2(11)
SCANNED, -- SCANNED VARCHAR2(3)
IS_RECOVERY_DEST_FILE, -- IS_RECOVERY_DEST_FILE VARCHAR2(3)
RMAN_STATUS_RECID, -- RMAN_STATUS_RECID NUMBER
RMAN_STATUS_STAMP, -- RMAN_STATUS_STAMP NUMBER
CONVERTED_FILE, -- CONVERTED_FILE VARCHAR2(3)
SAME_ENDIAN, -- SAME_ENDIAN VARCHAR2(3)
FOREIGN_DBID, -- FOREIGN_DBID NUMBER
PLUGGED_READONLY, -- PLUGGED_READONLY VARCHAR2(3)
PLUGIN_CHANGE#, -- PLUGIN_CHANGE# NUMBER
PLUGIN_RESETLOGS_CHANGE#, -- PLUGIN_RESETLOGS_CHANGE# NUMBER
PLUGIN_RESETLOGS_TIME, -- PLUGIN_RESETLOGS_TIME DATE
BACKED_BY_VSS -- BACKED_BY_VSS VARCHAR2(3)
from
GV$DATAFILE_COPY
where
inst_id = USERENV('Instance')