select
  inst_id,                                 -- INST_ID NUMBER
  to_date(                                 -- START_TIME DATE
    ksulostm,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  ksulopna,                                -- TYPE VARCHAR2(64)
  ksulotde,                                -- ITEM VARCHAR2(32)
  ksulouni,                                -- UNITS VARCHAR2(32)
  ksulosfr,                                -- SOFAR NUMBER
  ksulotot,                                -- TOTAL NUMBER
  to_date(                                 -- TIMESTAMP DATE
    ksuloinft, 'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  ''                                       -- COMMENTS VARCHAR2(208)
from
  x$ksulop
where
  ksulopna like '% Recovery' and ksulotde != 'Last Applied Redo'
union
select
  inst_id,                                 -- INST_ID NUMBER
  to_date(                                 -- START_TIME DATE
    ksulostm,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  ksulopna,                                -- TYPE VARCHAR2(64)
  ksulotde,                                -- ITEM VARCHAR2(32)
  ksulouni,                                -- UNITS VARCHAR2(32)
  0,                                       -- SOFAR NUMBER
  0,                                       -- TOTAL NUMBER
  to_date(                                 -- TIMESTAMP DATE
    ksuloinft, 'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  ksuloif1d || ksuloif1 || ksuloif2d || ksuloif2 -- COMMENTS VARCHAR2(208)
from
  x$ksulop
where
  ksulopna like '% Recovery' and ksulotde = 'Last Applied Redo'
order by
  1,
  2 DESC,
  5 ASC,
  4 ASC