select
  FILENUM,                                 -- FILENUM NUMBER
  FILENAME,                                -- FILENAME VARCHAR2(513)
  STATUS                                   -- STATUS VARCHAR2(13)
from
  GV$RECOVERY_FILE_STATUS
where
  inst_id = USERENV('Instance')