ERROR(OGG-05500) Detected database metadata mismatch between current trail file

Issue:

Goldengate replicat failed with error

ERROR   OGG-05500  Oracle GoldenGate Delivery for Oracle, *****.prm:  Detected database metadata mismatch between current trail file ./dirdat/ti005021 and the previous sequence

 

Solution:

This procedure stops Extract, and then creates a new trail file. The new database metadata is included in this new file with the transactions that started after any possible changes.

1.Stop transaction activity on the source database.

2.In GGSCI on the source system

issue the SEND EXTRACT command with the LOGEND option until it shows there is no more redo data to capture.

SEND EXTRACT EXTRACTNAME LOGEND

3.Stop Extract.

STOP EXTRACT EXTRACTNAME

4.On each target system

issue the SEND REPLICAT command with the STATUS

option until it shows a status of ??At EOF?? to indicate that it finished

processing all of the data in the trail. This must be done on all target

systems until all Replicat processes return ??At EOF.??

 

SEND REPLICAT REPLICATNAME STATUS

 

5.Stop the data pumps and Replicat

STOP EXTRACT PUMPNAME

STOP REPLICAT REPLICATNAME

 

6. Extract to roll over the local trail to the start of a new file

ALTER EXTRACT command with the ETROLLOVER option for the primary.

 

ALTER EXTRACT EXTRACTNAME, ETROLLOVER

7. Roll over the remote trail to the start of a new file

ALTER EXTRACT command with the ETROLLOVER option for the pumps

 

ALTER EXTRACT PUMPNAME, ETROLLOVER

 

8.Start Extract.

START EXTRACT EXTRACTNAME

 

9. Alter Extract and replicat to new sequence

New sequence number refers to the new trail sequence created by the ETROLLOVER..you could list the trail file directory to find out using ls -lrt. Use RBA 0 which tells the extract/pump or replicat at the beginning

 

ls -ltr ./dirdat/*

ALTER EXTRACT PUMPNAME, EXTSEQNO 11, EXTRBA 0

ALTER REPLICAT REPLICATNAME, EXTSEQNO seqno xx, EXTRBA 0

 

10.Start the data pumps.

START EXTRACT PUMPNAME

 

11.Start the Replicat processes.

START REPLICAT REPLICATNAME

 

Note: OGG-05500 Detected Database Metadata Mismatch between Current Trail File (Doc ID 1605434.1)