Goldengate Log Retention Don`t Work After Upgrade DB From 10g To 11g
Last updated on JULY 22, 2015
Applies to:Oracle GoldenGate - Version 18.104.22.168.1 and later
Information in this document applies to any platform.
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.
Database upgrade from 10g to 11g
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms