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
from
x$kccic
home |  up  |  mailbox