V$BACKUP_SPFILE definition in Oracle Database 11.2

V$BACKUP_SPFILE

select
  RECID,                                   -- RECID NUMBER
  STAMP,                                   -- STAMP NUMBER
  SET_STAMP,                               -- SET_STAMP NUMBER
  SET_COUNT,                               -- SET_COUNT NUMBER
  MODIFICATION_TIME,                       -- MODIFICATION_TIME DATE
  BYTES,                                   -- BYTES NUMBER
  COMPLETION_TIME,                         -- COMPLETION_TIME DATE
  DB_UNIQUE_NAME                           -- DB_UNIQUE_NAME VARCHAR2(30)
from
  GV$BACKUP_SPFILE
where
  inst_id = USERENV('Instance')

home | up