逻辑备库同步时查看错误分布

Inkcup

--检查日志传输延迟
-- 在备库执行
SELECT NAME, VALUE, UNIT, TIME_COMPUTED
FROM V$DATAGUARD_STATS
WHERE NAME IN ('apply lag','transport lag');

--查看错误分布
SELECT STATUS_CODE, COUNT(*) AS ERROR_COUNT
FROM DBA_LOGSTDBY_EVENTS
WHERE STATUS_CODE != 0
GROUP BY STATUS_CODE
ORDER BY ERROR_COUNT DESC;

--查看最近的10个错误
SELECT to_char(EVENT_TIME,'yyyy-mm-dd hh24:mm'), STATUS_CODE, SUBSTR(EVENT, 1, 100) AS EVENT_SUMMARY
FROM DBA_LOGSTDBY_EVENTS
WHERE STATUS_CODE != 0
ORDER BY EVENT_TIME DESC
FETCH FIRST 10 ROWS ONLY;

--查看最新的错误（判断是否还在持续产生）
SELECT to_char(EVENT_TIME,'yyyy-mm-dd hh24:mm'), STATUS_CODE, EVENT
FROM DBA_LOGSTDBY_EVENTS
WHERE STATUS_CODE != 0
ORDER BY EVENT_TIME DESC
FETCH FIRST 5 ROWS ONLY;