level 9
云淡风清198974
楼主
逻辑备库同步时查看错误分布
--检查日志传输延迟
-- 在备库执行
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
2026年07月02日 05点07分
1
--检查日志传输延迟
-- 在备库执行
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