OGG数据导入时发生的错误

yjh625

在OGG环境中的source端通过impdp的数据导入时，target的replicat出现异常终止，具体错误信息见如下：

2012-05-03 14:48:35  WARNING OGG-00869  No unique key is defined for table SYS_IMPORT_FULL_01. All viable columns will be used to represent the key, but may
not guarantee uniqueness.  KEYCOLS may be used to define the key.
Using following columns in default map by name:
  PROCESS_ORDER, DUPLICATE, DUMP_FILEID, DUMP_POSITION, DUMP_LENGTH,
  DUMP_ALLOCATION, COMPLETED_ROWS, ERROR_COUNT, ELAPSED_TIME,
  OBJECT_TYPE_PATH, OBJECT_PATH_SEQNO, OBJECT_TYPE, IN_PROGRESS,
  OBJECT_NAME, OBJECT_LONG_NAME, OBJECT_SCHEMA, ORIGINAL_OBJECT_SCHEMA,
  PARTITION_NAME, SUBPARTITION_NAME, FLAGS, PROPERTY, COMPLETION_TIME,
  OBJECT_TABLESPACE, SIZE_ESTIMATE, OBJECT_ROW, PROCESSING_STATE,
  PROCESSING_STATUS, BASE_PROCESS_ORDER, BASE_OBJECT_TYPE,
  BASE_OBJECT_NAME, BASE_OBJECT_SCHEMA, ANCESTOR_PROCESS_ORDER,
  DOMAIN_PROCESS_ORDER, PARALLELIZATION, UNLOAD_METHOD, GRANULES, SCN,
  GRANTOR, XML_CLOB, NAME, VALUE_T, VALUE_N, IS_DEFAULT, FILE_TYPE,
  USER_DIRECTORY, USER_FILE_NAME, FILE_NAME, EXTEND_SIZE,
  FILE_MAX_SIZE, PROCESS_NAME, LAST_UPDATE, WORK_ITEM, OBJECT_NUMBER,
  COMPLETED_BYTES, TOTAL_BYTES, METADATA_IO, DATA_IO, CUMULATIVE_TIME,
  PACKET_NUMBER, OLD_VALUE, SEED, LAST_FILE, USER_NAME, OPERATION,
  JOB_MODE, CONTROL_QUEUE, STATUS_QUEUE, REMOTE_LINK, VERSION,
  DB_VERSION, TIMEZONE, STATE, PHASE, GUID, START_TIME, BLOCK_SIZE,
  METADATA_BUFFER_SIZE, DATA_BUFFER_SIZE, DEGREE, PLATFORM, ABORT_STEP,
  INSTANCE

Using the following key columns for target table EAUSER.SYS_IMPORT_FULL_01: PROCESS_ORDER, DUPLICATE, DUMP_FILEID, DUMP_POSITION, DUMP_LENGTH, DUMP_ALLOCATIO
N, COMPLETED_ROWS, ERROR_COUNT, ELAPSED_TIME, OBJECT_TYPE_PATH, OBJECT_PATH_SEQNO, OBJECT_TYPE, IN_PROGRESS, OBJECT_NAME, OBJECT_LONG_NAME, OBJECT_SCHEMA, OR
IGINAL_OBJECT_SCHEMA, PARTITION_NAME, SUBPARTITION_NAME, FLAGS, PROPERTY, COMPLETION_TIME, OBJECT_TABLESPACE, SIZE_ESTIMATE, OBJECT_ROW, PROCESSING_STATE, PR
OCESSING_STATUS, BASE_PROCESS_ORDER, BASE_OBJECT_TYPE, BASE_OBJECT_NAME, BASE_OBJECT_SCHEMA, ANCESTOR_PROCESS_ORDER, DOMAIN_PROCESS_ORDER, PARALLELIZATION, U
NLOAD_METHOD, GRANULES, SCN, GRANTOR, NAME, VALUE_T, VALUE_N, IS_DEFAULT, FILE_TYPE, USER_DIRECTORY, USER_FILE_NAME, FILE_NAME, EXTEND_SIZE, FILE_MAX_SIZE, P
ROCESS_NAME, LAST_UPDATE, WORK_ITEM, OBJECT_NUMBER, COMPLETED_BYTES, TOTAL_BYTES, METADATA_IO, DATA_IO, CUMULATIVE_TIME, PACKET_NUMBER, OLD_VALUE, SEED, LAST
_FILE, USER_NAME, OPERATION, JOB_MODE, CONTROL_QUEUE, STATUS_QUEUE, REMOTE_LINK, VERSION, DB_VERSION, TIMEZONE, STATE, PHASE, GUID, START_TIME, BLOCK_SIZE, M
ETADATA_BUFFER_SIZE, DATA_BUFFER_SIZE, DEGREE, PLATFORM, ABORT_STEP, INSTANCE.


2012-05-03 14:48:35  WARNING OGG-01004  Aborted grouped transaction on 'EAUSER.SYS_IMPORT_FULL_01', Database error 1403 ().

2012-05-03 14:48:35  WARNING OGG-01003  Repositioning to rba 24038 in seqno 68.

2012-05-03 14:48:35  WARNING OGG-01154  SQL error 1403 mapping EAUSER.SYS_IMPORT_FULL_01 to EAUSER.SYS_IMPORT_FULL_01.

2012-05-03 14:48:35  WARNING OGG-01003  Repositioning to rba 24038 in seqno 68.

Source Context :
  SourceModule            : [er.main]
  SourceID                : [/scratch/pradshar/view_storage/pradshar_bugdbrh40_12927937/oggcore/OpenSys/src/app/er/rep.c]
  SourceFunction          : [take_rep_err_action]
  SourceLine              : [16148]
  ThreadBacktrace         : [8] elements
                          : [/data/ora10g/ggate/replicat(CMessageContext::AddThreadContext()+0x26) [0x5f1e56]]
                          : [/data/ora10g/ggate/replicat(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x7b2) [0x5e88f2]]
                          : [/data/ora10g/ggate/replicat(_MSG_ERR_MAP_TO_TANDEM_FAILED(CSourceContext*, DBString<777> const&, DBString<777> const&, CMessageF
actory::MessageDisposition)+0x9b) [0x5c6d4b]]
                          : [/data/ora10g/ggate/replicat [0x81beca]]
                          : [/data/ora10g/ggate/replicat [0x8f93d9]]
                          : [/data/ora10g/ggate/replicat(main+0x84b) [0x507a0b]]
                          : [/lib64/libc.so.6(__libc_start_main+0xf4) [0x3f9ba1d974]]
                          : [/data/ora10g/ggate/replicat(__gxx_personality_v0+0x1e2) [0x4e3ffa]]

2012-05-03 14:48:35  ERROR   OGG-01296  Error mapping from EAUSER.SYS_IMPORT_FULL_01 to EAUSER.SYS_IMPORT_FULL_01.

具体的错误日志文档和配置文档详见附件，请刘大帮忙看看。

另还想请问下刘大像类似这种target出现异常中止的情况，我们一般怎么来快速恢复啦？我现在还是原始的办法，重新创建source、target的抓取和复制进程，但是这样的话，很耗时间，并且线上环境也是不允许这样的；能不能实现在target通过命令跳过这个复制。