标题: 逻辑备库同步时查看错误分布 [打印本页] 作者: Inkcup 时间: 4 小时前 标题: 逻辑备库同步时查看错误分布 --检查日志传输延迟
-- 在备库执行
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;