V$BACKUP_SET definition in Oracle Database 11.2
V$BACKUP_SET

select
  RECID,                                   -- RECID NUMBER
  STAMP,                                   -- STAMP NUMBER
  SET_STAMP,                               -- SET_STAMP NUMBER
  SET_COUNT,                               -- SET_COUNT NUMBER
  BACKUP_TYPE,                             -- BACKUP_TYPE VARCHAR2(1)
  CONTROLFILE_INCLUDED,                    -- CONTROLFILE_INCLUDED VARCHAR2(3)
  INCREMENTAL_LEVEL,                       -- INCREMENTAL_LEVEL NUMBER
  PIECES,                                  -- PIECES NUMBER
  START_TIME,                              -- START_TIME DATE
  COMPLETION_TIME,                         -- COMPLETION_TIME DATE
  ELAPSED_SECONDS,                         -- ELAPSED_SECONDS NUMBER
  BLOCK_SIZE,                              -- BLOCK_SIZE NUMBER
  INPUT_FILE_SCAN_ONLY,                    -- INPUT_FILE_SCAN_ONLY VARCHAR2(3)
  KEEP,                                    -- KEEP VARCHAR2(3)
  KEEP_UNTIL,                              -- KEEP_UNTIL DATE
  KEEP_OPTIONS,                            -- KEEP_OPTIONS VARCHAR2(11)
  MULTI_SECTION                            -- MULTI_SECTION VARCHAR2(3)
from
  GV$BACKUP_SET
where
  inst_id = USERENV('Instance')

home |  up