逻辑Data Guard管理.doc

逻辑Data Guard的管理 指定对象跳过应用使用DBMS_LOGSTDBY.SKIP（ stmt IN VARCHER2, schema_name IN VARCHER2 DEFAULT NULL, object_name IN VARCHER2 DEFAULT NULL, proc_name IN VARCHER2 DEFAULT NULL, use_like IN BOOLEAN DEFAULT TURE, esc IN CHAR1 DEFAULT NULL ） 比如要跳过SCOTT用户下对DG_TEST的DML操作 指定跳过对象之前需关闭SQL应用 SQL alter database stop logical standby apply; Database altered. SQL exec dbms_logstdby.skip(stmt = DML,schema_name = SCOTT, object_name = DG_TEST); PL/SQL procedure successfully completed. SQL select OWNER,STATEMENT_OPT,NAME,USE_LIKE from dba_logstdby_skip; OWNER STATEMENT_OPT NAME USE_LIKE -------------------- -------------------- ---------- ---------- SCOTT DML DG_TEST Y SYSTEM INTERNAL SCHEMA % Y SYS INTERNAL SCHEMA % Y OLAPSYS INTERNAL SCHEMA % Y BI INTERNAL SCHEMA % Y SI_INFORMTN_SCHEMA INTERNAL SCHEMA % Y MGMT_VIEW INTERNAL SCHEMA % Y SQL alter database start logical standby apply immediate; Database altered. 此时在primary端插入测试数据： PRIMARY select count(*) from scott.dg_test; COUNT(*) ---------- 8 PRIMARY insert into scott.dg_test 2 select * from scott.dg_test 3 / 8 rows created. PRIMARY commit; Commit complete. PRIMARY select count(*) from scott.dg_test; COUNT(*) ---------- 16 standby端查看该DML操作将跳过应用 SQL select count(*) from scott.dg_test; COUNT(*) ---------- 8 取消对象跳过应用 使用DBMS_LOGSTDBY.UNSKIP（ stmt IN VARCHAR2, schema_name IN VARCHAR2, object_name IN VARCHAR2） SQL select OWNER,STATEMENT_OPT,NAME,USE_LIKE from dba_logstdby_skip; OWNER STATEMENT_OPT NAME USE_LIKE -------------------- -------------------- ---------- ---------- SCOTT DML DG_TEST Y SYSTEM INTERNAL SCHEMA % Y 具体步骤：