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