OGG错误集Word格式文档下载.docx
- 文档编号:17605258
- 上传时间:2022-12-07
- 格式:DOCX
- 页数:12
- 大小:22.35KB
OGG错误集Word格式文档下载.docx
《OGG错误集Word格式文档下载.docx》由会员分享,可在线阅读,更多相关《OGG错误集Word格式文档下载.docx(12页珍藏版)》请在冰豆网上搜索。
队列文件捕捉错误
5.2013-09-0514:
54INFOOGG-01020ProcessedextractprocessRESTART_ABENDrecordatseq45,rba1989(aborted0records).
队列文件错误
6.2013-09-0914:
07:
15ERROROGG-01028Incompatiblerecord(logicalEOF)in./dirdat/VB000010,rba1469.
队列文件出错,队列文件絮乱
7.2013-09-1012:
56:
47ERROROGG-00664OCIErrorbeginningsession(status=12705-ORA-12705:
CannotaccessNLSdatafilesorinval
idenvironmentspecified).
8.2013-09-1012:
47ERROROGG-01668PROCESSABENDING.
编码双引号为中文状态
9.2013-10-1409:
16:
04ERROROGG-00446OracleGoldenGateCaptureforOracle,extbam.prm:
GettingattributesforASMfile+dcods/yyjc/archivelog/2_36623_4.dbf,SQL<
BEGINdbms_diskgroup.getfileattr('
+dcods/yyjc/archivelog/2_36623_4.dbf'
:
filetype,:
filesize,:
lblksize);
END;
>
(15056)ORA-15056:
additionalerrormessageORA-15173:
entry'
2_36623_4.dbf'
doesnotexistindirectory'
archivelog'
ORA-06512:
at"
SYS.X$DBMS_DISKGROUP"
line201ORA-06512:
atline1Notabletoestablishinitialpositionforsequence36623,rba.
10.2013-10-1409:
04ERROROGG-01668OracleGoldenGateCaptureforOracle,extbam.prm:
PROCESSABENDING.
11.数据库归档丢失
12.2013-09-1509:
48:
37ERROROGG-00360WHEREcannotbeusedwithPASSTHRU.
过滤条件有where不能用passthru
修改ogg配置参数过后必须要从新启动该进程
13.2013-09-1622:
58:
31ERROROGG-00446Unabletolockfile"
/ogghome/dirchk/SPUMPCQ.cpe"
(error11,Resourcetemporarilyunavailabl
Lockcurrentlyheldbyprocessid(PID)2562.ERROROGG-01668PROCESSABENDING.
进程名称不一致,和添加远程队列不一致
14.2013-09-2509:
23ERROROGG-00664OCIErrorbeginningsession(status=1034-ORA-01034:
ORACLEnotavailable
15.ORA-27101:
sharedmemoryrealmdoesnotexist
数据库实例为启动
16.ERROROGG-00014OracleGoldenGateDeliveryforOracle,treplbj.prm:
Unrecognizedparameter:
EPLICAT.Parametercouldbemisspelledorunsupported.
参数错误
17.ERROROGG-00199OracleGoldenGateDeliveryforOracle,treplcq.prm:
TableXF_OGG_TEST.ECP_CONPERF_RECEIVEDdoesnotexistintargetdatabase.
不存在这个表,参数错误
18.WARNINGOGG-00869OracleGoldenGateDeliveryforOracle,treplcq.prm:
OCIErrorORA-00001:
uniqueconstraint(XF_OGG_TEST.PK_PRE_BUS_ITEMFACT_S)violated(status=1),SQL<
INSERTINTO"
XF_OGG_TEST"
PRE_BUS_ITEMFACT_S"
唯一约束造成数据不一致
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:
队列文件读取错误【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:
ExtractERROR180encounteredcommitSCN<
scn>
thatisnotgreaterthanthehighestSCNalreadyprocessed
SolutionOverview:
Thiserroroccursshortlyafteratransactioniswrittentotheidlenodebutdoesnotyetappearintheredologwhenthecurrenttransactionisprocessed.ThistransactionwillhaveahigherSCNthantheprevioustransaction
SolutionDetails:
InanOracleRACenvironment,Extracthasacoordinatorthread.ThisthreadassemblestheoperationsthataregeneratedoneachoftheRACnodesintoSCNorder.Beforestartingtoassemblethetransactions,ExtractwaitsforashorttimeafterOraclewritesthetransactiontotheredolog.Ifanodehasbeenidlewithnotransactions,ExtractwaitsthenumberofmillisecondsspecifiedintheExtractparameterTHREADOPTIONSMAXCOMMITPROPAGATIONDELAY(default3seconds).Waitingensuresthattherearenonewtransactionsontheidlenodebeforewritingthecurrenttransactionstothetrail.
HowtorecoverfromExtractERROR180encounteredcommitSCNthatisnotgreaterthanthehighestSCNalreadyprocessed(GGVersion10)[ID987379.1]
andlater
10.0.0andlater]
Goal
HowtorecoverfromExtractERROR180encounteredcommitSCN<
n.xxx>
thatisnotgreaterthanthehighestSCNalreadyprocessed(GGVersion10)
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
someoutputfromggserr.log
1.2012-10-1719:
47:
58
INFO
OGG-00975
OracleGoldenGateManager
for
Oracle,mgr.prm:
EXTRACTRACDPstarting.
2.2012-10-1719:
OGG-00992
OracleGoldenGateCapture
Oracle,racdp.prm:
3.2012-10-1719:
59
OGG-00993
EXTRACTRACDPstarted.
4.2012-10-1719:
04
OGG-01226
Socketbuffer
size
set
to
27985(flush
27985).
5.--Thisistheerror....
6.2012-10-1719:
ERROR
OGG-01496
Failed
open
targettrailfile./dirdat/DP000000,
at
RBA4499.
7.2012-10-1719:
OGG-01668
IhadtrailfilemissingonTargetside,whichDATAPUMPwaslookingfor.
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
03.2012-10-1719:
54:
30
OGG-01520
Rolloverperformed.
For
eachaffected
output
trail
of
Version10
or
higherformat,after
startingthesourceextract,issue
EXTSEQNO
thattrail'
sreader(eitherpumpEXTRACTorREPLICAT)tomovethereader'
sscan
thenewtrailfile;
itwill
not
happenautomatically.
04.EXTRACTaltered.
05.
06.
07.GGSCI(12>
14.
15.ExtractTrail:
16.Extract:
17.Seqno:
18.RBA:
19.File
20.
21.
22.
23.GGSCI(13>
STARTRACDP
24.
25.SendingSTARTrequest
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
01
35.EXTRACT
RACDP
02
36.
37.
38.2012-10-1719:
55:
20
39.2012-10-1719:
40.2012-10-1719:
31
41.2012-10-1719:
39
42.2012-10-1719:
40
OGG-01052
No
recovery
is
required
targetfile./dirdat/DP000001,
RBA0(file
n
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- OGG 错误
![提示](https://static.bdocx.com/images/bang_tan.gif)