逻辑备库日志应用查询

王亮

查看备库已经注册的日志文件及其应用情况:

select sequence#, file_name, applied, TIMESTAMPfrom dba_logstdby_log;

查看备库sql apply的状态:

col REALTIME_APPLY format a15

col STATE format a15

select * from v$Logstdby_state;

查看备库的事务apply状态:

col name format a30

col value format a10

select * from v$logstdby_stats WHERE NAME LIKE'transactions%';

查看备库是否有任何 DDL/DML语句未成功应用:

col EVENT_TIMESTAMP format a30

col EVENT format a60

col EVENT_STATUS format a85

SELECT EVENT_TIMESTAMP, xidusn, xidslt, xidsqn, EVENT,STATUS event_status FROM DBA_LOGSTDBY_EVENTS WHERE event_time = (SELECT MAX(event_time) FROM dba_logstdby_events);