--DS==============12.2==================
GGSCI (adg) 6> info *
EXTRACT EXT_TC Last Started 2017-08-17 18:06 Status STOPPED
Checkpoint Lag 00:00:56 (updated 00:00:06 ago)
Log Read Checkpoint Oracle Redo Logs
2017-08-17 18:54:54 Thread 1, Seqno 7655, RBA 294750628
SCN 1.1665354184 (5960321480)
Log Read Checkpoint Oracle Redo Logs
2017-08-17 18:56:04 Thread 2, Seqno 6673, RBA 315052560
SCN 1.1665354453 (5960321749)
EXTRACT PMP_TC Last Started 2017-08-17 18:11 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:01 ago)
Log Read Checkpoint File ./dirdat/pg000000186
2017-08-17 18:54:54.000000 RBA 36182047
--DT==============12.2===============
GGSCI (mdw) 448> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
EXTRACT STOPPED FF_TEST 00:00:00 03:40:13
GGSCI (mdw) 446> info *
EXTRACT FF_TEST Last Started 2017-08-17 19:24 Status STOPPED
Checkpoint Lag 00:00:00 (updated 03:39:11 ago)
Log Read Checkpoint File ./dirdat/pd000000053
First Record RBA 8865309
--目标端文件损坏
./dirdat/pd000000053
==========================DS===开始处理==========================================
GGSCI (adg) 7> alter EXTRACT EXT_TC etrollover
2017-08-17 18:58:05 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.
EXTRACT altered.
=================================正常启动报错==DS==============================
2017-08-17 19:36:47 ERROR OGG-06601 Oracle GoldenGate Capture for Oracle, PMP_TC.prm: Mismatch between the length of seqno from checkpoint (9) and recovery (6) for extract trail ./dirdat/pd.
2017-08-17 19:36:47 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, PMP_TC.prm: PROCESS ABENDING.
--修改目标端有问题的文件
mv pd000000053 pd000000053.bak
--DS
GGSCI (adg) 27> alter extract PMP_TC,extseqno 186,extrba 0
GGSCI (adg) 138> info *
EXTRACT EXT_TC Last Started 2017-08-17 19:30 Status RUNNING
Checkpoint Lag 00:00:04 (updated 00:00:09 ago)
Process ID 14999
Log Read Checkpoint Oracle Redo Logs
2017-08-17 23:25:55 Thread 1, Seqno 7656, RBA 53385148
SCN 1.1666007829 (5960975125)
Log Read Checkpoint Oracle Redo Logs
2017-08-17 23:29:31 Thread 2, Seqno 6677, RBA 112704896
SCN 1.1666008309 (5960975605)
EXTRACT PMP_TC Last Started 2017-08-17 23:26 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:03 ago)
Process ID 893
Log Read Checkpoint File ./dirdat/pg000000186
2017-08-17 19:27:02.000000 RBA 219232
停止 PMP_TC 进程
GGSCI (adg) 142> alter extract PMP_TC,extseqno 187,extrba 0
start PMP_TC
目标端不用操作,自动转下一个文件
-rw-r----- 1 oracle oracle 846 Aug 17 18:52 pd000000051
-rw-r----- 1 oracle oracle 846 Aug 17 18:52 pd000000052
-rw-r----- 1 oracle oracle 218959 Aug 17 19:23 pd000000053.bak
-rw-r----- 1 oracle oracle 846 Aug 17 23:17 pd000000053
-rw-r----- 1 oracle oracle 219265 Aug 17 23:21 pd000000054
-rw-r----- 1 oracle oracle 846 Aug 17 23:21 pd000000055
-rw-r----- 1 oracle oracle 199999881 Aug 17 23:21 pd000000056
-rw-r----- 1 oracle oracle 199999855 Aug 17 23:22 pd000000057
这类故障很少出现,处理完后,查看一下MOS信息如下:
APPLIES TO:
Oracle GoldenGate - Version 12.2.0.1.0 to 12.2.0.1.0 [Release 12.2]
Information in this document applies to any platform.
SYMPTOMS
Running GG version 12.2, running on windows 2912 R2, pump fails with this error
ERROR OGG-06601 Mismatch between the length of seqno from checkpoint (9) and recovery (6) for extract trail T:\GoldenGate\dirdat\waats\1R.
CAUSE
Trying to read trail file which uses 6 digit checkpoint with version 12.2.
Version 12.2 uses a 9 digit checkpoint
ERROR OGG-06601 Mismatch between the length of seqno from checkpoint (9) and recovery (6) for extract trail T:\GoldenGate\dirdat\waats\1R.
SOLUTION
PART I
(1) Stop PUMP
(2) Stop Manager
(3) Add the following to your GLOBALS file
TRAIL_SEQLEN_6D
REASON: Tell GG to use 6 digit checkpoint
(4) Start Manager
(5) Alter Pump with ETROLLOVER
(6) Start Pump
(7) Allow PUMP to read local trail file and write them to a remote trail file
(8) Allow replicat to process all transactions.
Replicat should show 0 lags to indicate all transactions , from the source, have been processed on the target database.
REASON: Clean up existing trail files, created from a prior release to GG version 12.2, still using a 6 digit checkpoint
PART II : Assuming you had no problems with PART I
On Source:
(1) Remove TRAIL_SEQLEN_6D from GLOBALS
(2) alter ext E1 etrollover where E1 is the name of your extract which creates the local trail file
REASON: ETROLLOVER needed to convert 6 digit checkpoint to 9 digits as well as GG version 12.2
(3) Use the following to display the new sequence number of local trail file.
info extract E1, detail
or
info extract E1, showch
Write Checkpoint #1
Current Checkpoint (current write position):
Sequence #: xx
where xx = new sequence number of local trail file
(4) alter ext P1, extseqno xx , extrba 0 (where xx = new sequence number of local trail file and P1 is the name of your PUMP) --> to handle input trail #
REASON: Tell PUMP to use the new local trail file created in step (1)
(5) alter ext p1, etrollover ---> to handle output trail #
REASON: Tell PUMP to create and write to a new remote trail file
(6) Use the following to display the new sequence number of the remote trail file
info extract E1, detail
or
info extract E1, showch
Write Checkpoint #1
Current Checkpoint (current write position):
Sequence #: yy
where yy = new sequence number of the remote trail file
On Target
(1) alter replicat R1, extseqno yy , extrba 0
where yy = new sequence number + 1 of the remote trail file
Go back to Source
(1) Allow changes to be made to Source tables involved with GG
(2) Perform insert or update to verify it gets replicated to the target.
GGSCI (adg) 6> info *
EXTRACT EXT_TC Last Started 2017-08-17 18:06 Status STOPPED
Checkpoint Lag 00:00:56 (updated 00:00:06 ago)
Log Read Checkpoint Oracle Redo Logs
2017-08-17 18:54:54 Thread 1, Seqno 7655, RBA 294750628
SCN 1.1665354184 (5960321480)
Log Read Checkpoint Oracle Redo Logs
2017-08-17 18:56:04 Thread 2, Seqno 6673, RBA 315052560
SCN 1.1665354453 (5960321749)
EXTRACT PMP_TC Last Started 2017-08-17 18:11 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:01 ago)
Log Read Checkpoint File ./dirdat/pg000000186
2017-08-17 18:54:54.000000 RBA 36182047
--DT==============12.2===============
GGSCI (mdw) 448> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
EXTRACT STOPPED FF_TEST 00:00:00 03:40:13
GGSCI (mdw) 446> info *
EXTRACT FF_TEST Last Started 2017-08-17 19:24 Status STOPPED
Checkpoint Lag 00:00:00 (updated 03:39:11 ago)
Log Read Checkpoint File ./dirdat/pd000000053
First Record RBA 8865309
--目标端文件损坏
./dirdat/pd000000053
==========================DS===开始处理==========================================
GGSCI (adg) 7> alter EXTRACT EXT_TC etrollover
2017-08-17 18:58:05 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.
EXTRACT altered.
=================================正常启动报错==DS==============================
2017-08-17 19:36:47 ERROR OGG-06601 Oracle GoldenGate Capture for Oracle, PMP_TC.prm: Mismatch between the length of seqno from checkpoint (9) and recovery (6) for extract trail ./dirdat/pd.
2017-08-17 19:36:47 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, PMP_TC.prm: PROCESS ABENDING.
--修改目标端有问题的文件
mv pd000000053 pd000000053.bak
--DS
GGSCI (adg) 27> alter extract PMP_TC,extseqno 186,extrba 0
GGSCI (adg) 138> info *
EXTRACT EXT_TC Last Started 2017-08-17 19:30 Status RUNNING
Checkpoint Lag 00:00:04 (updated 00:00:09 ago)
Process ID 14999
Log Read Checkpoint Oracle Redo Logs
2017-08-17 23:25:55 Thread 1, Seqno 7656, RBA 53385148
SCN 1.1666007829 (5960975125)
Log Read Checkpoint Oracle Redo Logs
2017-08-17 23:29:31 Thread 2, Seqno 6677, RBA 112704896
SCN 1.1666008309 (5960975605)
EXTRACT PMP_TC Last Started 2017-08-17 23:26 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:03 ago)
Process ID 893
Log Read Checkpoint File ./dirdat/pg000000186
2017-08-17 19:27:02.000000 RBA 219232
停止 PMP_TC 进程
GGSCI (adg) 142> alter extract PMP_TC,extseqno 187,extrba 0
start PMP_TC
目标端不用操作,自动转下一个文件
-rw-r----- 1 oracle oracle 846 Aug 17 18:52 pd000000051
-rw-r----- 1 oracle oracle 846 Aug 17 18:52 pd000000052
-rw-r----- 1 oracle oracle 218959 Aug 17 19:23 pd000000053.bak
-rw-r----- 1 oracle oracle 846 Aug 17 23:17 pd000000053
-rw-r----- 1 oracle oracle 219265 Aug 17 23:21 pd000000054
-rw-r----- 1 oracle oracle 846 Aug 17 23:21 pd000000055
-rw-r----- 1 oracle oracle 199999881 Aug 17 23:21 pd000000056
-rw-r----- 1 oracle oracle 199999855 Aug 17 23:22 pd000000057
这类故障很少出现,处理完后,查看一下MOS信息如下:
APPLIES TO:
Oracle GoldenGate - Version 12.2.0.1.0 to 12.2.0.1.0 [Release 12.2]
Information in this document applies to any platform.
SYMPTOMS
Running GG version 12.2, running on windows 2912 R2, pump fails with this error
ERROR OGG-06601 Mismatch between the length of seqno from checkpoint (9) and recovery (6) for extract trail T:\GoldenGate\dirdat\waats\1R.
CAUSE
Trying to read trail file which uses 6 digit checkpoint with version 12.2.
Version 12.2 uses a 9 digit checkpoint
ERROR OGG-06601 Mismatch between the length of seqno from checkpoint (9) and recovery (6) for extract trail T:\GoldenGate\dirdat\waats\1R.
SOLUTION
PART I
(1) Stop PUMP
(2) Stop Manager
(3) Add the following to your GLOBALS file
TRAIL_SEQLEN_6D
REASON: Tell GG to use 6 digit checkpoint
(4) Start Manager
(5) Alter Pump with ETROLLOVER
(6) Start Pump
(7) Allow PUMP to read local trail file and write them to a remote trail file
(8) Allow replicat to process all transactions.
Replicat should show 0 lags to indicate all transactions , from the source, have been processed on the target database.
REASON: Clean up existing trail files, created from a prior release to GG version 12.2, still using a 6 digit checkpoint
PART II : Assuming you had no problems with PART I
On Source:
(1) Remove TRAIL_SEQLEN_6D from GLOBALS
(2) alter ext E1 etrollover where E1 is the name of your extract which creates the local trail file
REASON: ETROLLOVER needed to convert 6 digit checkpoint to 9 digits as well as GG version 12.2
(3) Use the following to display the new sequence number of local trail file.
info extract E1, detail
or
info extract E1, showch
Write Checkpoint #1
Current Checkpoint (current write position):
Sequence #: xx
where xx = new sequence number of local trail file
(4) alter ext P1, extseqno xx , extrba 0 (where xx = new sequence number of local trail file and P1 is the name of your PUMP) --> to handle input trail #
REASON: Tell PUMP to use the new local trail file created in step (1)
(5) alter ext p1, etrollover ---> to handle output trail #
REASON: Tell PUMP to create and write to a new remote trail file
(6) Use the following to display the new sequence number of the remote trail file
info extract E1, detail
or
info extract E1, showch
Write Checkpoint #1
Current Checkpoint (current write position):
Sequence #: yy
where yy = new sequence number of the remote trail file
On Target
(1) alter replicat R1, extseqno yy , extrba 0
where yy = new sequence number + 1 of the remote trail file
Go back to Source
(1) Allow changes to be made to Source tables involved with GG
(2) Perform insert or update to verify it gets replicated to the target.