GV$DATABASE_INCARNATION

select
userenv ('Instance'),    -- INST_ID 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') 
from
x$kccic
home |  up  |  mailbox