Oracle Live

11/10/2016

Golden Gate – Error: Input checkpoint position is greater than the size of the file

Filed under: Golden Gate — mogukiller @ 12:05 pm
Tags:

En una migración me encontré este error en unos de mis replicadores de Golden Gate:

Input checkpoint position xxxxx for input trail file xxxxx is greater than the size of the file

Aplicando la nota (Doc ID 1138409.1) se consiguio resolver el problema.

GGSCI (mogudb11) 1> info all
/*
Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                          
REPLICAT    ABENDED     RP_SIRIO    00:00:04      02:48:34
*/

GGSCI (mogudb11) 4> start RP_SIRIO
/*
Sending START request to MANAGER ...
REPLICAT RP_SIRIO starting
*/

GGSCI (mogudb11) 1> info all
/*
Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                          
REPLICAT    ABENDED     RP_SIRIO    00:00:04      02:48:34
*/


GGSCI (mogudb11) 8> info RP_SIRIO detail
/*
REPLICAT   RP_SIRIO  Last Started 2016-09-02 03:31   Status ABENDED
Checkpoint Lag       00:00:04 (updated 02:58:02 ago)
Log Read Checkpoint  File /dbfs_common/DBFS/PPROV1/xa000231
                     2016-09-02 01:02:17.077395  RBA 78930482

Current Log BSN value: (requires database login)

Last Committed Transaction CSN value: (requires database login)


  Extract Source                          Begin             End

  /dbfs_common/DBFS/PPROV1/xa000231       2016-09-02 01:02  2016-09-02 01:02
  /dbfs_common/DBFS/PPROV1/xa000231       2016-09-02 01:02  2016-09-02 01:02
  /dbfs_common/DBFS/PPROV1/xa000231       2016-09-02 01:02  2016-09-02 01:02
  /dbfs_common/DBFS/PPROV1/xa000231       2016-09-02 01:02  2016-09-02 01:02
  /dbfs_common/DBFS/PPROV1/xa000231       2016-09-02 01:02  2016-09-02 01:02
  /dbfs_common/DBFS/PPROV1/xa000231       2016-09-01 16:50  2016-09-02 01:02
  /dbfs_common/DBFS/PPROV1/xa000196       2016-08-30 20:18  2016-09-01 16:50
  /dbfs_common/DBFS/PPROV1/xa000017       * Initialized *   2016-08-30 20:18
  /dbfs_common/DBFS/PPROV1/xa000000       * Initialized *   First Record


Current directory    /u01/ogg_12

Report file          /u01/ogg_12/dirrpt/RP_SIRIO.rpt
Parameter file       /u01/ogg_12/dirprm/rp_sirio.prm
Checkpoint file      /u01/ogg_12/dirchk/RP_SIRIO.cpr
Checkpoint table     OGG_ADMIN.CHKPTAB
Process file         /u01/ogg_12/dirpcs/RP_SIRIO.pcr
Error log            /u01/ogg_12/ggserr.log
*/

'Observamos que nos da este error'

[UH00042@tehol042 ~]$ vi /u01/ogg_12/ggserr.log
/*
2016-09-02 03:31:20  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, rp_sirio.prm:  REPLICAT RP_SIRIO started.
2016-09-02 03:31:20  ERROR   OGG-01705  Oracle GoldenGate Delivery for Oracle, rp_sirio.prm:  
Input checkpoint position 78930482 for input trail file '/dbfs_common/DBFS/PPROV1/xa000231' is greater than the size of the file (77877410).  <<<<< ERROR !!!
Please consult Oracle Knowledge Management Doc ID 1138409.1. for instructions.
2016-09-02 03:31:20  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, rp_sirio.prm:  PROCESS ABENDING.
*/

'Observacion: Es curioso que me dice que esta en un RBA mayor que el trail'

GGSCI (mogudb11) 3> info RP_SIRIO
/*
REPLICAT   RP_SIRIO  Last Started 2016-09-02 03:31   Status ABENDED
Checkpoint Lag       00:00:04 (updated 03:14:58 ago)
Log Read Checkpoint  File /dbfs_common/DBFS/PPROV1/xa000231 
                     2016-09-02 01:02:17.077395  RBA 78930482
*/                     
                     
[UH00042@tehol042 ~]$ ls -rtl /dbfs_common/DBFS/PPROV1/xa*
/*
-rw-r----- 1 usodbms oinstall 77877410 Sep  2 03:45 /dbfs_common/DBFS/PPROV1/xa000231
-rw-r----- 1 usodbms oinstall 99999701 Sep  2 03:45 /dbfs_common/DBFS/PPROV1/xa000232
*/


(PPROV12)usodbms@tehol042:/u01/ogg_12$ ./logdump
/*
Oracle GoldenGate Log File Dump Utility for Oracle
Version 12.1.2.1.0 OGGCORE_12.1.2.1.0_PLATFORMS_140727.2135.1

Copyright (C) 1995, 2014, Oracle and/or its affiliates. All rights reserved.
*/
Logdump 1358 >open /dbfs_common/DBFS/PPROV1/xa000232

