逻辑备库常用命令

Inkcup

--查看日志应用情况
SELECT SEQUENCE#,to_char(first_time,'yyyy-mm-dd hh24:mm'),to_char(NEXT_TIME,'yyyy-mm-dd hh24:mm'),
DICT_BEGIN,DICT_END
FROM DBA_LOGSTDBY_LOG ORDER BY SEQUENCE#;


--检查重做数据是否被应用
SELECT NAME, VALUE FROM V$LOGSTDBY_STATS
WHERE NAME = 'coordinator state';


-- 停止应用
ALTER DATABASE STOP LOGICAL STANDBY APPLY;

-- 等待10秒
-- 重新启动
ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE;