GV$RECOVERY_LOG definition in Oracle 9i / www.oracledba.ru
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)