Goldengate Log Retention Don`t Work After Upgrade DB From 10g To 11g (Doc ID 1917999.1)

Last updated on JULY 22, 2015

Applies to:

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

Symptoms

Log retention used in goldengate classic capture mode used by registering extract, a underlying capture process was created.

In 10g the REQUIRED_CHECKPOINT_SCN will move after GG checkpoint operation. Then decide which archived log can be purged with RMAN.

Upgraded DB from 10g to 11g the REQUIRED_CHECKPOINT_SCN become to 0 and never change. RMAN cannot delete the archived log.

After upgrade to 11g “register extract logretention” doesn’t work as it was in 10g.

Changes

Database upgrade from 10g to 11g

Cause

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