逻辑standby的skip_error实践：

botang

1. select  to_char(e.EVENT), e.EVENT_TIME
   
2. from dba_logstdby_events e order by 2 desc;
   
3. 
   
4. 
   
5. select  * from dba_logstdby_skip;
   
6. 
   
7. select APPLIED_SCN,LATEST_SCN, MINING_SCN from v$logstdby_progress;
   
8. 
   
9. select  * from dba_logstdby_progress;
   
10.   
    
11.    
    
12.    begin
    
13.    dbms_logstdby.skip_error('DML','SH','CMP4$88063');
    
14.    end;
    
15. 
    
16. begin
    
17.    dbms_logstdby.skip_error('SCHEMA_DDL','SH','CMP4$88063');
    
18.    end;
    
19. 
    
20. begin
    
21.    dbms_logstdby.skip_error('TABLE','SH','CMP4$88063');
    
22.    end;
    

复制代码

dbms_logstdby.skip_error的第一个参数的介绍：
Supported Values for the stmt Parameter
Keyword         Associated SQL Statements

NON_SCHEMA_DDL
        All DDL that does not pertain to a particular schema
Note: SCHEMA_NAME and OBJECT_NAME must be null

SCHEMA_DDL
        All DDL statements that create, modify, or drop schema objects (for example: tables, indexes, and columns)
Note: SCHEMA_NAME and OBJECT_NAME must not be null

DML
        Includes DML statements on a table (for example: INSERT, UPDATE, and DELETE)

CLUSTER
        AUDIT CLUSTER
CREATE CLUSTER
DROP CLUSTER
TRUNCATE CLUSTER

CONTEXT
        CREATE CONTEXT
DROP CONTEXT

DATABASE LINK
        CREATE DATABASE LINK
CREATE PUBLIC DATABASE LINK
DROP DATABASE LINK
DROP PUBLIC DATABASE LINK

DIMENSION
        ALTER DIMENSION
CREATE DIMENSION
DROP DIMENSION

DIRECTORY
        CREATE DIRECTORY
DROP DIRECTORY

INDEX
        ALTER INDEX
CREATE INDEX
DROP INDEX

PROCEDURE
        ALTER FUNCTION
ALTER PACKAGE
ALTER PACKAGE BODY
ALTER PROCEDURE
CREATE FUNCTION
CREATE LIBRARY
CREATE PACKAGE
CREATE PACKAGE BODY
CREATE PROCEDURE
DROP FUNCTION
DROP LIBRARY
DROP PACKAGE
DROP PACKAGE BODY
DROP PROCEDURE

PROFILE
        ALTER PROFILE
CREATE PROFILE
DROP PROFILE

ROLE
        ALTER ROLE
CREATE ROLE
DROP ROLE
SET ROLE

ROLLBACK STATEMENT
        ALTER ROLLBACK SEGMENT
CREATE ROLLBACK SEGMENT
DROP ROLLBACK SEGMENT

SEQUENCE
        ALTER SEQUENCE
CREATE SEQUENCE
DROP SEQUENCE

SYNONYM
        CREATE PUBLIC SYNONYM
CREATE SYNONYM
DROP PUBLIC SYNONYM
DROP SYNONYM

TABLE
        ALTER TABLE
CREATE TABLE
DROP TABLE

TABLESPACE
        CREATE TABLESPACE
DROP TABLESPACE
TRUNCATE TABLESPACE

TRIGGER
        ALTER TRIGGER
CREATE TRIGGER
DISABLE ALL TRIGGERS
DISABLE TRIGGER
DROP TRIGGER
ENABLE ALL TRIGGERS
ENABLE TRIGGER

TYPE
        ALTER TYPE
ALTER TYPE BODY
CREATE TYPE
CREATE TYPE BODY
DROP TYPE
DROP TYPE BODY

USER
        ALTER USER
CREATE USER
DROP USER

VIEW
        CREATE VIEW
DROP VIEW