12c adg 主库归档删除告警：RMAN-08137

--DELETE noprompt force ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-2';
--在主库上配置了Stream后，通过RMAN删除Archivelog时，遇到RMAN-08137错误
---执行删除操作告警
delete noprompt archivelog until time 'sysdate-2';

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/u01/arch/salesdb_1_38821_950811270.arc thread=1 sequence=38821
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/u01/arch/salesdb_1_38822_950811270.arc thread=1 sequence=38822
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/u01/arch/salesdb_1_38823_950811270.arc thread=1 sequence=38823
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

先看看是不是有capture进程有问题

select capture_name, status, captured_scn, applied_scn, capture_type  from dba_capture;

如果有问题，可以用如下的命令来删除capture进行

exec dbms_capture_adm.drop_capture(capture_name =>'OGG2$EXT_EMCF3359B3'); 

select CAPTURE_NAME, QUEUE_NAME, START_SCN, STATUS, FIRST_SCN from dba_capture;

CAPTURE_NAME                   QUEUE_NAME                      START_SCN STATUS    FIRST_SCN

------------------------------ ------------------------------ ---------- -------- ----------

OGG$CAP_EXTFX                  OGG$Q_EXTFX                    1.2773E+11 DISABLED 1.2773E+11

OGG$CAP_EXT_KAF1               OGG$Q_EXT_KAF1                 1.3648E+11 ENABLED  1.3648E+11

OGG$CAP_EXT_KAF2               OGG$Q_EXT_KAF2                 1.3648E+11 ENABLED  1.3648E+11

OGG$CAP_EXT_KAF3               OGG$Q_EXT_KAF3                 1.3648E+11 ENABLED  1.3648E+11

---删除DISABLED 状态的进程

exec dbms_capture_adm.drop_capture(capture_name =>'OGG$CAP_EXTFX');

---执行删除归档操作

delete noprompt archivelog until time 'sysdate-2';

archived log file name=/u01/arch/salesdb_1_38928_950811270.arc RECID=78145 STAMP=975074816 deleted archived log

archived log file name=/u01/arch/salesdb_1_38929_950811270.arc RECID=78148 STAMP=975075202 deleted archived log

archived log file name=/u01/arch/salesdb_1_38930_950811270.arc RECID=78151 STAMP=975075586 deleted archived log

archived log file name=/u01/arch/salesdb_1_38931_950811270.arc RECID=78154 STAMP=975075965 deleted archived log

archived log file name=/u01/arch/salesdb_1_38932_950811270.arc RECID=78157 STAMP=975076347 deleted archived log

archived log file name=/u01/arch/salesdb_1_38933_950811270.arc RECID=78160 STAMP=975076747 deleted archived log

archived log file name=/u01/arch/salesdb_1_38934_950811270.arc RECID=78163 STAMP=975077126 deleted archived log

archived log file name=/u01/arch/salesdb_1_38935_950811270.arc RECID=78166 STAMP=975077528 deleted archived log

archived log file name=/u01/arch/salesdb_1_38936_950811270.arc RECID=78169 STAMP=975077956 deleted archived log

archived log file name=/u01/arch/salesdb_1_38937_950811270.arc RECID=78172 STAMP=975078373 Deleted 3515 objects

For record type DELETED OBJECT RECIDS from 38258 to 38259 are re-used before resync

 

转载于:https://www.cnblogs.com/ss-33/p/8990751.html