been idle with no transactions, Extract waits the number of milliseconds specified in the Extract parameter THREADOPTIONS
MAXCOMMITPROPAGATIONDELAY (default 3 seconds). Waiting ensures that there are no new transactions on the idle node before writing the current transactions to the trail.
How to recover from Extract ERROR 180 encountered commit SCN that is not greater than the highest SCN already processed (GG Version 10) [ID 987379.1] Applies to: Oracle GoldenGate - Version: 10.0.0.0 and later [Release: 10.0.0 and later ] Information in this document applies to any platform. Goal How to recover from Extract ERROR 180 encountered commit SCN
If you want to reposition extract please visit. Re-position Extract at particular RBA
here is from source side.
view source print?
01.GGSCI (RACD1.localdomain.com) 6> INFO RMTTRAIL * 02.
03.Extract Trail: ./dirdat/DE
04.Extract: RACDE 05.Seqno: 1 06.RBA: 1049
07.File Size: 10M 08.
09.Extract Trail: ./dirdat/DP 10.Extract: RACDP 11.Seqno: 0 12.RBA: 4499
13.File Size: 10M
some output from ggserr.log
1.2012-10-17 19:47:58 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT RACDP starting.
2.2012-10-17 19:47:58 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, racdp.prm: EXTRACT RACDP starting.
3.2012-10-17 19:47:59 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, racdp.prm: EXTRACT RACDP started.
4.2012-10-17 19:48:04 INFO OGG-01226 Oracle GoldenGate Capture for Oracle, racdp.prm: Socket buffer size set to 27985 (flush size 27985).
5.--This is the error....
6.2012-10-17 19:48:04 ERROR OGG-01496 Oracle GoldenGate Capture for Oracle, racdp.prm: Failed to open target trail file ./dirdat/DP000000, at RBA 4499.
7.2012-10-17 19:48:04 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, racdp.prm: PROCESS ABENDING.
I had trailfile missing on Target side, which DATAPUMP was looking for.
view source print?
1.TEST:/u00/app/gghome/dirdat :TEST$ll 2.total 12
3.-rw-rw-rw- 1 oracle oinstall 1167 Aug 2 09:49 XP000000 4.drwxr-xr-x 14 oracle oinstall 4096 Oct 17 16:10 .. 5.drwxrwxr-x 2 oracle oinstall 4096 Oct 17 16:52 .
So i did this below on Source side and start datapump successfully.
GGSCI (RACD1.localdomain.com) 11> ALTER EXTRACT RACDP ETROLLOVER 02.
03.2012-10-17 19:54:30 INFO OGG-01520 Rollover
performed. For each affected output trail of Version 10 or higher format,after starting the source extract, issue ALTER EXTSEQNO for that trail's reader (either pump EXTRACT or REPLICAT) to move the reader's scan to the new trail file; it will not happen automatically. 04.EXTRACT altered. 05. 06.
07.GGSCI (RACD1.localdomain.com) 12> INFO RMTTRAIL * 08.
09.Extract Trail: ./dirdat/DE 10.Extract: RACDE 11.Seqno: 1 12.RBA: 1049
13.File Size: 10M 14.
15.Extract Trail: ./dirdat/DP 16.Extract: RACDP 17.Seqno: 1 18.RBA: 0
19.File Size: 10M 20. 21. 22.
23.GGSCI (RACD1.localdomain.com) 13> START RACDP 24.
25.Sending START request to MANAGER ... 26.EXTRACT RACDP starting 27. 28.
29.GGSCI (RACD1.localdomain.com) 14> info all 30.
31.Program Status Group Lag Time Since Chkpt 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-17 19:55:20 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT RACDP starting.
39.2012-10-17 19:55:20 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, racdp.prm: EXTRACT RACDP starting.
40.2012-10-17 19:55:31 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, racdp.prm: EXTRACT RACDP started.
41.2012-10-17 19:55:39 INFO OGG-01226 Oracle GoldenGate Capture for Oracle, racdp.prm: Socket buffer size set to 27985 (flush size 27985).
42.2012-10-17 19:55:40 INFO OGG-01052 Oracle GoldenGate
Capture for Oracle, racdp.prm: No recovery is required for target file ./dirdat/DP000001, at RBA 0 (file not opened).
43.2012-10-17 19:55:40 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, racdp.prm: Output file ./dirdat/DP is using format RELEASE 10.4/11.1.
29 Replicat 进程遇 OCI Error ORA-14402 错误解决办法 生产环境发票管理库到总局主数据库 Replicat 进程因报如下错误 Abended：
2013-04-25 07:59:50 WARNING OGG-00869 OCI Error ORA-14402: updating partition keycolumn would cause a partition change (status = 14402). UPDATE\= :a2,
\
2013-04-25 07:59:50 WARNING OGG-01004 Aborted grouped transaction on'HX_FP.FP_PZHDXX', Database error 14402 (OCI Error ORA-14402: updatingpartition key column would cause a partition change (statu
s = 14402). UPDATE\\
2013-04-25 07:59:50 WARNING OGG-01003 Repositioning to rba 355778 in seqno 83. 2013-04-25 07:59:50 WARNING OGG-01154 SQL error 14402 mapping HX_FP.FP_PZHDXX
toHX_FP.FP_PZHDXX OCI Error ORA-14402: updating partition key column would causea partition change (status = 14402). U
PDATE\\
2013-04-25 07:59:50 WARNING OGG-01003 Repositioning to rba 355778 in seqno 83. Source Context :
SourceModule :[er.errors]
SourceID :[/scratch/aime1/adestore/views/aime1_staxj16/oggcore/OpenSys/src/app/er/errors.cpp]
SourceFunction :[take_rep_err_action(short, int32_t, const char *, extr_ptr_def *,std_rec_hdr_def *, char *, file_def *, bool)] SourceLine : [623]
2013-04-25 07:59:50 ERROR OGG-01296 Error mapping fromHX_FP.FP_PZHDXX to HX_FP.FP_PZHDXX.
WARNNING OGG-00869根据官方的 Error Reference 中的描述，专指OGG遇到了特定的数据库错误，可以忽略。 OGG-00869: {0}
Cause: The specified database error occurred, but can be ignored. Action: Contact Oracle Support only if a problem persists.
但在本例中，replicat 进程遇到的数据库错误为OCI ErrorORA-14402: updating partition key column would cause a partition change，显然无法忽略。ORA-14402 错误一般是由于 update 操作更改了分区表的分区键的值触使该行迁移到其他的分区中。而表的 row movement 默认情况下处于禁用状态，从而导致报该错误。 [oracle@prod ~]$ oerr ora 14402
14402, 00000, \ // *Cause: An UPDATE statement attempted to change the value of a partition // key column causing migration of the row to another partition // *Action: Do not attempt to update apartition key column or make sure that // the new partition key is within the range containing the old // partition key.
Replicat 进程报错时正在修改的记录为： Logdump 7 >pos 355778 Reading forward from RBA 355778 Logdump 8 >n
___________________________________________________________________ Hdr-Ind : E (x45) Partition : . (x04) UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 91 (x005b) IO Time : 2013/04/24 20:33:00.010.627