Oracle11g ADG 搭建

十、验证

主库 v$archived_log
SQL> select thread#,max(sequence#) from v$archived_log where applied=‘NO‘ group by thread#;
备库 v$archived_log
SQL> select thread#,max(sequence#) from v$archived_log where applied=‘YES‘ group by thread#;
备库 v$managed_standby;
select process,status,thread#,sequence# from v$managed_standby;
或者
SELECT ‘RECEIVED‘||chr(9)||rtrim(received1)||‘-> ‘||received_time1||chr(9)||rtrim(received2)||‘-> ‘||received_time2
FROM
(select max(sequence#) received1,to_char(max(next_time),‘YYYY/MM/DD HH24:MI:SS‘) RECEIVED_TIME1
from V$ARCHIVED_LOG
where thread#=1
),(select max(sequence#) received2,‘YYYY/MM/DD HH24:MI:SS‘) RECEIVED_TIME2
from V$ARCHIVED_LOG
where thread#=2
)
/
SELECT ‘APPLIED ‘||chr(9)||rtrim(applied1)||‘-> ‘||applied_time1||chr(9)||rtrim(applied2)||‘-> ‘||applied_time2
from
(select MAX(SEQUENCE#) applied1,TO_CHAR(MAX(COMPLETION_TIME),‘YYYY/MM/DD HH24:MI:SS‘) APPLIED_TIME1
from V$ARCHIVED_LOG where applied=‘YES‘ and thread#=1
),(select MAX(SEQUENCE#) applied2,‘YYYY/MM/DD HH24:MI:SS‘) APPLIED_TIME2
from V$ARCHIVED_LOG where applied=‘YES‘ and thread#=2
)
/

（编辑：青岛站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!