select
FILE#, -- FILE# NUMBER
STATUS, -- STATUS VARCHAR2(18)
CHANGE#, -- CHANGE# NUMBER
TIME -- TIME DATE
from
GV$BACKUP
where
inst_id = USERENV('Instance')