Ensure the checkpoint was updated prior to detachment. This guarantees that when the Extract restarts, it knows exactly where to resume reading.
If you are dealing with a live issue, I can help you fix it if you let me know: Is the Extract currently in an or STOPPED state?
And then, the log spits out the message.
To understand the detachment message, we first need to understand how Oracle GoldenGate captures data in modern deployments. Ensure the checkpoint was updated prior to detachment
When reviewing this log entry, consider the following environmental factors:
SQL> SELECT CAPTURE_NAME, STATUS, CLIENT_STATUS, ERROR_NUMBER, ERROR_MESSAGE FROM DBA_CAPTURE WHERE CAPTURE_NAME LIKE 'OGG$CAP_%';
Therefore, the message simply translates to: "The GoldenGate Extract process has successfully released its hold on the database LogMiner session." And then, the log spits out the message
| Client Status | Interpretation | | :--- | :--- | | | The Log Mining Server is running and actively connected to the Extract client. This is the normal operational state for an active Extract process. | | DETACHED | The Log Mining Server is still running, but no Extract client is currently attached. This is the state the log message describes. | | DISABLED | The Log Mining Server itself is not running. | | ABORTED | The Log Mining Server encountered a fatal error and stopped. |
If the database instance is low on streams pool memory, it may forcibly detach the client. Network Instability:
The word "successfully" is critical. It implies that the detachment was planned or handled gracefully by the software architecture, rather than resulting from a crash, network abort, or sudden process termination. This is the normal operational state for an
GGSCI> INFO EXTRACT <extract_name>, DETAIL
The Extract is waiting for the database to complete processing a massive, uncommitted long-running transaction.
The process reached a specified end point (e.g., THREAD or EOF ) and closed safely. 🛠️ Related GGSCI Commands
The Extract ran out of Streams pool memory or system RAM.