select
dmmal.MAL_HOST,
dmmal.MAL_INST_HOST,
INSTANCE_NAME ,
HOST_NAME ,
STATUS$ AS ISTATUS,
MODE$ AS IMODE ,
OGUID ,
(
select ARCH_STATUS from V$ARCH_STATUS WHERE ARCH_TYPE=‘LOCAL’
) AS ARCH_STATUS,
dmwatch.DW_MODE ,
dmwatch.DW_STATUS,
( 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