select
  rsp.inst_id,                             -- INST_ID NUMBER
  to_number(rsp.rspscn),                   -- SCN NUMBER
  rsp.rspincarn,                           -- DATABASE_INCARNATION# NUMBER
  decode(                                  -- GUARANTEE_FLASHBACK_DATABASE VARCHAR2(3)
    bitand(rsp.rspflags, 1), 1, 'YES', 'NO'),
  to_number(rsp.rsplgsz),                  -- STORAGE_SIZE NUMBER
  to_timestamp(                            -- TIME TIMESTAMP(9)
    rsp.rsptime, 'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  to_timestamp(                            -- RESTORE_POINT_TIME TIMESTAMP(9)
    decode(bitand(rsp.rspflags, 8), 0, NULL, rsp.rsprsptime), 'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  'YES',                                   -- PRESERVED VARCHAR2(3)
  rsp.rspname                              -- NAME VARCHAR2(128)
from
  x$kccrsp rsp
where
  bitand(rsp.rspflags, 2) != 0
union all
select
  rsp.inst_id,                             -- INST_ID NUMBER
  to_number(rsp.nrsscn),                   -- SCN NUMBER
  rsp.nrsincarn,                           -- DATABASE_INCARNATION# NUMBER
  'NO',                                    -- GUARANTEE_FLASHBACK_DATABASE VARCHAR2(3)
  0,                                       -- STORAGE_SIZE NUMBER
  to_timestamp(                            -- TIME TIMESTAMP(9)
    rsp.nrstime, 'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  to_timestamp(                            -- RESTORE_POINT_TIME TIMESTAMP(9)
    decode(bitand(rsp.nrsflags, 8), 0, NULL, rsp.nrsrsptime), 'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  'NO',                                    -- PRESERVED VARCHAR2(3)
  rsp.nrsname                              -- NAME VARCHAR2(128)
from
  x$kccnrs rsp
where
  bitand(rsp.nrsflags, 2) != 0