OGG-00870 Database Error 30036 (ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS2'

(Doc ID 2410950.1)

Last updated on JUNE 21, 2018

Applies to:

Oracle GoldenGate - Version 12.3.0.1.0 and later
Information in this document applies to any platform.

Goal

The replicat experienced below error:



Instead of adding undo to the tablespace on node2, the DBA failed over the replicat to node 1. This error shows up now:

2018-05-10 08:52:01 WARNING OGG-02544 Unhandled error (ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS2') while processing the record at SEQNO 103, RBA 492934265 in Integrated mode. REPLICAT will retry in Direct mode.

The replicat does not seem to processing as the lag has not reduced since the failover.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms