GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

RMAN-08137: warning: archived log not deleted even though its not needed by GG

in GoldenGate, Streams and Distributed Database (MOSC) 6 commentsAnswered ✓

Version 18.1.0.0.0 OGGCORE_18.1.0.0.0_PLATFORMS_180928.0432_FBO

DB: 19.6

RHEL 7

old Archive logs are not getting deleted even though GG capture/Extract doesn't need it. What could be holding them and how to fix it.


GGSCI (infdbslmiad8009.aws.etscloud.org) 2> info ETEETMUT showch


EXTRACT  ETEETMUT Last Started 2021-02-01 10:35  Status RUNNING

Checkpoint Lag    00:00:00 (updated 00:00:09 ago)

Process ID      5130

Log Read Checkpoint Oracle Integrated Redo Logs

           2021-02-01 10:42:21

           SCN 1410.3622846205 (6059526733565)



Current Checkpoint Detail:


Read Checkpoint #1


 Oracle Integrated Redo Log


 Startup Checkpoint (starting position in the data source):

  Timestamp: 2019-06-24 11:10:35.000000

  SCN: Not available


 Recovery Checkpoint (position of oldest unprocessed transaction in the data source):

  Timestamp: 2021-02-01 10:42:21.000000

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center