OK, Have multiple issues going on with one of our GG environment.
The database which is involved in this GG replication is about 2TB and has LOB's with Partitions and SUB-Partitions.
First issue was that the GG Extract process hangs and only thing it reports is:
ERROR: sending message to EXTRACT EFLE01 (Timeout waiting for message).
Still working with Oracle on that issue.
Meanwhile, we were told to upgrade GG environment to 11.2.1.0.17. Even with this upgrade the issue is still not resolved and Oracle raised a bug with their team to see what's causing this hang.
Anyways, after upgrading to 11.2.1.0.17, the Pump group which was working fine in the same environment started giving this new error: (Basically, there is a bug introduced from 11.2.1.0.14 and thus this OGG-05500 errors)
OGG-05500 Oracle GoldenGate Capture for Oracle, PFLE01.prm: Detected database metadata mismatch between current trail file dirdat/la000010 and the previous sequence.
*DBCLIENTCHARSET: [1032]/[1073741824].
Went thru this Meatlink DocID#1602359.1 and fixed that Extract group.
But now, it started throwing the same error at Replicat side:
INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, RFLE02.prm: REPLICAT RFLE02 started.
2014-03-01 22:33:39 ERROR OGG-05500 Oracle GoldenGate Delivery for Oracle, RFLE02.prm: Detected database metadata mismatch between current trail file dirdat/rb000030 and the previous sequence.
Well, looking into info rfle02, detail it finished working with file 29 and file 30 was not able to read because of the upgrade. So, just altered the replicat (alter replicat rfle02, extseqno 30, extrba 0
) and started and its happy now.
Still dealing with another group is being stuck/hang... Hope to resolve that issue soon.
The database which is involved in this GG replication is about 2TB and has LOB's with Partitions and SUB-Partitions.
First issue was that the GG Extract process hangs and only thing it reports is:
ERROR: sending message to EXTRACT EFLE01 (Timeout waiting for message).
Still working with Oracle on that issue.
Meanwhile, we were told to upgrade GG environment to 11.2.1.0.17. Even with this upgrade the issue is still not resolved and Oracle raised a bug with their team to see what's causing this hang.
Anyways, after upgrading to 11.2.1.0.17, the Pump group which was working fine in the same environment started giving this new error: (Basically, there is a bug introduced from 11.2.1.0.14 and thus this OGG-05500 errors)
OGG-05500 Oracle GoldenGate Capture for Oracle, PFLE01.prm: Detected database metadata mismatch between current trail file dirdat/la000010 and the previous sequence.
*DBCLIENTCHARSET: [1032]/[1073741824].
Went thru this Meatlink DocID#1602359.1 and fixed that Extract group.
But now, it started throwing the same error at Replicat side:
INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, RFLE02.prm: REPLICAT RFLE02 started.
2014-03-01 22:33:39 ERROR OGG-05500 Oracle GoldenGate Delivery for Oracle, RFLE02.prm: Detected database metadata mismatch between current trail file dirdat/rb000030 and the previous sequence.
Well, looking into info rfle02, detail it finished working with file 29 and file 30 was not able to read because of the upgrade. So, just altered the replicat (alter replicat rfle02, extseqno 30, extrba 0
) and started and its happy now.
Still dealing with another group is being stuck/hang... Hope to resolve that issue soon.
No comments:
Post a Comment