OGG-01489 and ORA-30567 on Capture Process With DDL Replication
(Doc ID 2766954.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle GoldenGate - Version 12.3.0.1.4 and laterInformation in this document applies to any platform.
Symptoms
Capture process is abended by OGG-01489 and ORA-30567 when DDL replication is enabled.
< examplme of error messages in ggserr.log >
2021-03-31T19:31:33.721+0900 ERROR OGG-01489 Oracle GoldenGate Capture for Oracle, <Capture>.prm: Could not add TRAN DATA for table, error [ORA-30567: name already used by an existing log group
SQL ALTER TABLE "<Schema>"."<Table>" ADD SUPPLEMENTAL LOG GROUP "GGT_<nnnnn>" ("<Column1>","<Column2>", ...) ALWAYS /* GOLDENGATE_DDL_REPLICATION */], error code [30567],
operation [ALTER TABLE "<Schema>"."<Table>" ADD SUPPLEMENTAL LOG GROUP "GGT_<nnnnn>" ("<Column1>","<Column2>", ...) ALWAYS /* GOLDENGATE_DDL_REPLICATION */ (size 128)].
2021-03-31T19:31:33.725+0900 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, <Capture>.prm: PROCESS ABENDING.
2021-03-31T19:31:33.721+0900 ERROR OGG-01489 Oracle GoldenGate Capture for Oracle, <Capture>.prm: Could not add TRAN DATA for table, error [ORA-30567: name already used by an existing log group
SQL ALTER TABLE "<Schema>"."<Table>" ADD SUPPLEMENTAL LOG GROUP "GGT_<nnnnn>" ("<Column1>","<Column2>", ...) ALWAYS /* GOLDENGATE_DDL_REPLICATION */], error code [30567],
operation [ALTER TABLE "<Schema>"."<Table>" ADD SUPPLEMENTAL LOG GROUP "GGT_<nnnnn>" ("<Column1>","<Column2>", ...) ALWAYS /* GOLDENGATE_DDL_REPLICATION */ (size 128)].
2021-03-31T19:31:33.725+0900 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, <Capture>.prm: PROCESS ABENDING.
Changes
There are multiple Capture (Extract) processes for same tables, and "DDLOPTIONS ADDTRANDATA" is enabled on Capture process.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |