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