逻辑备库上有指定表不应用

因有要求要在逻辑备库上有指定表不应用，现做测试如下：

涉及到计费的表有：

charge_dtl

charge_group

charge_instr

charge_ref

cfs_tariff

liner_tariff

trk_tariff

一．前提条件，正常通讯的两台主备库

查询逻辑备库上正在执行归档量

select sequence#,first_change#,next_change#,timestamp,applied from dba_logstdby_log order by sequence# ;

查看主库的归档量

Archive log list;

检测是否备库与主库相同的归档量。

二．对于逻辑备库上:

1.停止正在应用的进程

SQL> alter database stop logical standby apply;

Database altered.

2.执行要在备库上应用跳过的表

SQL> execute dbms_logstdby.skip('DML','CTMS','CFS_TARIFF');

PL/SQL procedure successfully completed.

SQL> execute dbms_logstdby.skip('DML','CTMS','LINER_TARIFF');

PL/SQL procedure successfully completed.

SQL> execute dbms_logstdby.skip('DML','CTMS','TRK_TARIFF');

PL/SQL procedure successfully completed.

3.开启逻辑应用

SQL> alter database start logical standby apply immediate;

Database altered.

4.查询是否运用命令成功

SQL> select * from dba_logstdby_skip where owner='CTMS';

ERROR STATEMENT_OPT OWNER NAME USE_LIKE ESC PROC

------- --------------------- -------- ------------- ----------------------

N DML CTMS CFS_TARIFF Y

N DML CTMS LINER_TARIFF Y

N DML CTMS TRK_TARIFF Y

5.若要取消的话,用

execute dbms_logstdby.unskip('DML','CTMS','LINER_TARIFF');

[@more@]

test

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15242702/viewspace-1027180/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15242702/viewspace-1027180/