select
  LAST_FAILOVER_TIME,                      -- LAST_FAILOVER_TIME VARCHAR2(20)
  LAST_FAILOVER_REASON                     -- LAST_FAILOVER_REASON VARCHAR2(255)
from
  GV$FS_FAILOVER_STATS
where
  inst_id=USERENV('Instance')