GV$RECOVERY_LOG
select inst_id, -- INST_ID NUMBER lhthp, -- THREAD# NUMBER lhseq, -- SEQUENCE# NUMBER to_date -- TIME DATE (lhlot, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'), lhnam -- ARCHIVE_NAME VARCHAR2(513) from x$kcclh where to_number (lhnxs) > ( select min (to_number (fhscn)) from x$kcvfhmrr where hxerr = 0) and lhseq not in ( select leseq from x$kccle where lethr = lhthp) and to_number (lhlos) < ( select max (to_number (hxsts)) from x$kcvfhmrr where hxerr = 0)

home |  up  |  mailbox