select
  RECID,                                   -- RECID NUMBER
  STAMP,                                   -- STAMP NUMBER
  SET_STAMP,                               -- SET_STAMP NUMBER
  SET_COUNT,                               -- SET_COUNT NUMBER
  FILE#,                                   -- FILE# 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
  INCREMENTAL_CHANGE#,                     -- INCREMENTAL_CHANGE# NUMBER
  CHECKPOINT_CHANGE#,                      -- CHECKPOINT_CHANGE# NUMBER
  CHECKPOINT_TIME,                         -- CHECKPOINT_TIME DATE
  ABSOLUTE_FUZZY_CHANGE#,                  -- ABSOLUTE_FUZZY_CHANGE# NUMBER
  MARKED_CORRUPT,                          -- MARKED_CORRUPT NUMBER
  MEDIA_CORRUPT,                           -- MEDIA_CORRUPT NUMBER
  LOGICALLY_CORRUPT,                       -- LOGICALLY_CORRUPT NUMBER
  DATAFILE_BLOCKS,                         -- DATAFILE_BLOCKS NUMBER
  BLOCKS,                                  -- BLOCKS NUMBER
  BLOCK_SIZE,                              -- BLOCK_SIZE NUMBER
  OLDEST_OFFLINE_RANGE,                    -- OLDEST_OFFLINE_RANGE NUMBER
  COMPLETION_TIME,                         -- COMPLETION_TIME DATE
  CONTROLFILE_TYPE,                        -- CONTROLFILE_TYPE VARCHAR2(1)
  USED_CHANGE_TRACKING,                    -- USED_CHANGE_TRACKING VARCHAR2(3)
  BLOCKS_READ,                             -- BLOCKS_READ NUMBER
  USED_OPTIMIZATION,                       -- USED_OPTIMIZATION 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
  SECTION_SIZE,                            -- SECTION_SIZE NUMBER
  UNDO_OPTIMIZED,                          -- UNDO_OPTIMIZED VARCHAR2(3)
  BLOCKS_SKIPPED_IN_CELL                   -- BLOCKS_SKIPPED_IN_CELL NUMBER
from
  GV$BACKUP_DATAFILE
where
  inst_id = USERENV('Instance')