查看ADG同步日志状态

最新推荐文章于 2024-08-29 09:12:53 发布

Vik_Deng

最新推荐文章于 2024-08-29 09:12:53 发布

阅读量254

点赞数

文章标签：数据库 sql

本文链接：https://blog.csdn.net/weixin_42344665/article/details/132777885

版权

set pages 1000 lines 1000
SELECT al.thrd "Thread", almax "Last Seq Received", lhmax "Last Seq Applied"
FROM (select thread# thrd, MAX(sequence#) almax
FROM v$archived_log
WHERE resetlogs_change#=(SELECT resetlogs_change# FROM v$database) GROUP BY thread#) al,
(SELECT thread# thrd, MAX(sequence#) lhmax
FROM v$log_history
WHERE resetlogs_change#=(SELECT resetlogs_change# FROM v$database) GROUP BY thread#) lh
WHERE al.thrd = lh.thrd;