Logdump 1359 >ghdr on
Logdump 1359 >n
/*
2016/09/02 03:45:14.093.526 FileHeader           Len  1102 RBA 0
Name: *FileHeader*
 3000 0210 3000 0008 4747 0d0a 544c 0a0d 3100 0002 | 0...0...GG..TL..1... 
 0003 3200 0004 2000 0000 3300 0008 02f2 61af f008 | ..2... ...3.....a... 
 7bd6 3400 0028 0026 7572 693a 7465 6863 6130 3163 | {.4..(.&uri:tehca01c 
 3a3a 7072 6f64 7563 7473 3a6f 6767 3a50 5052 4f56 | ::products:ogg:PPROV 
 305f 3131 2e32 3500 0058 3500 0028 0026 7572 693a | 0_11.25..X5..(.&uri: 
 7465 6863 6130 3163 3a3a 7072 6f64 7563 7473 3a6f | tehca01c::products:o 
 6767 3a50 5052 4f56 305f 3131 2e32 3500 0028 0026 | gg:PPROV0_11.25..(.& 
*/ 
Logdump 4229 >n
/*
Hdr-Ind    :     E  (x45)     Partition  :     .  (x00) 
UndoFlag   :     .  (x00)     BeforeAfter:     A  (x41) 
RecLength  :     0  (x0000)   IO Time    : 2016/09/02 03:45:14.068.907  
IOType     :   150  (x96)     OrigNode   :     0  (x00)
TransInd   :     .  (x03)     FormatType :     R  (x52)
SyskeyLen  :     0  (x00)     Incomplete :     .  (x00)
AuditRBA   :          0       AuditPos   : 0
Continued  :     N  (x00)     RecCount   :     0  (x00)

2016/09/02 03:45:14.068.907 RestartAbend         Len     0 RBA 1110
Name: 
After  Image:                                             Partition 0   G  s  
 */ 
Logdump 4230 >n
/*
Hdr-Ind    :     E  (x45)     Partition  :     .  (x04) 
UndoFlag   :     .  (x00)     BeforeAfter:     A  (x41) 
RecLength  :   422  (x01a6)   IO Time    : 2016/09/02 01:02:07.009.193  
IOType     :   115  (x73)     OrigNode   :   255  (xff)
TransInd   :     .  (x00)     FormatType :     R  (x52)
SyskeyLen  :     0  (x00)     Incomplete :     .  (x00)
AuditRBA   :          0       AuditPos   : 34873488
Continued  :     N  (x00)     RecCount   :     1  (x01)

2016/09/02 01:02:07.009.193 GGSPKUpdate          Len   422 RBA 1173

Name: PSIRIO.PGA_INDACTABO
After  Image:                                             Partition 4   G  b  
 00cd 0000 000d 0000 0009 3633 3830 3233 3637 3200 | ..........638023672. 
 0100 1500 0032 3031 362d 3039 2d30 323a 3031 3a30 | .....2016-09-02:01:0 
 303a 3032 0002 0015 0000 3230 3136 2d30 392d 3032 | 0:02......2016-09-02 
 3a30 313a 3030 3a30 3200 0300 0c00 0000 0839 3831 | :01:00:02........981 
 3133 3335 3700 0400 0b00 0000 0736 3034 3030 3232 | 13357........6040022 
 0005 0004 ffff 0000 0006 0006 0000 0002 5254 0007 | ................RT.. 
 0008 0000 0004 3030 3030 0008 0006 0000 0002 5354 | ......0000........ST 
*/

'New datapump / Replicat RBA = (Readers too-big checkpoint RBA) - (Actual size of datapump / replicat trail file (seqno X)) + First record in the new trail file (after the restart abend)'

78930482-77877410+1173=1054245


GGSCI (mogudb11) 4> alter rep RP_SIRIO, extseqno 232, extrba 1054245
/*
REPLICAT altered.
*/

GGSCI (mogudb11) 4> start RP_SIRIO
/*
Sending START request to MANAGER ...
REPLICAT RP_SIRIO starting
*/

Dejar un comentario »

Aún no hay comentarios.

RSS feed for comments on this post. TrackBack URI

Responder

Introduce tus datos o haz clic en un icono para iniciar sesión:

Logo de WordPress.com

Estás comentando usando tu cuenta de WordPress.com. Cerrar sesión / Cambiar )

Imagen de Twitter

Estás comentando usando tu cuenta de Twitter. Cerrar sesión / Cambiar )

Foto de Facebook

Estás comentando usando tu cuenta de Facebook. Cerrar sesión / Cambiar )

Google+ photo

Estás comentando usando tu cuenta de Google+. Cerrar sesión / Cambiar )

Conectando a %s

Crea un blog o un sitio web gratuitos con WordPress.com.

A %d blogueros les gusta esto: