select t2.* from (select t1.*, t3.OPERATERTYPE, t3.OPERATESTATE, rownum rnum from t_event t1, (select t3.* from t_event_operate t3 where t3.operateid in (select t4.maxoperateid from (select eventid, max(operateid + 0) maxoperateid from t_event_operate where (operatorno = '1' and operatertype in ('A', 'C')) or (ORGANCODE = '1' and operatertype = 'B') group by eventid) t4)) t3 where t1.eventid in (select t.eventid from (select eventid, max(operateid + 0) maxoperateid from t_event_operate where (operatorno = '1' and operatertype in ('A', 'C')) or (ORGANCODE = '1' and operatertype = 'B') group by eventid) t) and t1.validflag = '1' and t3.eventid = t1.eventid order by t1.occurtime desc) t2 where t2.rnum > 0 and t2.rnum <= 20
2.Disk failure
2.LOGMINER看是否有数据写入数据库,如果没有的话,则说明没有数据进入数据库,同时也可以看到是否有删除操作
大哥,我如果没有归档日志,那还能不能看呢,我是昨天丢的数据
select t2.*
from (select t1.*, t3.OPERATERTYPE, t3.OPERATESTATE, rownum rnum
from t_event t1,
(select t3.*
from t_event_operate t3
where t3.operateid in
(select t4.maxoperateid
from (select eventid, max(operateid + 0) maxoperateid
from t_event_operate
where (operatorno = '1' and
operatertype in ('A', 'C'))
or (ORGANCODE = '1' and operatertype = 'B')
group by eventid) t4)) t3
where t1.eventid in
(select t.eventid
from (select eventid, max(operateid + 0) maxoperateid
from t_event_operate
where (operatorno = '1' and
operatertype in ('A', 'C'))
or (ORGANCODE = '1' and operatertype = 'B')
group by eventid) t)
and t1.validflag = '1'
and t3.eventid = t1.eventid
order by t1.occurtime desc) t2
where t2.rnum > 0
and t2.rnum <= 20
2.Disk failure