select
  userenv('Instance'),                     -- INST_ID NUMBER
  icrid,                                   -- INCARNATION# NUMBER
  to_number(icrls),                        -- RESETLOGS_CHANGE# NUMBER
  to_date(                                 -- RESETLOGS_TIME DATE
    icrlc,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  to_number(icprs),                        -- PRIOR_RESETLOGS_CHANGE# NUMBER
  to_date(                                 -- PRIOR_RESETLOGS_TIME DATE
    icprc,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  decode(                                  -- STATUS VARCHAR2(7)
    bitand(icflg,3), 1,'ORPHAN', 2, 'CURRENT', 0, 'PARENT', 'ORPHAN'),
  icrlc_i,                                 -- RESETLOGS_ID NUMBER
  icpinc,                                  -- PRIOR_INCARNATION# NUMBER
  icalw                                    -- FLASHBACK_DATABASE_ALLOWED VARCHAR2(26)
from
  x$kccic