检查归档空间实用率时发现归档未能及时清理，检查清理角本的日志
发现如下报错
archived log file name=/archdest/arch_2_182500_920590168.arc thread=2 sequence=182500
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
oracle@racdb2:/archdest/ogg> oerr rman 8137
8137, 3, “WARNING: archived log not deleted, needed for standby or upstream capture process”
// *Cause: An archived log that should have been deleted was not as it was
// required by upstream capture process or Data Guard.
// The next message identifies the archived log.
// *Action: This is an informational message. The archived log can be
// deleted after it is no longer needed. See the
// documentation for Data Guard to alter the set of active
// Data Guard destinations. See the documentation for
// Streams to alter the set of active streams.
当的配置了归档保留策略（归档必须传到备份）时，如果归档还未传到备库，此时不能删除。
configure archivelog deletion policy to shipped to all standby;
检查日志已经传到备库并applied
后来从mos上查到如下文档
RMAN-08137: WARNING: Archived Log Not Deleted, Needed For Standby Or Upstream Capture Proces (Doc ID 1993799.1)
当一个不再使用的 GoldenGate Integrated Capture mode extract 未unregister，导致归档不能删除
检查DBA_CAPTURE确实存在一个未使用的capture OGG$CAP_EXT_F
SQL> select * from DBA_CAPTURE;
CAPTURE_NAME QUEUE_NAME QUEUE_OWNER RULE_SET_NAME RULE_SET_OWNER CAPTURE_USER START_SCN STATUS CAPTURED_SCN APPLIED_SCN USE FIRST_SCN SOURCE_DATABASE SOURCE_DBID SOURCE_RESETLOGS_SCN SOURCE_RESETLOGS_TIME LOGMINER_ID NEGATIVE_RULE_SET_NAME NEGATIVE_RULE_SET_OWNER MAX_CHECKPOINT_SCN REQUIRED_CHECKPOINT_SCN LOGFILE_ STATUS_CHANGE_TIM ERROR_NUMBER
------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------- -------- ------------ ----------- --- ---------- -------------------------------------------------------------------------------------------------------------------------------- ----------- -------------------- --------------------- ----------- ------------------------------ ------------------------------ ------------------ ----------------------- -------- ----------------- ------------
ERROR_MESSAGE
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
VERSION CAPTURE_TY LAST_ENQUEUED_SCN CHECKPOINT_RETENTION_TIME START_TIME PURPOSE
---------------------------------------------------------------- ---------- ----------------- ------------------------- --------------------------------------------------------------------------- -------------------
OGG$CAP_EXT_F OGG$Q_EXT_F GGADMIN RULESET$_3 GGADMIN GGADMIN 1.6615E+13 DISABLED NO 1.6615E+13 TBCSC.HEBEI.MOBILE.COM 0 0 0 1 0 0 IMPLICIT 20191218 00:17:24
—unregister后可以归档可以正常清理
GGSCI (racdb2) 3> dblogin USERID ggadmin, PASSWORD xxxxxxxxxx
Successfully logged into database.
GGSCI (racdb2 as ggadmin@racdb2) 4>
GGSCI (racdb2 as ggadmin@racdb2) 4> UNREGISTER EXTRACT EXT_F DATABASE;
2020-04-27 11:39:04 INFO OGG-01750 Successfully unregistered EXTRACT EXT_F from database.
SQL> select * from DBA_CAPTURE;
no rows selected
deleted archived log
archived log file name=/archdest/arch_2_183041_920590168.arc RECID=547118 STAMP=1038797135
deleted archived log
archived log file name=/archdest/arch_2_183042_920590168.arc RECID=547120 STAMP=1038798236
deleted archived log
archived log file name=/archdest/arch_2_183043_920590168.arc RECID=547122 STAMP=1038798296
deleted archived log
archived log file name=/archdest/arch_2_183044_920590168.arc RECID=547126 STAMP=1038798357
deleted archived log
archived log file name=/archdest/arch_2_183045_920590168.arc RECID=547128 STAMP=1038798416
deleted archived log
archived log file name=/archdest/arch_2_183046_920590168.arc RECID=547131 STAMP=1038798476
deleted archived log
archived log file name=/archdest/arch_2_183047_920590168.arc RECID=547134 STAMP=1038798916
Deleted 7 objects
