select
  inst_id,                                 -- INST_ID NUMBER
  fnfno,                                   -- GROUP# NUMBER
  decode(                                  -- STATUS VARCHAR2(7)
    fnflg,0,'', decode(bitand(fnflg,1),1,'INVALID', decode(bitand(fnflg,2),2,'STALE', decode(bitand(fnflg,4),4,'DELETED', decode(bitand(fnflg,8+32),8,'',32,'',40,'','UNKNOWN'))))),
  decode(                                  -- TYPE VARCHAR2(7)
    bitand(fnflg,8),0,'ONLINE','STANDBY'),
  fnnam,                                   -- MEMBER VARCHAR2(513)
  decode(                                  -- IS_RECOVERY_DEST_FILE VARCHAR2(3)
    bitand(fnflg, 32),0,'NO','YES') 
from
  x$kccfn
where
  fnnam is not null and fntyp=3