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去删除 归档 ，就可以了 。