GV$DATABASE_INCARNATION

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)
  (icflg, 1, 'ORPHAN', 2, 'CURRENT', 0, 'PARENT', null),
icrlc_i,                 -- RESETLOGS_ID NUMBER
icpinc,                  -- PRIOR_INCARNATION# NUMBER
icalw                    -- FLASHBACK_DATABASE_ALLOWED VARCHAR2(26)
from
x$kccic
home |  up  |  mailbox