select
  incarnation#,                            -- INCARNATION# NUMBER
  resetlogs_change#,                       -- RESETLOGS_CHANGE# NUMBER
  resetlogs_time,                          -- RESETLOGS_TIME DATE
  prior_resetlogs_change#,                 -- PRIOR_RESETLOGS_CHANGE# NUMBER
  prior_resetlogs_time,                    -- PRIOR_RESETLOGS_TIME DATE
  status,                                  -- STATUS VARCHAR2(7)
  resetlogs_id,                            -- RESETLOGS_ID NUMBER
  prior_incarnation#,                      -- PRIOR_INCARNATION# NUMBER
  flashback_database_allowed               -- FLASHBACK_DATABASE_ALLOWED VARCHAR2(26)
from
  GV$DATABASE_INCARNATION
where
  inst_id = USERENV('Instance')