The “OGG-01161 Bad Column Index” error is possibly one of the most reviled and misunderstood Oracle GoldenGate (OGG) error messages ever created.
Possible reasons of this error:
Source and Target structure should be different.
2014-05-19 13:32:37 ERROR OGG-01161 Bad column index (58) specified for table TABLE1.OGG01161,
To Identify this issue, you need to login into the both source and target databases try to find the definition of the mentioned tables, and you will find the difference between them.
Solution :
1. Alter the target table to match source and target table definitions.
alter table table1 add type(char 1);
2. and start replicate again and it should work and trail files started moving to further.
GGSCI > start replicat rep01
GGSCI > info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP01 00:00:08 00:00:00
GGSCI >
Now you will find that current replicat lag will start decreasing.
Possible reasons of this error:
Source and Target structure should be different.
2014-05-19 13:32:37 ERROR OGG-01161 Bad column index (58) specified for table TABLE1.OGG01161,
To Identify this issue, you need to login into the both source and target databases try to find the definition of the mentioned tables, and you will find the difference between them.
Solution :
1. Alter the target table to match source and target table definitions.
alter table table1 add type(char 1);
2. and start replicate again and it should work and trail files started moving to further.
GGSCI > start replicat rep01
GGSCI > info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP01 00:00:08 00:00:00
GGSCI >
Now you will find that current replicat lag will start decreasing.
