2015-01-21 11:08:33 ERROR OGG-00519 Fatal error executing DDL replication: error [Error code [955], ORA-00955: name is alrea
dy used by an existing object SQL CREATE TABLE "SCOTT"."SYS_EXPORT_SCHEMA_01" (process_order NUMBER, duplicate NUMBER, dump_file
id NUMBER, dump_position NUMBER, dump_length NUMBER, dump_orig_length NUMBER, dump_allocation NUMBER, completed_rows NUMBER, err
or_count NUMBER, elapsed_time NUMBER, object_type_path VARCHAR2(200), object_path_seqno NUMBER, object_type VARCHAR2(30), in_pro
gress CHAR(1), object_name VARCHAR2(500), object_long_name VARCHAR2(4000), object_schema VARCHAR2(30), original_object_schema VA
RCHAR2(30), original_object_name VARCHAR2(4000), partition_name VARCHAR2(30), subpartition_name VARCHAR2(30), dataobj_num NUMBER
, flags NUMBER, property NUMBER, trigflag NUMBER, creation_level NUMBER, completion_time DATE, object_tablespace VARCHAR2(30), s
ize_estimate NUMBER, object_row NUMBER, processing_state CHAR(1), processing_status CHAR(1), base_process_order NUMBER, base_obj
ect_type VARCHAR2(30), base_object_name VARCHAR2(30), base_object_schema VARCHAR2(30), ancestor_process_order NUMBER, domain_pro
cess_order NUMBER, parallelization NUMBER, unload_method NUMBER, load_method NUMBER, granules NUMBER, scn NUMBER, grantor VARCHA
R2(30), xml_clob CLOB, parent_process_order NUMBER, name VARCHAR2(30), value_t VARCHAR2(4000), value_n NUMBER, is_default NUMBER
, file_type NUMBER, user_directory VARCHAR2(4000), user_file_name VARCHAR2(4000), file_name VARCHAR2(4000), extend_size NUMBER,
file_max_size NUMBER, process_name VARCHAR2(30), last_update DATE, work_item VARCHAR2(30), object_number NUMBER, completed_bytes
NUMBER, total_bytes NUMBER, metadata_io NUMBER, data_io NUMBER, cumulative_time NUMBER, packet_number NUMBER, instance_id NUMBE
R, old_value VARCHAR2(4000), seed NUMBER, last_file NUMBER, user_name VARCHAR2(30), operation VARCHAR2(30), job_mode VARCHAR2(30
), queue_tabnum NUMBER, control_queue VARCHAR2(30), status_queue VARCHAR2(30), remote_link VARCHAR2(4000), version NUMBER, job_v
ersion VARCHAR2(30), db_version VARCHAR2(30), timezone VARCHAR2(64), state VARCHAR2(30), phase NUMBER, guid RAW(16), start_time
DATE, block_size NUMBER, metadata_buffer_size NUMBER, data_buffer_size NUMBER, degree NUMBER, platform VARCHAR2(101), abort_step
NUMBER, instance VARCHAR2(60), cluster_ok NUMBER, service_name VARCHAR2(100), object_int_oid VARCHAR2(32)) SEGMENT CREATION IMM
EDIATE INITRANS 10 /* GOLDENGATE_DDL_REPLICATION */], no error handler present.
目标数据库错误:
2011-02-28 14:19:39 ERROR OGG-00519 Oracle GoldenGate Delivery for Oracle, rorabb.prm: Fatal error executing DDL replication: error [Error code [1435], ORA-01435: ?????, SQL ALTER SESSION SET CURRENT_SCHEMA=SWASBHOM ], no error handler present.
2011-02-28 14:19:39 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rorabb.prm: PROCESS ABENDING.
解决:
在复制进程脚本加上
DDL INCLUDE MAPPED
DDLERROR DEFAULT IGNORE RETRYOP
把进程修改成如下格式:
REPLICAT roraBB
userid userid gg,password gg
HANDLECOLLISIONS
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/roraBB.DSC, PURGE,MAXBYTES 50000000
DDL INCLUDE MAPPED
DDLERROR DEFAULT IGNORE RETRYOP
MAP OWAS.*, TARGET OWAS.*;
MAPEXCLUDE OWAS.SYS_IMPORT_FULL_01, TARGET OWAS.SYS_IMPORT_FULL_01;
MAPEXCLUDE OWAS.SYS_EXPORT_SCHEMA_01, TARGET OWAS.SYS_EXPORT_SCHEMA_01;
然后重新启动进程。