ORACLE 11204, OGG1121033,
请问:不想重新初始化,该如何修复,以便进程继续同步?
2016-11-22 00:31:41 INFO OGG-01738 BOUNDED RECOVERY: CHECKPOINT: for object pool 1: p26673180_Redo Thread 1: start=SeqNo: 17348, RBA: 66181648, SCN: 0.772537536 (772537536), Timestamp: 2016-11-22 00:31:15.000000, end=SeqNo: 17348,
RBA: 69490704, SCN: 0.772542025 (772542025), Timestamp: 2016-11-22 00:31:39.000000, Thread: 1.
9348 records processed as of 2016-11-22 00:38:41 (rate 0,delta 0)
9457 records processed as of 2016-11-22 01:09:46 (rate 0,delta 0)
9595 records processed as of 2016-11-22 01:39:53 (rate 0,delta 0)
10269 records processed as of 2016-11-22 02:10:01 (rate 0,delta 0)
10336 records processed as of 2016-11-22 02:40:47 (rate 0,delta 0)
10378 records processed as of 2016-11-22 03:11:12 (rate 0,delta 0)
10428 records processed as of 2016-11-22 03:41:20 (rate 0,delta 0)
10558 records processed as of 2016-11-22 04:17:34 (rate 0,delta 0)
TABLE resolved (entry TAS.HISHOLDERDETAIL):
TABLE "TAS"."HISHOLDERDETAIL";
2016-11-22 04:17:39 WARNING OGG-00869 No unique key is defined for table 'HISHOLDERDETAIL'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
Using the following key columns for source table TAS.HISHOLDERDETAIL: ENTRUSTID, TRADETIME, ACCOUNTCODE, GOODSCODE, QTY, FREEZEQTY, TRADEPRICE, HOLDERPRICE, BUYORSELL, CHARGE, INTEREST, BUYORSELLPTSUB, RECKONPL, USEDMARGIN, SPECIALACCO
UNT, HOLDERAMOUNT, DEALTICKET, RECKONDATE, DELIVERYSTATUS, STORAGECHARGE, ISRECKONED, TRADEAMOUNT, TRADEDATE, DELIVERYFREEZEQTY, OWECHARGEDAYS, RECKONPRICE.
TABLE resolved (entry TAS.HISORDERDETAIL):
TABLE "TAS"."HISORDERDETAIL";
2016-11-22 04:17:40 WARNING OGG-00869 No unique key is defined for table 'HISORDERDETAIL'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
Using the following key columns for source table TAS.HISORDERDETAIL: ORDERID, ORDERTICKET, ENTRUSTTRADEDATE, ENTRUSTTIME, ENTRUSTPRICE, SECENTRUSTID, MEMBERCODE, GOODSCODE, BUYORSELL, ORDERTYPE, ENTRUSTQTY, ALLOWTRADESUB, ACTIVEQTY, TR
ADEQTY, CANCELQTY, VALIDTYPE, VALIDTIME, AMOUNT, ISMAINORDER, RELATIONTICKET, SPECIALACCOUNT, BUYORSELLPTSUB, OPERATORCODE, ORDERSTATUS, ACCOUNTCODE, FREEZEMARGIN, CURTQUOTEPRICE, ERRORID, REMARK, RUNSTATUS, SESSIONID, SPPRICE, SLPRICE
, ORDERSRC, RECKONDATE, STORAGECHARGE, DELIVERYCONTENT, ORDERMODE, CLOSEMODE, AREACODE, RISKRATE, ACCOUNTSTATUS, GOODSID, REVERSEOPENFLAG, REOPENQTY, BIDMARKETFLAG.
TABLE resolved (entry TAS.HISTAACCOUNT):
TABLE "TAS"."HISTAACCOUNT";
2016-11-22 04:17:40 WARNING OGG-00869 No unique key is defined for table 'HISTAACCOUNT'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
Using the following key columns for source table TAS.HISTAACCOUNT: ACCOUNTCODE, TAACCOUNTCODE, CURRENCY, NETWORTH, BALANCE, CURRENTNETWORTH, CURRENTBALANCE, INAMOUNT, OUTAMOUNT, TRADECHARGE, INTEREST, CLOSEPL, RECKONPL, DELIVERYCHARGE,
DELIVERYMARGIN, USEDMARGIN, FREEZEMARGIN, AVAILMARGIN, AVAILMARGINLIMIT, MAXUSEDMARGIN, RECKONDATE, STORAGECHARGE, CREATETIME, MAXAGREEAMOUNT, EXPAYAMOUNT, EXFREEZEAMOUNT, BALANCEINTEREST, PREVBALANCEINTEREST, USEDMARGININC, INSPECTIO
NCHANGES, GODOWNCHANGES, ATTORNCHARGE, ATTORNPAYMENT, DELIVERYDELAY, EXAMOUNT, SYSTEMMODULECHARGE, SYSTEMMODULEMONEY, SYSTEMMODULEFREEZEMONEY, SYSTEMMODULEINTEREST.
2016-11-22 04:31:42 INFO OGG-01738 BOUNDED RECOVERY: CHECKPOINT: for object pool 1: p26673180_Redo Thread 1: start=SeqNo: 17360, RBA: 61937168, SCN: 0.774731380 (774731380), Timestamp: 2016-11-22 04:31:24.000000, end=SeqNo: 17360,
RBA: 63357952, SCN: 0.774733198 (774733198), Timestamp: 2016-11-22 04:31:41.000000, Thread: 1.
101485 records processed as of 2016-11-22 07:00:07 (rate 0,delta 9)
101591 records processed as of 2016-11-22 07:30:36 (rate 0,delta 0)
101785 records processed as of 2016-11-22 08:00:43 (rate 0,delta 0)
101906 records processed as of 2016-11-22 08:31:21 (rate 0,delta 0)