Oracle Case 13--ogg-01163 Oracle GoldenGate Delivery for Oracle, REPRPT01.PRM

Due to the virtual machine host restart, causing a lot of virtual machine services need to focus on, one of the DG from the Library and another report library has ogg synchronization, so here again after the system Recovery check Ogg state, the target side of the replicat process is in Abend state, Restart is also invalid, specific information is as follows:

First, error message

Target End Ggserr.log

2018- -- in Ten: the: AboutINFO OGG-06510Oracle GoldenGate Delivery forOracle, reprpt01.prm:Using the followingKeyColumns forTargetTableGGS. T_emp.2018- -- in Ten: the: AboutERROR OGG-01163Oracle GoldenGate Delivery forOracle, Reprpt01.prm:BadcolumnLength ( +) specified for columnBANKinch TableCU. T_emp, maximum allowable length is  -.2018- -- in Ten: the: AboutERROR OGG-01668Oracle GoldenGate Delivery forOracle, Reprpt01.prm:PROCESS abending.

Ii. Causes of Errors

The error log shows that the Ogg process failed to start because of inconsistent table structures on the source and target sides. This is generally due to the source changed the table structure, the target is not changed, the source and target process does not restart the situation without affecting the synchronization, once the restart process can not be directly synchronized, that is reported as the error.

Third, the processing process

1. Troubleshoot the table structure on the source and target side

(The table structure is inconsistent, the target end through ALTER TABLE GGS.) T_emp Modify BANK varchar2 (21); Restart target process after change, still error)

2. Complete synchronization by creating a table definition file on the source and target side

Source-side Configuration

1) Configure the table definition file

1 >  /ogg/dirdef/cus.defuserid  ggs, password ggspasstable Cus.t_emp;

Defgen Paramfile./DIRPRM/DEFGEN.PRM

in the Dirdef directory to generate the file Dirdef/cus.def, the specific content is as follows

There is no later content, including the actual definition of the existing table structure, and so on.

2) The source side of the table definition file SCP to the target end of the./dirdef Directory

Target-side configuration

3) Add content to the Replicat process profile on the directory side

Ggsci (cusreport) 2> edit params REPRPT01

Sourcedefs/ogg/dirdef/cus.def Override

# #切记一定要假如override, otherwise it won't take effect

4) Restart the target side

Ggsci (cusreport) 3> start REPRPT01

At this point the Ogg data is restored synchronously.

Oracle Case 13--ogg-01163 Oracle GoldenGate Delivery for Oracle, REPRPT01.PRM