逻辑standby的skip_error实践：
selectto_char(e.EVENT), e.EVENT_TIMEfrom dba_logstdby_events e order by 2 desc;
select* from dba_logstdby_skip;
select APPLIED_SCN,LATEST_SCN, MINING_SCN from v$logstdby_progress;
select* from dba_logstdby_progress;
begin
dbms_logstdby.skip_error('DML','SH','CMP4$88063');
end;
begin
dbms_logstdby.skip_error('SCHEMA_DDL','SH','CMP4$88063');
end;
begin
dbms_logstdby.skip_error('TABLE','SH','CMP4$88063');
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
页:
[1]