使用了OGG后，无法删除归档日志，即使停了OGG，删除报 ：RMAN-08137

郑全

RMAN-08137: WARNING: Archived Log Not Deleted, Needed For Standby Or Upstream Capture Proces (Doc ID 1993799.1)

Applies to:  Oracle GoldenGate - Version 11.2.1.0.20 and later
Information in this document applies to any platform.
No archive logs are being deleted by RMAN, they all return RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process.
Symptoms

No archive logs are being deleted by RMAN, they all return RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process.

This is causing the archive log file system to be filled up. Appears that one of the orphan Capture process is holding up archives.

Changes
Cause

One of the obsolete integrated extract was causing Rman to not to delete the archive logs.

Solution

As seen below obsolete EXTRACT1_NAME is showing REQ_SCN = 0.

SQL>SELECT CAPTURE_NAME, CAPTURE_TYPE, STATUS, to_char(REQUIRED_CHECKPOINT_SCN,'999999999999999')as REQ_SCN ,to_char(OLDEST_SCN,'999999999999999')as OLDEST_SCN FROM DBA_CAPTURE;

CAPTURE_NAME    CAPTURE_TYPE STATUS          REQ_SCN      OLDEST_SCN
--------------  ------------ -------        --------      ----------
OGG$CAP_EXTRACT-NAME LOCAL        ENABLED        64983227        64983227
OGG$CAP_EXTRACT1-NAME LOCAL        ENABLED               0               0

After unregistering as follows RMAN was able to delete the old archive logs:

UNREGISTER EXTRACT EXTRACT-NAME DATABASE

ggsci> dblogin userid ogg ,password ogg;
ggsci>

UNREGISTER EXTRACT extmed database;

之后，再去查看
select

REQUIRED_CHECKPOINT_SCN from v$database,为空 了 ，

之后 ，再使用RMAN去删除 归档 ，就可以了 。