唯一约束造成数据不一致
19.ERROROGG-01296OracleGoldenGateDeliveryforOracle,treplcq.prm:
ErrormappingfromXF_OGG_TEST.PRE_BUS_ITEMFACT_StoXF_OGG_TEST.PRE_BUS_ITEMFACT_S.
数据不一致
20.ERROROGG-01028OracleGoldenGateDeliveryforOracle,treplcq.prm:
Incompatiblerecordin./dirdat/CQ000067,rba4779(gettingheader).
21.ERROROGG-01668OracleGoldenGateDeliveryforOracle,treplcq.prm:
PROCESSABENDING.
队列文件读取错误【discard文件详细信息】
22.SQLerror1403mappingXF_OGG_TEST.PRE_BUS_ITEMFACT_StoXF_OGG_TEST.PRE_BUS_ITEMFACT_S.
数据不一致【discard文件详细信息】
23.ERROROGG-01161OracleGoldenGateDeliveryforOracle,treplvj.prm:
Badcolumnindex(3)specifiedfortableGGS.DEMO2,maxcolumns=3
表结构不一致
24.ERROROGG-01044OracleGoldenGateCaptureforOracle,spumpbj.prm:
Thetrail'./dirdat/CQ'isnotassignedtoextract'SPUMPBJ'.Assignthetrailtotheextractwiththecommand"ADDEXTTRAIL/RMTTRAIL./dirdat/CQ,EXTRACTSPUMPBJ.
未添加所要投递队列的名称,或者添加错误
25.ERROROGG-00664OracleGoldenGateCaptureforOracle,spumpbj.prm:
OCIErrorduringOCIServerAttach(status=12514-ORA-12514:
TNS:
listenerdoesnotcurrentlyknowofservicerequestedinconnectdescriptor).
26.GGSCI(ogg1)16>addtrandatamytest.demo;
ERROR:
Noviabletablesmatchedspecification
ogguser权限不足
27../ggsci:
errorwhileloadingsharedlibraries:
libnnz11.so:
cannotopensharedobjectfile:
Nosuchfileordirectory
exportLD_LIBRARY_PATH=$ORACLE_HOME/lib环境变量未引入
vi.bash_profile---..bash_profilesource.bash_profile
26.ERROROGG-00868nodatafoundretrievingiftoignorethisobject
异构文件生成过程中报错。
用户下面没有某张表。
表所在用户填写错误。
27.OGG-01028encounteredcommitSCN0.5(5)thatisnotgreaterthanthehighestSCNalreadyprocessed0.9
解决办法:
Documentsearched:
OGGEncounteredSCNThatIsNotGreaterThanTheHighestSCNAlreadyProcessed[ID957112.1]
Appliesto:
OracleGoldenGate-Version:
6.0.0andlater [Release:
6.0.0andlater]
Informationinthisdocumentappliestoanyplatform.
Solution
Issue:
ExtractERROR180encounteredcommitSCNthatisnotgreaterthanthehighestSCNalreadyprocessed
SolutionOverview:
Thiserroroccursshortlyafteratransactioniswrittentotheidlenodebutdoesnotyetappearintheredologwhenthecurrenttransactionisprocessed.ThistransactionwillhaveahigherSCNthantheprevioustransaction
SolutionDetails:
InanOracleRACenvironment,Extracthasacoordinatorthread.ThisthreadassemblestheoperationsthataregeneratedoneachoftheRACnodesintoSCNorder.Beforestartingtoassemblethetransactions,ExtractwaitsforashorttimeafterOraclewritesthetransactiontotheredolog.Ifanodehasbeenidlewithnotransactions,ExtractwaitsthenumberofmillisecondsspecifiedintheExtractparameterTHREADOPTIONSMAXCOMMITPROPAGATIONDELAY(default3seconds).Waitingensuresthattherearenonewtransactionsontheidlenodebeforewritingthecurrenttransactionstothetrail.
HowtorecoverfromExtractERROR180encounteredcommitSCNthatisnotgreaterthanthehighestSCNalreadyprocessed(GGVersion10)[ID987379.1]
Appliesto:
OracleGoldenGate-Version:
andlater [Release:
10.0.0andlater]
Informationinthisdocumentappliestoanyplatform.
Goal
HowtorecoverfromExtractERROR180encounteredcommitSCNthatisnotgreaterthanthehighestSCNalreadyprocessed(GGVersion10)
Solution
ThisappliesforOracleGoldenGateVersion10andaboveonlyusingVersion10formattedtrailandNOTusingtheRMTTRAILorEXTTRAILFORMATRELEASEparameter.
28OGG-01496Failedtoopentargettrailfile---投递进程
MyDatapumpwasabendingafterstart,becauseItwaslookingforMISSINGremotetrailfileatperticularRBA,thattrailfilewasdeleted.
Ifyouwanttorepositionextractpleasevisit. Re-positionExtractatparticularRBA
hereisfromsourceside.
viewsource
print?
01.GGSCI(6>INFORMTTRAIL*
02.
03.ExtractTrail:
./dirdat/DE
04.Extract:
RACDE
05.Seqno:
1
06.RBA:
1049
07.File Size:
10M
08.
09.ExtractTrail:
./dirdat/DP
10.Extract:
RACDP
11.Seqno:
0
12.RBA:
4499
13.File Size:
10M
someoutputfromggserr.log
1.2012-10-1719:
47:
58 INFO OGG-00975 OracleGoldenGateManager for Oracle,mgr.prm:
EXTRACTRACDPstarting.
2.2012-10-1719:
47:
58 INFO OGG-00992 OracleGoldenGateCapture for Oracle,racdp.prm:
EXTRACTRACDPstarting.
3.2012-10-1719:
47:
59 INFO OGG-00993 OracleGoldenGateCapture for Oracle,racdp.prm:
EXTRACTRACDPstarted.
4.2012-10-1719:
48:
04 INFO OGG-01226 OracleGoldenGateCapture for Oracle,racdp.prm:
Socketbuffer size set to 27985(flush size 27985).
5.--Thisistheerror....
6.2012-10-1719:
48:
04 ERROR OGG-01496 OracleGoldenGateCapture for Oracle,racdp.prm:
Failed to open targettrailfile./dirdat/DP000000, at RBA4499.
7.2012-10-1719:
48:
04 ERROR OGG-01668 OracleGoldenGateCapture for Oracle,racdp.prm:
PROCESSABENDING.
IhadtrailfilemissingonTargetside,whichDATAPUMPwaslookingfor.
viewsource
print?
1.TEST:
/u00/app/gghome/dirdat:
TEST$ll
2.total12
3.-rw-rw-rw- 1oracleoinstall1167Aug 209:
49XP000000
4.drwxr-xr-x14oracleoinstall4096Oct1716:
10..
5.drwxrwxr-x 2oracleoinstall4096Oct1716:
52.
SoididthisbelowonSourcesideandstartdatapumpsuccessfully.
GGSCI(11> ALTER EXTRACTRACDPETROLLOVER
02.
03.2012-10-1719:
54:
30 INFO OGG-01520 Rolloverperformed. For eachaffected output trail of Version10 or higherformat,after startingthesourceextract,issue ALTER EXTSEQNO for thattrail'sreader(eitherpumpEXTRACTorREPLICAT)tomovethereader'sscan to thenewtrailfile; itwill not happenautomatically.
04.EXTRACTaltered.
05.
06.
07.GGSCI(12>INFORMTTRAIL*
08.
09.ExtractTrail:
./dirdat/DE
10.Extract:
RACDE
11.Seqno:
1
12.RBA:
1049
13.File Size:
10M
14.
15.ExtractTrail:
./dirdat/DP
16.Extract:
RACDP
17.Seqno:
1
18.RBA:
0
19.File Size:
10M
20.
21.
22.
23.GGSCI(13>STARTRACDP
24.
25.SendingSTARTrequest to MANAGER...
26.EXTRACTRACDPstarting
27.
28.
29.GGSCI(14>info all
30.
31.Program Status Group Lag Time SinceChkpt
32.
33.MANAGER RUNNING
34.EXTRACT RUNNING RACDE 00:
00:
00 00:
00:
01
35.EXTRACT RUNNING RACDP 00:
00:
00 00:
00:
02
36.
37.
38.2012-10-1719:
55:
20 INFO OGG-00975 OracleGoldenGateManager for Oracle,mgr.prm:
EXTRACTRACDPstarting.
39.2012-10-1719:
55:
20 INFO OGG-00992 OracleGoldenGateCapture for Oracle,racdp.prm:
EXTRACTRACDPstarting.
40.2012-10-1719:
55:
31 INFO OGG-00993 OracleGoldenGateCapture for Oracle,racdp.prm:
EXTRACTRACDPstarted.
41.2012-10-1719:
55:
39 INFO OGG-01226 OracleGoldenGateCapture for Oracle,racdp.prm:
Socketbuffer size set to 27985(flush size 27985).
42.2012-10-1719:
55:
40 INFO OGG-01052 OracleGoldenGateCapture for Oracle,racdp.prm:
No recovery is required for targetfile./dirdat/DP000001, at RBA0(file n