查看正在執行的SQL

0. logical standby DB

shutdown abort or alter database stop logical standby apply;

0.1

startup

1.

select * from dba_db_links

CREATE PUBLIC DATABASE LINK "TEMP" CONNECT TO smp IDENTIFIED BY ezsfcs USING 'STCSMES'

2.

EXECUTE DBMS_LOGSTDBY.SKIP('DML','SMP','SFCS_HOLD_DETAIL');

3.

alter database start logical standby apply;

4.-- select * from dba_logstdby_progress 確認 Logical standby DB 同步已接近目前時間後，即暂时skip该table,先让其他的动作继续apply,直到同步时间接近目前的时间,再stop apply

注意看下：read scn,read time

logical standby:

alter database stop logical standby apply;

5. logical Standby DB:

SELECT APPLIED_SCN, LATEST_SCN, MINING_SCN, RESTART_SCN FROM V$LOGSTDBY_PROGRESS;

取得 RESTART_SCN.

6.

--conn as sysdba

truncate table smp.SFCS_HOLD_DETAIL;

INSERT /*+ APPEND*/ INTO SMP.SFCS_HOLD_DETAIL SELECT * FROM SMP.SFCS_HOLD_DETAIL@TEMP AS OF SCN 5994454880116;

commit;

EXECUTE DBMS_LOGSTDBY.UNSKIP('DML','SMP','SFCS_HOLD_DETAIL');

analyze table smp.SFCS_HOLD_DETAIL compute statistics;

alter database start logical standby apply immediate;

ITPub博客

logical standby案例一