在主库和备库都运行下面SQL，看看3列的差值
select
( select FILE_LSN from v$rlog ) AS FLSN,
( select CUR_LSN from v$rlog ) AS CLSN,
( select LAST_MSG_TIME from V$UTSK_SYS2) AS LAST_MSG_TIME
from
v$instance ins
left join v$dmwatcher dmwatch
on
ins.INSTANCE_NAME = dmwatch.INST_NAME
left join V$DM_MAL_INI dmmal
on
ins.INSTANCE_NAME = dmmal.MAL_INST_NAME
在主库和备库都运行下面SQL，看看3列的差值
select
( select FILE_LSN from v$rlog ) AS FLSN,
( select CUR_LSN from v$rlog ) AS CLSN,
( select LAST_MSG_TIME from V$UTSK_SYS2) AS LAST_MSG_TIME
from
v$instance ins
left join v$dmwatcher dmwatch
on
ins.INSTANCE_NAME = dmwatch.INST_NAME
left join V$DM_MAL_INI dmmal
on
ins.INSTANCE_NAME = dmmal.MAL_INST_NAME